This is slightly off-topic, but you may also want to consider simply using instancing if you're unsure of going with a VM environment. Lately I've come across many clients who...

So I've been doing some digging. Apparently everytime you run this system stored procedure, it creates an entry in msdb..sysreplicationalerts.

However, in this particular case, it did not create a record...

It can cause some trouble, but it can be done. My recommendation would be to use some sort of intelligent means of managing your indexes. Only rebuild indexes that need...

Thanks Gail, that is exactly the information that I was looking for.

I will play around with a piecemeal restore with files/filegroups sometime.

The backup time is far longer than expected. Looking...

SAN, and the SAN is configured in such a way that there may be little or not performance benefit from arranging files on different volumes.

From the documentation from our vendor:

"It...

Ahh, I see the problem now. It seems I have an untyped XML data type on that table.

http://msdn.microsoft.com/en-us/library/ms184277.aspx

This would be my problem.

Use typed xml data type in the following...

In a nutshell, I'm already doing that. I'm passing a recordset object to my ForEachLoop. The ForEachLoop processes each record and assigns them to a variable.

Edit:

From further research the problem...

You can configure the job to "go to next step on failure" instead of "quit the job reporting failure"

Thank you, da-zero. That worked perfectly!

Good feedback, thanks.

I think my biggest battle would be convincing others here to expand C drive volumes. These are going to be local physical arrays of RAID 1 and likely...

That looks like a really ugly bit of comparison. You most certainly are going to have a difficult time joining that data with a decent level of performance. You're going...

Thanks guys! That will be very helpful for me moving forward.

Hmm, I'd hate to say it ... but it might be a good idea for you to consider having a dedicated disk drive for SQL use. In some of my...

One thing you may want to do is change the memory allocation of your SQL instance. By default it will claim as much memory as you will allow it.

On my...

We had a gig or two of free space in the data file before I dropped this table. I then dropped the table and then looked to see how...