Just read at Bob Beauchemin'd blog:http://www.sqlskills.com/blogs/bobb/post/Performance-features-in-SQL-Server-2008-RC0-Optimize-for-Adhoc-Workloads.aspx

"stub for the non-parameterized version, plan for the parameterized version"

Could you check/confirm that ?

edited: copied wrong ref.

This was RC0. should have been optimized by now...

please post the sqlserver errorlog file !

You need to elaborate a bit more regarding your move operation :

- did you shutdown the instance ?

- did you copy the folder structures...

I second GSquared and Gianluca suggestion too.

If your constraint cannot refer to a primary key or another unique constraint, replace the counting to existance check because your check = 0...

Darn, Steve, what happened to the horse ?

How did it get that kind of wound ?

I hope your vet can fix it.

check the sqlagent log file (sqlagent.out) if it holds some info regarding your troublesome job.

Keep in mind your hashes may produce duplicates as well !

Roy Ernest (6/17/2011)

---

GilaMonster (6/17/2011)

---

Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get...

why aren't you just making that column an identity column.

alter table x

alter column seqnr bigint identity( yourstartvalue, yourincrementvalue ) ;

Keep in mind, you should no longer insert that column !...

Have a look at http://www.sqlservercentral.com/Forums/Topic1126580-146-1.aspx#bm1127227

WayneS (6/16/2011)

---

Roy Ernest (6/16/2011)

---

Jeff, I am surprised that your session did not make the cut. I was looking forward to meeting you again. Darn.. Dont the MVPs get a special...

RedGate also has a nice free ebook on statistics.

http://www.red-gate.com/products/dba/sql-monitor/entrypage/statistics-ebook

How about this:

Select ITEMNMBR

, ROW_NUMBER() over (order by (select 1)) * 16384 as SeqNumbr

from IV00101

where ITEMNMBR not in...

Nice overview !

I always keep in mind this very to the point article by Brent Ozar (@BrentO) regarding our job and virtualization:

http://www.theinfoboom.com/articles/virtualizing-databases-too-big-to-fail/

Pay special attention on the real question !

opc.three (6/15/2011)

---

That's ridiculous :hehe:

How does one get the engine to store -0.00 ?

I tried:

USE test

GO

IF EXISTS ( SELECT *

...

jcrawf02 (6/15/2011)

---

Funny story for your amusement:

Last Saturday I attended my first SQL Sat in Columbus, and thoroughly enjoyed it. I had seen a tweet the day before in passing, where...