We need the actual table definition too, with indexes. Also, is that a character field stored to look like a date or an actual date data type?

fraze2001 (8/12/2013)

---

OK, so I've tested on an instance on another physical machine that is exactly the same hardware spec as the other physical and the physical running the VM. In...

sathiyan00 (8/13/2013)

---

it will be great if anyone explain or give some links to learn how sql server engine will process the query for some basic dml operations(delete,update,insert).

DELETE d1 FROM duplicate...

Umpteen things could be at play here. Most likely culprits include:

1) are you ABSOLUTELY sure all the IO is logical? If not, physical IO issues would be my...

In addition to the 32 bit SQL Server constraint, I also note that you are way behind on updates too. You are on base SP1 (2500) and the current...

I personally recommend a maxdop max value of the number of PHYSICAL CORES in each NUMA node. Go down from there if necessary.

SQLIO (and IOMeter) just test the raw capabilities of the IO subsystem

SQLIOSim tests SQL Server IO patterns and requirements

For benchmarking, try this: http://www.sqlservercentral.com/blogs/technobabble-by-klee-from-kleegeek/2013/07/29/benchmark-your-sql-server-instance-with-dvdstore/. I also think Joe Chang has...

Using ROW_NUMBER to do the duplicate deletes is another solution and I think can be more efficient in some cases. Search web for sql server row_number delete duplicates

SWEET! Apparently the engine does a pretty good job digging through the characters too:

SELECT o.name AS objname, c.name as colname

INTO tempo

FROM sys.objects o

JOIN...

Erland, don't the string stats only work from left-to-right in the string though? i.e. it can't know that the string 'cat' is going to be hit in this field...

1) Do you recall my telling you that we needed the table schema including indexes, as well as the actual execution plans for good and bad executions?

2) The IS NULL...

Please post table and index definitions and the full query AND the actual execution plan of both queries. Then, and only then, can we really figure out what is...

Sean Lange (8/7/2013)

---

Since you are doing a catch-all type query you should read up about the performance of these types of queries. Gail's article does a great job explaining the...

Yes, you are correct. And it is easy to validate.

Open 2 windows in SSMS. In one, do this (and leave this window open):

begin tran

update sometable

set somefield...

It's the Database!!! (8/5/2013)

---

thanks Kevin. Sharepoint 2013 does not use BLOB with a tool that we purchased so I can move forward with AG, I have tons of space so...