... and read the following to answer most of your other questions...

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-2017

I have a table with the following data . Some rows have col2 as null

col1 col2 col3

1 203 1232

2 null 2343

3 502 15566

4 null 4566

5 null 4545

6 601 4545

7...

Ahhh... I've got to disagree a bit.  Instead of changing to comparability level,  SQL Server 2017 does have the ability to use the old cardinality estimator at at least the...

Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and on...

Be careful now... if you do any work with SET IDENTITY_INSERT ON, you might want to reconsider especially on later versions where they essentially made Trace Flag 1117 ALWAYS active...

Here's a presentation by Paul Randal on the subject.  He's the guy that wrote most of the fragmentation related stuff.

https://www.youtube.com/watch?v=p3SXxclj_vg

Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and on the other...

Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and on the other hand, we...

Had a very pleasant surprise on Saturday!!!

I spoke in Providence on Saturday.  Among my audience were these two gentlemen, one of whom was Jeff Moden.  (Hi, Jeff!  Good...

Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is...

Whatever method you're trying, you're probably running into problems because you've defined the [FileName] column as a CHAR(400).  For the value of "ABC", that means the row contains "ABC" followed...

Heh......

Heh... just one of the many...

I'd definitely be interested in how someone might do this to avoid a Cursor and other forms of RBAR.

Even more interesting would be why the requirement to skew data in...

You're confusing space-used with space_allocated.  Also, you're settings appear to...