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

ms_foreachtable might not work if you have FK relationships. I don't believe the RI will allow you to truncate the tables.

Nice trick for using Database Mail in SQL Server 2000. I must admit I was wondering how you were going to do this when reading the title.

Thanks, Carl. Good to have that handy.

SQL Saturdays have ranged from a low of 50-60 people to a high, I believe, of about 400. The more successful ones have been 300+, but space limitations sometimes restrict...

Congrats, Lynn.