And in 2005/2008, it's pretty easy to see the changes from the default trace. In Management Studio, right click on the server name, in Object Explorer, and select, Reports, Standard...

I'd say a basic backup and recovery plan should cover you well. Schedule a full backup on a regular basis. Most of our db's are less than 100gb, so we...

You'll get a much better response on new questions if you post them to the group at large. The only respondants you'll see here are those that are already subscribing...

avanch-990710 (5/7/2010)

---

I ran the SQL Upgrade Advisor and got the following issue that needs to be fixed before I upgrade. Have you heard about this:

--Object reference not set to...

There is no hard and fast formula as in "You MUST use it here, you MAY NOT use it there." It's a case by case basis.

However, one general rule you...

jacroberts (5/7/2010)

---

Grant Fritchey (5/7/2010)

---

Also, we make it a point of retaining the scripts that were generated for the final rollout to production, in case there's any question in the future...

Nadrek (5/7/2010)

---

A SAN is one thing; how the spindles are grouped is a completely different thing.

Are the backups sharing any of the same spindles (EMC Raidgroups) as the...

Carl B. (5/7/2010)

---

Hi Grant,

This morning we set the treshold to 25. Rigth after that, locking and performance problem arose. We waited but the situation did not tend to return to...

Jeff Moden (5/7/2010)

---

Grant Fritchey (5/7/2010)

---

Everyone turning off parallelism is ignoring the fact that some queries can benefit. I strongly recommend you explore increasing the cost threshold of parallelism before you...

Bradley B (5/7/2010)

---

most of mine have been taken, but I have a semi-clean story.

I was working with the Army on a FileNet project that had a SQL backend. All...

Brandie Tarvin (5/7/2010)

---

...enjoyable ranting & raving edited out...

On the other hand, the DELETE statements are kinda weird. I've never seen DELETEs phrased this way and I find myself thinking there...

I agree this sounds like parameter sniffing.

As an experiment, you can create local variables within your procedure and then use them in the WHERE clause. You should see a...

While waiting on the table defs, could you try this?

FROM T_IDYou.[dbo].[HST] h

LEFT JOIN srv1.T_id.dbo.MO s

ON h.refID=s.DistributorOrd

AND s.DistributorOrderNumber is null

Two things, using views is fine, but if you starting joining views against views, you can completely overwhelm the ability of the optimizer to simplify your queries to only use...

You should be able to use the processes outlined here to rebuild the tempdb with a different structure. It'll work the same way as if you were moving it.