DotNetShoutout - #0138 - SQL Server – Performance – Best Practice – Create Index Before or After a data insert – I/O, Fragmentation, CPU and Elapsed time comparison - Test results

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

7
Shouts

Shout it

#0138 - SQL Server – Performance – Best Practice – Create Index Before or After a data insert – I/O, Fragmentation, CPU and Elapsed time comparison - Test results

published 438 days, 18 hours, 52 minutes ago posted by

dhara 445 days, 21 hours, 39 minutes ago

In November 2011, I wrote a post titled SQL Server – Performance – Best Practice – Create Index Before or After a data insert? . The post dealt with answering the question - which method was better – whether to create an index before or after a bulk-insert...

category: Data | clicked: 111 | | source: beyondrelational.com | show counter code

tags: SQL Server, TSQL

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout