I'm working through my 2008 R2 books until the 2012 material emerges. Most of the books listed on Amazon are out August I think.

Certification won't make you an expert! Experience is much more valuable.

I'm not actually sure what an expert is.

Wow - learn something new every day on this site. Fantastic!

I have to do this often on with the type of application I author.

My standard method is to create a history table which is populated via the INSERT and...

Shrinking is a bad idea as you'll probably end up with high index fragmentation thus affecting performance. Rebuilding the indexes to improve the performance will increase the size of database.

I'd suggest wrapping the column names in COALESCE in the event of a NULL value.

Select LTRIM(COALESCE(FirstName,'') + ' (' + COALESCE(LastName,'') + ')') AS FullName From MyTable

Check your database options...

I'm sure that SQL Server does not support regular expressions within TSQL; I'd recommend you create a CLR.

I'd probably recommend you install .NET will all service packs and patches and Visual Studio will all service packs and patches.

Although my edition was the 64-bit Business Intelligence version I'm...

Hi Welsh Corgi,

I did a search on Google (Search term: Repace comma with line feed in text file) and came up with the following:

There are a couple of solutions. This...

If you have the SSMS Tool Pack installed...

1. Open SQL Management Studio

2. Click SSMS Tools

3. Click New Query Template

4. Edit the text in the Template Text window.

5. Click OK

All done!

The second server has no SQL Server installed?

So is you question about attaching to database files located on a different domain?

Some more information would be helpful!

SQL Server Version? What's the job running?

And last but not least a connection string (please mask the password - we really don't need to...

I though Jumbo Frames (JF) were an end-to-end solution which therefore would require JF enabled NIC's on the server, the client and possibly some router configuration.

A properly set up JF...

As for getting the DB back, well, that's restoring a backup! You may be able to restore to a point in time depending on the DB's recovery model.

I think a bit more information would be useful.

For example, what statements are running on the server when the "blocking" appears?

Have you tried EXEC SP_WHO to view the...