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,...

GilaMonster (8/31/2012)

---

I remember seeing it, but back on SQL 2000. Maybe there was something else happening as well that caused it. Not sure.

There's also the case where autogrow takes too...

GilaMonster (8/31/2012)

---

Could be one of a few things

The DB has reached the max size it's allowed and won't autogrow any more

The autogrow's too slow, probably because the growth increments are...