There are all types of settings that occur when you connect to SQL Server from any client. There's SET ANSI_NULLS, SET ARITHABORT, etc. If these are set differently from different...

There are no logs of what happened to a table. As Steve mentioned, there's a default trace, but it only keeps the last 25MB of stuff that happened on the...

Is that the only permission you granted?

What do you mean "solve it"?

SQL still has to run the query, read through the data, and process the results. They could change. The time savings usually comes from things...

Any of the diffs after the full will work. I'd think that typically you wanted the latest diff made after the full.

Isn't the backup finish time in the headeronly result?

What's the "app" on the app server?

In addition to what's noted above, I'd be sure you set the max memory that SQL will use so that it doesn't starve the...

This help?

http://sev17.com/2009/01/dynamically-register-sql-instances-in-sql-server-management-studio-2008/

Isn't it happy hour for you, Gianluca?

Relax, ultimately you want to be professional, but it's a job. Give you opinion, document, go with the crowd if they want to drive...

I completely agree with Gail. DO NOT put database files on the network. The network is for sharing resources, but SQL does that for you. It allows multiple people to...

I have queried the VC about recording. Andy did this at the Jacksonville code camp and it was well received.

bloopers

Getting ready for Mon. That and a baseball game with Ray K.

I'd implement the FK, document my issues, and pull it back out when he complained about performance.

You can build a simple SSIS package using the import/export wizard in SSMS.

I've been to the Summit most years, and there are two big values from going:

1. Getting great educational presentations that teach you things and get you to think.

2. Networking with...

I'd agree with Craig. Too many differentials increases your effort, and your risk. If that full cannot be restored for some reason, then you could lose everything.

At the very least,...