FYI, all of these came with Paul's name on them, so he gets to be the target 🙂

It's partially the scoring, though if you look at a lot of NFL games, the typically only score 6-7 times between both teams. I think soccer, and hockey, just have...

If you have custom requirements for some auditing areas, there's nothing to say that you can't modify the generated code. We used to build a generic auditing trigger for tables,...

Just a point of clarification. You restore FROM a database snapshot TO the point in time when it was made.

Zzzzzzzzzzzzzzzzzzzzzzzzz

sameerchachad 69959 (3/9/2010)

---

I would just like to add a small point, whenever you create a Primary Key, by default its ALWAYS going to be Clustered. Unless you create a Non...

You will get a lot of ideas, and potentially learn quite a bit from speakers. It might be hard to understand at times, depending on sessions, but the chance to...

I think people are just shaking their heads when talking about me. No words needed.:hehe:

"how to store" has nothing to do with the indexing. Perhaps you should read a few links Gail posted to understand what in index is.

That's like saying should we use carpet in a building. There's no way to answer that unless someone knows what you are trying to achieve. If it's a warehouse, it...

Thanks , I guess someone else is working late

The half price admission cuts down the profit on the Summit so far that PASS can't do a referral fee to us. The $30 is pretty low, and lower than...

Crystal works, but check and see if does something you really need that SSRS can't do before you spend the $$$.

If you can move to SQL 2K8, or SS2K8 R2,...

The easy way to do this is write a script that checks if a particular job on your current server is still running. If that is the case, then you...

Reporting Services will allow you to do this. You would have to install it and create a report, but those can be saved as PDFs.

http://msdn.microsoft.com/en-us/library/ms159273%28SQL.90%29.aspx