I believe you've hit upon the only two uses that I'd even think of letting someone write a CLR for. 🙂

The other thing is that, with the exclusion of...

Heh.... Bzzzzt! Wrong answer! Deduct 10 points! :P...

jlp3630 (11/3/2008)

---

What's the best test methodology for comparing the performance of multiple, logically equivalent versions of a stored procedure? Browsing through the internet, it seems that you should use the...

Heh... prove it. Got code? 😉

Heh... I beg to differ, Steve. You did NOT compromise. You simply made it easier for someone else to do the work and, as it turns out, may...

I would suggest you stop looking at costs in either the estimated or actual execution plans because it is frequently very wrong.

For example, given the following test data...

DROP...

1. I see no difference in the time when measured properly...

--SELECT GETDATE() as Time

--GO

SET STATISTICS TIME ON

CREATE TABLE #Temp_Example (

[CategoryID] INT NOT NULL,...

clive (11/3/2008)

---

1. Static query: (Clustered Index Seek cost is 100% - estimated execution plan)

Select * from tblContract_Instal1

where Contract_No = 4669

2. Dynamic query: (Clustered Index Seek cost not shown -...

Ummm......

The "E" indicates either "Engineering Notation" or "Scientific Notation". The "E+11" means "Times 10 to the 11th power". It won't fit into an INTEGER, but it will fit...

Awesome to know... thanks for the compliment, Seth. I really appreciate it. Heh... I also appreciate you getting to all of these before me! Makes my life...

What indexes do you have on the 3 tables?

Are you saying that you've revoked base table rights from users on a reporting database? If so, give it back!

Robert,

Take a look at the following article. It explains what a Tally table is, how it works, has a couple of examples including how to split a whole table's...

Matt Miller (11/3/2008)

---

I would usually advise to leave autogrow on. Not leaving auto-grow on means your database runs the risk of running out of space, in which case everything...