Yes... it does NOT affect performance of what SQL Server does for page allocation...

Run the following: EXECUTE master.dbo.xp_cmdshell 'SET'

and then run SET from the command prompt. (make sure you are logged in as the account that the agent is running as). For me...

Ummm... actually, Scope_IDENTITY() is exactly what you want.

Crud... missed your reference where you explained it before. Sorry, John.

A whole lot more subtle than the obvious candidates for the "SQL Darwin Award" that you guys have shown, is my favorite clock-cyle waster/index defeater...

[font="Courier New"]AND ISNULL(somecolumn,' ') <> '...

Yes... don't forget that SQL_Variant can take up to 8016 bytes... if you have more than one SQL_Variant column...

Great minds think alike... and, frequently, at the same time. 😉

Linda Johanning (12/13/2007)

---

I have to reply to this post. Yes, I am tired of poorly built 3rd party applications too. For years our IT department didn't have any...

Sure... in fact, I'm honored :blush:. But, I would be very careful and I'd possibly do a bit of editing... the term...

Just in case you dislike cursors as much as I... see attached...

Good... you're trying to answer questions and that's a good thing. But go back and read...

Ummm.... not quite true in 2k or 2k5,...

Good, short, sweet coverage of OpenDataSource and some of the key advantages to using it and when to use it... Nicely done!

karthikeyan (12/12/2007)

---

1) How many types are there like 'P' ?

2) I did search in Google,but i didn't get clear information about the table.So can you explain me where we need...

Heh... Like what? There's no magic fix, no instant answers to such problems and all of the fixes take...