I have an Android phone and I use Google Calendar, especially since it integrates well.

Ninja's_RGR'us (10/26/2011)

george sibbald (10/26/2011)

if you restore the backup to somewhere with contiguous space, the data file will be contiguous.

So the fragmentation of the file after restore depends on the free...

Thanks George. That's what I thought, but I needed to get some confirmation. Sometimes what I think is logical and reasonable result is not right.

Of course the issue is that you'd then have to have a step on Success that makes sure the job is updated again to send an email for the next...

Your issue is with the encryption setting for your package. Open your package in BIDS and go to Properties -> Protection Level. Odds are you have it set...

If you haven't read the blog post,...

I'm not sure if this helps, but have you tried using the Filtering functionality in SSMS to find what you are looking for? It isn't the same, but it...

Couldn't you change your Where clause to exclude databases that are owned by the generic accounts that it is okay to have as a database owner? Then ALTER AUTHORIZATION...

I've been "lurking" on this thread to see some different opinions. I have to say I agree with Elliot so far. If I'm using SSIS I'd avoid...

Jeff Moden (10/24/2011)

It's a...

I'd just use a call to sp_testlinkedserver @servername. I think this is lighter weight than the script below. Then I'd also use sp_send_dbmail to send the email.

I have a question. Why the TABLOCKX hint on the temp table? What does it give you that the QP/QO wouldn't do anyway?

Can you post your .NET code? What does your query/command look like that is filling the dataset? If your query is using best practices and does not return...

If you google/bing SQL Server Max Memory Setting you'll find plenty of resources that talk about that setting being for the buffer pool. Here's just one, http://msdn.microsoft.com/en-us/library/ms180797.aspx

Edit: Changed the...

I'll defer to Gail on this, but CXPacket is the top wait type so I'd definitely look at what is getting parallelized and perhaps modify the Threshold for Parallelism setting....