SQL 2012 added a column "RecoveryUnitId" to the results of DBCC LogInfo.

Try this, tested on SQL 2005 and 2008, as well as 2012:

-- VLF = Virtual Log Fragments. Refers...

More details on the status of the databases, including database status, recovery model, log reuse status...

IF OBJECT_ID('tempdb.dbo.#stage') IS NOT NULL

DROP TABLE #stage ;

IF OBJECT_ID('tempdb.dbo.#results') IS NOT NULL

...

If you want to see more information than just the virtual log files count, you can include DBCC SQLPERF(logspace) and include the VLF counts like this. I prefer to...

Perry Whittle (5/8/2010)

I use FreeNAS and present the LUN's over iSCSI to the Windows 2008 cluster nodes. Check my tutorial at this link

http://www.stokecs.co.uk/TechDocs/Creating%20a%202%20node%20SQL%20Server%202008%20Cluster%20Configuration%20using%20Windows%202008%20MSCS.pdf

for details of how to deploy a...

Here’s one solution:

(although you could use local security groups for the SSRS security "roles" you need, I tend to use Domain security groups instead. Either way, add users...

paul-876346 (7/22/2010)

---

Thank you - I also wonder how the sub-query or join would compare to Cross (or Outer) Apply - as in the following query?

SELECT EmployeeID, Salary, RActive, CAM.ManagerName FROM...

:exclamation: I should also caution you about the other way to look at this:

If you insert/update/delete TABLE variable rows inside a transaction, and subsequently rollback the work, the...

If, for some reason, you wanted to keep track of work regardless of the transaction state, you could use a table variable instead.

Table variables exist outside the scope...

Nice script! Thanks for sharing, Jacques!

I made some mostly syntactical changes:

- can't assign default values to local variables in SQL 2005

- character case differences will break...

By default, we use a BINARY collation on my team. The TableInfo code has a few character case problems, which were easy to find and fix. Same goes...

Hot-Add memory on SQL server...  startup with -h option.

One subtle yet vitally important thing to bear in mind is that, on the 32-bit platform you *must* be using AWE if...

Don't forget that DTS packages don't necessarily need to be stored in the database.  

You can save a DTS...

OK, so we know it can be done... how about a working example of full-text search of Office documents stored in SQL Server 2005 VARBINARY column?