They're not stopped by that. They cannot be stopped by anything. They're the imprisoned souls needed to power this most...

Hmm, not great to have a perfectly valid answer marked as wrong!

Nice to know you can add the persisted property without dropping though.

I wonder if there's any real difference between...

Me too. Although google returned '1st May 2014' in massive letters so I got...

Easy one, thanks Steve.

I think one of the options should have been 'A supervisor of supervisors' though 🙂

Are you seeing lots of errors like this in the log, or was it just a one-off?

TomThomson (8/28/2014)

Tony's PRG used to have what were called "research officers" which essentially were representatives of industrial concerns that they were...

TomThomson (8/27/2014)

GilaMonster (8/27/2014)

Which is...

LEFT or SUBSTRING with a starting position of 1 are fine.

Investigate using the CHARINDEX or PATINDEX functions to find the point at which you want to cut off the string,...

Forgot to add this for the free space in your files:

use yourdb

go

select file_id, type, name, cast(size/128.00 as decimal(19,2)) AS [Size(MB)], cast((size-FILEPROPERTY(name, 'spaceused'))/128.00 as decimal(19,2)) AS [Free Space(MB)]

from sys.database_files

No problem, shrinks are fine if you've just deleted/moved a load of data like you have here.

It's a good idea to run an index defrag/rebuild afterwards though.

Don't know how you...

Hi,

I can't see any explicit shrink commands in the queries you've posted, what are you running?

SQL doesn't automatically release space to the OS unless you've got AutoShrink enabled on the...

Nice question, thanks

Might be a daft question, but is it still running (i.e. last run never finished)?

Are you using SQL Server 2008 or 2008 R2?

Powershell steps on 2008/R2 only run at Powershell 1.0 or 2.0 (and only a subset at that!), Enter-PSSession may not be available...

Ok, good to hear.

Cheers