Sure. I have separate scripts for creating table and for creating indexes.

SET ANSI_PADDING ON
GO


CREATE NONCLUSTERED INDEX [IX_User_LastName] ON [dbo].[User]
(
[LastName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

Thanks for the cover, Thom.  I should have posted the links like you did.

I was thinking the same thing but I've not yet seen it go parallel.  That's most likely because I don't use it for much of anything because it does require...

Again, just to say it out loud... use such methods at your own risk because MS has stated that there is to guaranteed output order from STRING_SPLIT().  I've not run...

Can you post the...

Each restart, yes, but also failovers, detach/attach, all sorts of variation on that data. It is the one place to try to determine if indexes are in use, but,...

For those of you that knew him, Gareth Swanepoel passed away on Friday - https://twitter.com/SQLBalls/status/1347722916700557319

He was a passionate member of the SQL community and a fellow speaker I've...

p.s.  The reason why I brought the subject up is because the "condition" we're talking about is that Inserts don't follow the Fill Factor but there is that one exception...

All true except for one thing... DELETES can actually cause logical fragmentation if the deletes empty a page.  SQL Server is smart enough to rewire the double linking to the...

Both you and Peter are correct.  Normally, Inserts do not follow the Fill Factor.  They will almost always try to fill pages to as close to 100% full as the...

I'd take out the...

Put your search words in another table.

SELECT  t.*
FROM    dbo.table1 AS t
WHERE   EXISTS (SELECT * FROM dbo.table2 AS x WHERE t.Product...

Execute this to see the fillfactor in use. You would expect 50% right?

DBCC SHOWCONTIG (tbl_user);

You are wrong. SQL Server uses 100% no matter what.

What happens if we rebuild the...

Thanks, Steve.

Given that you've stated this multiple times with an assortment of different "magic" fillfactors -- 51, 61, 82, etc. -- I don't think it's a "nitpick" at all.  So,...