If you want an amazingly efficient way to collapse date intervals, see here: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals.aspx. Incredible TSQL goodness served up by Itzik Ben-Gan.

3 IN clauses deep with a DISTINCT using LIKE leading percent OR WHERE clause. Nice. 😛

I didn't see any variables here so it is fixed query, right? Perhaps...

Indianrock (6/21/2011)

---

Thanks Kevin, we are going to test forced parameterization on our dev environment. I checked yesterday and in production 20,000 of the 40,000+ cached plans are these single-use...

Anyone else find it ironic that a company is moving from a FREE SQL Server product to an Oracle product? :w00t:

get a copy of the awesome free tool SQLJOBVIS. Shows agent history as a gantt chart. Great for finding overlaps!

I agree with Gail. If you really want us to help you understand what you observed you need to give us details about before and after versions of the...

Forced parameterization is a sledge hammer and you best test it THOROUGHLY on all parts of the application.

By far the best way to go, that should also be relatively easy...

You should absolutely positively NOT use the CTE for this scenario unless you are guaranteed to have VERY few rows split out AND you do not have any signficant data...

This is an American cultural reference to a sometimes strange pop singer. Search the web for any number of VERY interesting pictures of outfits she...

Sachin4all (6/13/2011)

---

Begin Transaction Tran7

insert into #t (...)

SELECT ..

FROM #hs t

INNER JOIN table1 on

If @@ERROR <> 0

Begin

Rollback Transaction Tran7

INSERT INTO LogTable Values (7,@@ROWCOUNT,'F',@Startdate,getdate())

End

Else

Begin

Commit transaction Tran7

INSERT...

Dan.Humphries (6/16/2011)

---

Not to beat the proverbial dead horse here but I thought I would point out one such situation where we do a regular shrink of database files. I...

Nope, they sure aren't. ...

NOTE: I just came across columnar auditing at a client a few weeks ago. I found through testing that these triggers slowed down the DML by TWO ORDERS OF...

G-d it pains me to say this but I actually agree with Joe Celko. This is an absolutely, ridiculously bad idea!!!

With code generation tools you can have...

1) please tell the vendor that TheSQLGuru said they have their heads up their collective @sses. Also tell them that they need to get me or some other qualified...