One key word stands out in the problem statement, "almost." Variations in the results, even small ones, can result in larger variations in execution times.

However, that's usually when there's problems...

I agree with GSquared. The approach is not worrying about whether or not the partition is justified. They want to partition. Now, do they manage stored procedures in a central...

I generally look to scans & reads as the primary measure of how well a procedure or statement is performing, but when you're in the GUI, looking at the information...

Rog Saber (6/3/2008)

---

I have a scales table. Below is an example of data which may be in the table. A truck comes in with a trailer (or 2 trailers). I...

Absolutely. Nothing is perfect. I do love SQL Prompt, but I recognize it's weaknesses. For example, I've had it, out of the blue, chew up all the system resources. It's...

Amen to table variables and bad statistics. Especially table variables. I'd still love to see what Jeff's got on the subject.

Another one I haven't read but would like to is "The Art of SQL." I'm not sure of the authors name. Several people I talked to says it's a great...

And in addition to making sure the App is pointed at the right database, make sure you are.

I've never tried doing it like that before. I generally just schedule perfmon to collect counters during the anticipated runtime of a process like that. Also collect Profiler data and...

Definately post the execution plans.

Even without them, changing the collation on the fly is likely to prevent the use of an index on the column. IN clauses act as cursors,...

I would recommend starting with Itzik Ben-Gan's "Inside SQL Server 2005: T-SQL Querying." It's one of the best books on TSQL out there and I can't recommend it enough. I...

I'm not sure. When I drop the database, the files go away too. Did you detach instead of drop the database?

Whoa!

I've definately seen variation, but nothing that extreme. Yeah, I'd love to see those examples. I'm just starting an article on how to break down complex queries. I may have...

It's really two different queries. I'd split them into two procedures, even if you call them from this single procedure, have it call the other two procedures depending on the...

And...

FROM @Datalink.Query(1).Name@ DQ1,

@Datalink.Query(2).Name@ DQ2

LEFT JOIN DQ1 on SC_NAMES.SC_CODE = DQ1.SrcCode

You've got a couple of other problems. You're mixing a variable in for the schema owner? You can't do that....