On twitter I asked you if this sproc does anything "special", such as XP calls, full text search, linked server, openquery, xml, etc. Are triggers in play?

Too bad it...

Sqlsavy (10/16/2012)

---

Thanks Kevin.

I ‘d certainly update you on the progress of this project we might end up having MS DSE assisting us .

Here is one more requirement from the Project...

Todd Young-359443 (10/15/2012)

---

I was able to work at home this weekend and found the answer. When calling

at UDF that does not access any database table and is used more...

If the delete is CAUSING blocking (are you using sp_whoisactive to watch what is going on?), I would look at the following:

1) no index on what you are using for...

Sqlsavy (10/15/2012)

---

Hi all,

We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early...

Thanks. I don't have all of the details at the moment about what are the exact objects and type of locks that are blocking, I do see that ALTER INDEX...

bteraberry (10/4/2012)

---

So if you're selling products you have to design...

Lexa (10/4/2012)

---

TheSQLGuru (10/4/2012)

---

Please show the code for the sproc. Does the sproc reference any UDFs by any chance?

Also, what tool/mechanism did you use to determine that this sproc was...

>>Working with big tables in DM environments, it's almost always worth putting an index or two on temp tables. Anything over 10k rows and it's likely to make a measurable...

aaron.reese (10/3/2012)

---

out of interest then; if I was selling books (ISBN, Author, Pages), wine (bottle size, ABV,Vinyard,grape,acidity) and shirts (material,collar type, sleeve length), how would you recommend storing the...

Please show the code for the sproc. Does the sproc reference any UDFs by any chance?

Also, what tool/mechanism did you use to determine that this sproc was doing the...

1) What is the point of this (isn't PRIMARY KEY sufficient by itself and the UNIQUE redundant?):

PRIMARY KEY (ID),

UNIQUE (ID))

2) I can probably count on 2...

Beware shrinking tempdb: http://support.microsoft.com/kb/307487

Maddave (10/3/2012)

---

Thanks guys, all very interesting stuff. I'm getting more in to how this application is implemented and it's becoming scary. As Sean Lange mentioned, the developers have...

Note that this places the onus on...