Whatever differences you are seeing are anecdotal. There is no difference in the two uses of the syntax in terms of performance. The statements will be optimized and executed the...

This is stating the obvious but your question seems to be a bit unclear, so here it goes.

If you need the same data multiple times then do not reload...

CREATE DATABASE (Transact-SQL)

If you're researching some odd behavior in a current system you can also check the list of patches Microsoft has released since the RTM here:

The SQL Server 2012 builds that...

Did you look in the SQL Server error log as the error message suggested? Were there any entries of interest around the time the scheduled integrity check ran?

A couple articles for you:

Books Online: Tail-Log Backups (SQL Server 2012)

A good, basic overview of the concept and why you would use it: Backing up the tail

Nothing wrong with having separate steps in one job, or have all calls in one step where the call is fully qualified. You can also use a USE statement if...

The more work you do in SSIS before you load the data into the staging table the less transaction log activity you will generate.

An UPDATE with no WHERE clause can take a relatively long time depending on how many rows are in the table. I do not recognize the table as one that...

I demoed Visual Studio features at one point and the rules are extensible.

Create and Register Additional Rules for Analyzing Database Code - Visual Studio 2010

Analyzing Database Code to Improve Code...

What you ask is too big of a topic to address in a general forum question such as what you have posted. Please have a look at this article:

A Performance...

Are you thinking of a nonclustered index? I think index ID 1 means it is the clustered index, i.e. the actual pages making up the table so the only way...

Ken Davis (8/17/2012)

---

Hello,

I have a complex SSIS package from a vendor. It includes an FTP task which moves files that total about 5gb. While the FTP runs, it...

A quick way to get started loading data with SSIS, as well as get a foot in the door to developing in it, is to use the Import/Export Wizard to...

OK, I can see that on the timeouts. On the 'could not allocate' I was thinking the other way, hundreds or thousands of requests all asking for 1MB autogrows simultaneously.

@julian-2,...