Yep, exactly. Service Packs are cumulative.

Well, yes & no. There really isn't any way to query all tables at once. But, you could set up a query where you UNION a query against each table,...

For me, the question is, one database or many, why are you splitting them? Do you have different applications with different sets of users and different sets of data and,...

Always remember, if you're in doubt of anything, test it. For an update query like this, I'd suggest wrapping it in a BEGIN TRAN and ROLLBACK TRAN and seeing how...

CavyPrincess (8/5/2010)

---

If you're interested in query-tuning performance, check-out this link. The book is available for free download, but I like paperbacks better, so I actually purchased it. I'm...

Since you're asking, I'll come right out & say it, look at my signature line and try my book on performance tuning.

In addition, I'd strongly recommend getting Itzik Ben-Gan's...

Dynamic Management Views (DMV) to the rescue!

Look up in BOL sys.dm_tran_*. You'll find more information than you can shake a stick at. You can combine this with other DMVs like...

First suggestion, follow Gail's advice. Enable traceflag 1222. It will give you a lot of useful information. If you're experiencing lots of deadlocks, usually, it's your TSQL code. It could...

Excellent! Have fun at the new place and best of luck to you.

Best of luck Steve. I don't think you...

Also, both types of indexes are ordered logically. Physical ordering is not guaranteed. Regardless though, details are not the issue. 99 indexes is the issue.

You're going to find that Oracle is very difficult to use and maintain without quite a lot of training. SQL Server really is easier. But in the long run, you'll...

And if you really want to go to town with it, you should check out Mladen Prajdic's excellent SSMS Tools Pack[/url]. It lets you do a bunch of stuff with...

GilaMonster (8/5/2010)

---

Grant Fritchey (8/5/2010)

---

Praveen Goud Kotha (8/5/2010)

---

Thank you all the members for their replies/suggestions who participated in my topic..

especially for Fritchey..

If any other reasons for "Reasons for difference in execution...

Right, that last post, that was to a completely different thread... uh, Steve, DBCC Timewarp is acting up or something.