It's never a very popular thing to say, but don't share the SQL Server server with any other process. It's a pretty safe rule of thumb (yeah, there are exceptions).

The output will be to the error log. Get ready, it's messy.

I've never seen a performance hit from those flags or heard about one. We set ours on in...

You really do need to change the query in some fashion to get all three tables joined together

SELECT table1.column1

,table2.column1

,table3.firstname

...

I agree. But I do think you're climbing out on a limb to dismiss the use of column names. Yes, they're a pain the tucas to type, but you could...

You're going to need to clarify just a bit what you're talking about. Do you mean that some tool displayed things in this way? I'm not aware of a facility...

BEGIN and END are logical groupings and control flow statements within a TSQL statement. They aren't terminators to the SQL utility in the same way that GO is. So if...

You can make uniqueidentifiers null. So the problem lies somewhere else. Do you have a trigger on the table or a default on the column that would be causing this?...

While it gets messing to maintain, when we have a number of parameters that may or may not be referenced, basically a search screen, this is how we configure the...

I have to agree. The beauty of the auto-grow is that you don't have to sweat details like that sometimes. The only suggestion I'd make is to set the auto-grow...

Actually, you've got it right. It's going to update alll the rows from one table where the id's match in the second table.

Maybe you phrased the question wrong or I...

Once you identify the offending procedure using Gail's method, get execution plans to see what is occuring within the script.

Do you foresee a need to use character sets from other languages, Kanji, Cyrilic, what have you? No, use VARCHAR. Yes, use NVARCHAR.

99.999% TSQL.

The remaining bits I use C# or VB.NET through the SMO (SQL Management Object). Very little need for anything else.

I did go through a great book on using PERL...

montgomery johnson (12/3/2007)

---

Does anyone have a script that would help me identify users that are resource hogs? I need to know who is a resource when I run my script...

Gail is 100% correct. To add to it a bit, if your statement uses an index to retrieve the data, it frequently comes back in index order. The only way...