Don't ever let the defaults for auto-growth on a database occur... it takes 73 disk fragments just to reach 1GB using the default settings.

I'm with Steve... make sure the size...

The_SQL_DBA (9/29/2008)

---

When I put forth the idea and the risk involved in doing this conversion to management, they said they were better off without doing it. The reason being the...

OK... here we go... as usual, how the code works is explained as comments in the code...

/* Careful! This bit of code drops tables for test purposes! Could...

Wow! Someone either left you a heck of a mess, or you're trying to resolve a "hunt group" from an Avaya telephone switch (seriously, been there, done that). ...

I must admit, though, there is absolutely no need for the dynamic SQL...

DECLARE @TableNameSYSNAME

SET @TableName = 'dbo.JBMTest' --LOOK!!!! CHANGE THE TABLE NAME!!!!

SELECT TOP 1 [Rows]...

The problemwith all of you folks getting the Null is that you didn't read the script... it's setup to get the rowcount for a table called "TimeZones" which you probably...

Not "ShowConfig"... DBCC SHOWCONTIG

Heh... I can show you a query plan for two queries... one comes up with 100% of the batch size and the other 0%... when you run the queries, the...

Jackal (9/29/2008)

---

Hi all,

Jane, thanks for posting your article, one things I did notice was;

"Stored procedures should be named by function and the object they work on. Standard prefix like ‘p’,...

Heh... I think we have another set-based convert on our hands. Well done!:D

Liam Willis (9/22/2008)

---

Hi George

This is a very busy database and we took the decision a couple of years ago to switch off the auto update statistics as it was affecting...

Sounds like you've successfully made a believer out of someone, Matt. 🙂 Now, all we have to do is convert the other bazillion folks who think there is any...

Are you creating a stored procedure or just a script? I need to know...

Except in rare cases like a pass-through view (like a synonym), SELECT * will frequently (usually) make it impossible to do index seeks.

In other words, start by doing an OUTER JOIN on the homes table with all the other tables. Then, wittle from there.