You'll have to do this from outside TSQL. I've done it two ways. First, write an app in .NET that opens threads and makes DB calls. It works, but it's...

Enormous topic. I'm just getting going with Reporting Services myself. Short answer, SQL Server Business Intelligence Development Studio. Long answer... This is the book I'm starting to read.

OK. That makes sense. I'm also not surprised it works like that. Thanks for the input.

Another guy just asked for something similar over in the Development forum. I had the same answer for him. I kind of thought it might be possible in CLR. Is...

The performance increase is pretty small in most cases, but it is there. It really depends though, if the data is fixed length, you should use CHAR/NCHAR for it. If...

Honestly, that's a tough one.

Best approach I can recommend is to establish a very tight discipline around your main production builds. They should only be done by a script that...

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.