Hi Jason,

Thanks so much for your response --

I see how what you proposed makes it a single statement, but my main goal was to accomplish the UPDATE using a single...

The irony here is that we deleted all of those records so that we could save space. But obviously that never happened.....

I learn something about SQL Server every day --...

Hi Perry,

Yes, we have recently deleted a large amount of rows. In fact I was just in touch with Paul Randal about this, and he suggested that it might...

Hi Perry,

Thanks for your help --

BACKUP statement:

BACKUP DATABASE <dbname> TO DISK = 'D:\safetybackups\dbname.bak' with init, stats = 10

Table DDL:

CREATE TABLE [dbo].[Table1](

[PersistingId] [int] IDENTITY(1,1) NOT NULL,

[PayrollId] [int] NOT NULL,

[PayrollData]...

A bit more info --

I just did a fresh restore from the original .bak file (204GB)

sp_spaceused reports:

namerowsreserveddataindex_sizeunused

PayrollDataStore49824 123979096 KB123897912 KB2528 KB78656 KB

Performed a backup to...

OK - many not sleeping better just yet....

Originally I ran the DBCC UPDATEUSAGE WITH NO_INFOMSGS, COUNT_ROWS, so I thought that perhaps I missed something.

I just went to the source...

Gail and Perry - thanks so much for your help.

Both servers run SQL 2008R2. The source server is running RTM, and the new server is running SP2.

The database...

Hi Gail,

Thanks for your reply. I have some more info about the situation, and it seems quite strange to me.

Just to make sure I wasn't going crazy, I transferred...

Hi Perry,

Thanks for your reply.

I ran scripts to create users, roles and other permission/security related stuff. My scripts do not touch any user tables.

Will run the process again...

Thanks to all who have replied.

Steve - by SSD I mean Solid State Drives.

I did ran SQLIO when the server was first built. But then I discovered that...

MS only sells licenses for SQL 2012 now.

I'm not sure of your situation, but if your company purchases licenses in bulk, i.e. through a Volume License Reseller, I think...

One further thought - I'm not sure what the earliest version of SQL Server that Powershell work with, so it might not be a viable solution.

There are a number of ways to do this --

Servername, sqlservername,drive, totaldrivespace and availabledrivespace details

@@servername returns the machine name and sql instance name

xp_fixeddrives returns the drives and available drive space....

Does the instance in question utilize Read Committed Snapshot Isolation? This makes extensive use of TempDB.

sqlnyc

Hi Tim,

Thanks for your reply - we will be using FTP to copy the regular nightly backup to our dev server, so no need to use COPY_ONLY. But thanks for...