If your DB is only 800GB and you have that many indexes, chances are the non-clustered indexes are pretty small so the rebuild process should go rather quickly (especially so...

It is the job owner's account unless you enabled/specified a proxy account at the server level, and that's the same account running your Agent service.

This may seem rather simplistic but you could try D-ECLARE @String char(17)

SET @String = ' =10 02=5608= '

SELECT LEN(@String) - LEN(LTRIM(@String))Perhaps create a simple scalar function to...

Fragmentation will occur (both within your databases and on the file system), and throughout the process it will cause some degree of contention, which depending on your system may impact...

If your last checkdb fixed the data consistency errors and you took a full backup afterwards, that backup would be good (albeit, you may be missing some data). If...

It's really "preference". Personally I like to segregate out my system stuff from the user stuff for my own peace of mind

I would recommend creating separate full backup &...

Probably more preferred to just select from the CTE where the RowNum = 1?SELECT * FROM dups d1

WHERE d1.RowNum = 1

I would create a simple function or just throw the results into a parameter table and loop through the spids, executing a kill command for each (you could also use...

Great! Because I've already jumped another hundred visits since yesterday 🙂

Wow I am shocked (and a little angry). I did notice a change to the signature but had no idea that it was because the carpet had been yanked...

If you have the option to add a new drive and initialize it, you could add the drive, take the old one offline, mount the new drive with the same...

I was actually just wondering the same thing! In the past week or so I've noticed that the counter is incrementing every click to a new page (and not...

What kind of disk subsystem is this server running on? SAN? Attached Storage? Internal drives?

Issues resolved. Gail, I sincerely appreciate the guidance

Steps taken (I know I got lucky):

1. IT-added new drive to the array, rebuilt it

2. Dropped the article from the Publisher

3. Deleted...

I have also found that the battery on the RAID controller is having issues; but I wouldn't think that would cause it?