I've just finished that test. The ONLY way I can make the script fail is with the final insert...

http://www.sqlservercentral.com/articles/Tally+Table/72993/

What's wrong with returning and empty resultset if there's no data?

I think you really need to read this as well because just killing the app that needs teh db ain't the solution :

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Free book on perf tuning (excellent) :...

Stolen from activity monitor (shows the blocking chains and waits really well)

--Borrowed from the activity monitor

SELECT

[Session ID] = s.session_id,

[User Process] ...

Quite easy with a calendar table.

Select top 1 * FROM dbo.Calendar WHERE Y = 2011 AND DW = <whatever fits your setting> ORDER BY dt.

I'm 99.99% sure you can't do and if (exec) like this.

You could do it with everything dynamic or insert the results to temp table and check for @@rowcount > 0

SQLkiwi (8/18/2011)

---

Remi,

You had convinced me that I was demonstrating a related problem, and not the exact one you are seeing in your database, so I created a Connect item of...

Retested on Denali, Snapshop isolation off db level gives the same error.

It really looks like all that dml and DDL is messing up with something.

The really scary part...

@PW. You can see the reason for my confusion => http://sqlcat.com/members/paul-white-nz/default.aspx

😀

Especially with all the super deep level 500 stuff you always blog about. Makes one wonder what the...

Jeff Moden (8/18/2011)

---

Ninja's_RGR'us (8/18/2011)

---

Sorry to break the rules but..

I've possibly discovered a bug that corrupts your db when doing a deployment script. I've tested on 2K5 sp3 and 2K8...

Thanks a lot, but it still looks like we have work to do on this one. 😉

Denali finally up and running. My script still fails the exact same way (as it is failing in 2k5).

Microsoft SQL Server "Denali" (CTP3) - 11.0.1515.0 (Intel X86)

Jul 11...

Only 1 problem @SqlWiki, [DateHistorique_fin] is not the leading column, it's the 2nd of 3 columns being changed from NOT NULL to NULLable.

ALTER TABLE [dbo].[RPT_Historique_Couts] ADD CONSTRAINT [IX_Historique_Couts_NoArticle] UNIQUE...

It's already in the zip file.