It doesn't answer the question, but you can double click on the line next to the column and it will expand to the full size for you. A tiny bit...

Books online recommends not placing objects in Master. I'd recommend against it too.

Truth is, you can put objects there. You'll have to be much more careful about backups. You might...

Do you mean you want a script to generate the table? I ask because sp_help does show you the information about the table that defines it.

You could write up...

Thanks. I'm glad it was helpful. I originally wrote the thing when it looked like we had a success. I then went back and added new information to portray the...

The problem is, I'd be telling you how I feel. I have yet to work on a major project using ORM so I can't give you a list of quantifiable...

I don't think there is.

If "most" of your queries require DISTINCT or GROUP BY to eliminate duplicates then, in general terms, you're writing your queries incorrectly or the data design is wrong. While there...

I have to agree. 2 is fine. 1 & 3 are silly limitations. If you're going with pure natural keys, maybe then you never use identity, but if you're just...

Instead of using the sub-query as part of the select list, make it a derived table, join against it, and you'll get a row for each value in that table.

We're using them all over the place. It allows us to set up different security management processes within the same database and maintain them very easily since you can grant...

No, nobody should beat you up. "It depends" is always the right answer. The factors involved really do make a difference. If the system in question is meant to gather...

Everyone else has already said it, but I can expand a bit. XML is the answer. You want to look at ALL your database processes from the approach of working...

DonaldW (4/10/2008)

---

Grant Fritchey (4/9/2008)

---

Our starter questions are:

What's the difference between a clustered & non-clustered index?

What's the difference between blocking & deadlocking?

How do you trap errors in SQL Server 2005?

What does...

Our entire enterprise is running on TCP/IP connections (I suspect most are these days). If you can connect to your SQL Server instance and run 'SELECT * FROM SomeTable', then...

It's possible that it could be as problematic as anything else, but you might try dropping & recreating the index. That will also remove fragmentation. The Storage Engine team at...