Statistics are maintained on the distribution of values in an index, for some values - not all. Since an actual distribution of values may follow a strange curve instead...

Theoretically...

We don't know the precise algorithms used by the query optimizer but I have seen similar behavior. If you only have 1000 rows, then likely they fit on a...

To change the outcome of an election, you may only need to tweak the voting machines in Florida and Ohio. The Pentagon has ties to the voting machines. ...

The fishbowl we swim in is relative truth - not absolute truth. That is what seems to be the thrust of this editorial.

Neural network algorithms don't change but the...

Unfortunately there are too many reports of misdiagnoses due to the old school "algorithms" doctors learn in school. The AMA and CDC seem to have egos that prevent them...

I use a simple product called dbSchema which can suck the design out of any database and into a diagram and file you can save as a file. ...

Multiple filtered indexes are perfect for handling different types of work queues for a table. When there is a work flow and rows change through many statuses each user...

I often create two filtered indexes when I have a need for an OR.

Filtered indexes are great when you need to enforce uniqueness on a nullable column.

Seems you almost got me in trouble. I was ready to throw out the whole script anyway. Whoever wrote it is just a hack and not a true...

Relational Databases should be using the terminology of "Referencing" and "Referenced" tables in place of "Child" and "Parent" when speaking of foreign keys. Microsoft is pretty good about this...

Well, if you go back to my original post you will see that I was talking about a unique clustered index.

...but everyone on this board is blind and has to...

Took me a while to get the database and filegroup references worked out and up and running. Not the worst code I've ever seen but very close to it....

And Eric...how is it that foreign keys are a performance penalty, other than one time at insert? Don't they provide information to the optimizer to make queries faster? ...

I certainly agree to use all available sources of help possible when deciphering a database's keys. My assumption is from the article that treats restoring a database to a...

Rarely if ever will query plans be available on a database given to a data warehouse or for importing. Otherwise running profiler or looking at DMVs might help.

The worst...