And you can turn on line numbers so that they're displayed by going to "Tools," "Options," "Text Editor," "TSQL" and under the Display choice selecting "Line Numbers."

is it a multi-statement table valued function? They don't have statistics so they resolve as 1 row queries. If you're returning more than one row, then the execution plan is...

We were going to be dealing with exactly this issue. The plan was for there to be planned integration dates when all the development teams would check in their code...

There is clearly more than one way to skin a cat.

We don't always duplicate the AD groups and the Roles in the databases (we use Roles exactly as you described), but we frequently do. I don't mind lumping more than...

So some sort of data migration moved 10000 rows one day but only 1000 the next... Nothing changed in the query between the two days, right?

You'll just have to examine...

Just remember that the clustered index also stores the rest of the data with the table. You basically need to cluster on the most common access path to your data....

Just remember that the clustered index also stores the rest of the data with the table. You basically need to cluster on the most common access path to your data....

This should work:

SELECT t.TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES t

WHERE t.TABLE_NAME like '%some%'

I am sorry, but I really don't understand the question.

Do you mean you have a SQL Agent Job and you don't understand why it's running slow?

True. I was assuming a stored proc. Good catch.

SQL Server comes with a built-in modeling tool. It's EXTREMELY rudimentary, but it will get the job done. You can also pick up third party tools like Embarcadero's ERStudio to...

That's a huge question. If this is the first time you're doing it, prepare to make a LOT of mistakes. First, I'd suggest picking up a really old book called...

Errors with a severity of 20 or higher stop the transaction and cause an immediate disconnect. That disconnect may be preventing the PRINT statement from occuring.

A cleaner way to...

One of the best that I know of is located here.

As to dumps from the test... This isn't hacker heaven. You should probably ask that question elsewhere.