Oh yeah, this is a major SQL Server tool if you can put it to work. Talk to Tom LaRock some time. He's gone way past where I am currently...

That's what I mean when I say you have to learn how to work with the tool. I generally type 'SELECT * FROM' and then start building the FROM clause...

Problem is, you can't do the CASE statement like that. You have to use an IF and this becomes a multi-statement query.

Maybe you need to better define what you're looking for. ALZ's solution shows procedures that are running and how long they are taking. Determining whether or not a query is...

A table valued function does require you to define the structure of the table. So, no, this won't work the way you want. I'm not at all sure, but I...

I'm glad it was helpful.

I haven't used JPA, but our developers have been making noises about nHibernate. I did some tests with it. The basic parameterized queries ran similarly to stored procedures. But the...

Thanks guys. I realize it's kind of an obscure topic, but I had such a hard time tracking down the individual pieces of information that I felt compelled to share...

That's a report definition file, a part of Reporting Services used by the Management Studio to show the data. It shouldn't be something you have to create.

That's actually what the report is doing. I watched it through Profiler.

You can add a nullable column to a table using alter table. It won't affect the rest of the table at all.

NO CHECK is functionality around check constraints. If you...

Cool! I'm glad to hear something worked. Thanks for the feedback.

Not a problem. Just alias the table. Self-join or not, you're looking at the equivalent of a cursor.

Yeah, I actually posted some comments about that issue at your other post.

Not seeing the code or the execution plan, it's hard to say, but it could be parameter sniffing...

First, based on what you said, don't use table variables. Performance will likely degrade.

Second... It really depends on what's going on here, but in general, views serve two purposes. They...