Just so you know, this can frequently result in slower backups that cause some visible load on the server. I prefer to backup locally and then move the file across...

There must be an error message reported in the maintenance job or in the logs. Find that error. If it doesn't tell you exactly what the problem is, post it...

Funny, I'm going to come down just the opposite and say that I like option B for the same reasons that Jeff likes option A. I don't like having to...

No accountants here either... Nurses, Receptionists, Sales people... those I've seen try to be DBA's. Nurses weren't so bad, neither were the receptionists... keep the sales people away from the...

It sounds like a classic case of parameter sniffing. Try updating your statistics. If that doesn't resolve the issue, you may need to use an OPTIMIZE FOR hint on the...

And I've seen the opposite. Until a recent bug fix, it was missing indexes that were blatant and obvious that resulted in major performance improvements. There's an MS Connect issue...

I like the OUTPUT mechanism for batch inserts, but if you're doing single row inserts, you should be fine with SCOPE_IDENTITY() in almost all cases. If you read through the...

Thanks. We'll try that too.

For some reason when we turned implicit transactions off, we were able to get the install to run. I'm still trying to find out why one...

Layne-812700 (10/19/2009)

---

Grant Fritchey (10/16/2009)

---

Layne-812700 (10/15/2009)

---

whatever size or type of data I use, they present the same result. You might disagree, but the first one is only a shortcut in my...

maperkins (10/19/2009)

---

Good DBAs in History: How about George Washington Carver.

Thousands of experiments, many resulting in useful ( or delicious) products. He even made a diamond out of...

Fallen Angels

If it's making calls to the database you should be to see them. If you're not seeing them, there must be something wrong with your trace configuration, server settings, filters......

Slick84 (10/16/2009)

---

Slick84 (10/15/2009)

---

Weitzera,

Thanks for the input. You definately are making sense and yes the requirement you described is how I want it. I'm basically inserting records from tblRegularItems into tblProductSizeWidthColor...

SQL Server will manage it's own memory, so from the OS all you'll see is that SQL Server is using X, in this case 5gb. You can limit the amount...

First, I'd strongly suggest switching to ANSI 92 syntax

SELECT...

FROM a

JOIN B

ON a.id = b.id

Second, you don't have any kind of filtering, so the query is going scan all the...