Check here instead. Microsoft usually keeps these pages pretty up to date. But you're right, no CU for SP4.

There are both tools and education resources on source control and it's use on this page at Redgate Software[/url].

I'm with Lowell, rpc_complete would be the way to do this. But, just for an example, I did one that captures sql_batch_complete so that I can test it from SSMS:

CREATE...

patrickmcginnis59 10839 (2/19/2015)

---

Eric M Russell (2/19/2015)

---

OK

When a table is...

Volunteer to build databases for organizations in your area, soup kitchens, synagogues, Scouts, whatever. That'll get you experience, which is the most needed commodity when looking for a job.

It's usually very dangerous to compare cost to cost between different queries. Since the costs are just estimates, when the query changes, so do the calculations. Costs are good within...

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

Grant Fritchey (2/19/2015)

---

shane.green 1227 (2/19/2015)

---

There are exceptions to every rule, so while "All tables should have at least one index" is good rule - it doesn't...

I strongly suggest you start putting your database code into source control in the same way as you would manage your application code. If this code is "important" as you...

You're not using this in any other place in the query? I set up a test:

SELECT CASE cr.CountryRegionCode ---Mod # 2 Start

...

I wouldn't say either is better either. From what I can tell I think I'd have the same issue with both. I think you're going to get a single plan...

In addition to Gail's excellent articles, for even more detail, check out my book on query tuning in my signature below.

You might also look at the free book Troubleshooting for...

Check your Configuration Manager to see if you have any config issues, aliases, something along those lines. Compare your Config Manager to the person who is successful to see if...

The single best validation is to use the backup to restore a database. But, the second best validation is to use RESTORE... VERIFY_ONLY. I wrote an article about backup validation[/url]...

You can get a ballpark guess as to the status of a backup by looking at sys.dm_exec_requests. It shows a percentage complete for backups. Now, it's not terribly accurate, but...

We had different servers with different Service Level Agreements. When the backups on the highest SLA failed, it was an oncall situation because we had to have a 10 minute...