Without being able to profile things, I'd start by putting all logs on SSD since nothing happens in sql server until it gets logged. Move the main data off...

Not sure if you need the structure or the data; ideally you want both of course. I haven't lost data since a sql server 6.5 bad service pack but...

Freaky code! I simply never specify constant strings nor values inline. And I heavily use cast when something is unknown. I would implement a constant with something...

Non-unique indexes are never "required" because they don't constrain nor define schemata. Also, I don't think DBAs want job security through babysitting indexing needs; we have more important things...

If you love heaps as much as I do, you'll be adding the primary key column as an included column for most of your indexes. Many of my queries...

Top-down design usually results in failure; see any centralized government.

Bottom-up design is used by evolution and in my opinion is a thousand times more intelligent than humans.

The two extremes are...

Awesome article, thanks!

For the free sql server version limited to 10 GB, Alter becomes a problem. I've gotten into the routine of always copying a table to an empty...

I believe it would have to do with scoping, default schemas, and different objects showing up depending on who is running the query and which parts of the names are...

The original poster asked for a "good" site as opposed to "any" site that one can find on google. Sometimes that can save a person hours of not downloading...

Glad you could find something useful. They're dated, some being written for 2005. My favorite is the genetic algorithm game and single-handedly making other companies lose valuable DBA...

henrik staun poulsen (8/5/2010)

---

I'm looking for an explanation for some of the abreviations.

pk is Primary Key

ak is Unique Constraints ??

udx is Unique Index

idx is non unique index

"+" means that the...

Sure, the TOP clause accepts a parameter, just in case someone wants to make this a table valued function for returning 3, 12, or 300 dates. BTW, I do think...

There was no CASE statement in sql server 2005. All my GOTOs jump to the same place. I'm not one to discard any command or specialty tool although...

I believe scientists rely on hardware solutions such as radioactive decay detection devices to get true randomness.

I stay away from pseudo random data generation and try to approach real-world distributions....

Awesome article Daniel! Guys on the leading edge always get bashed by the sheeple detail workers. Personally I can't wait for the Singularity when computers become smart enough...