You want the string after the last comma?

The one before the last comma would be LoanDate

DECLARE @str VARCHAR(250) = 'DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt'

SELECT REVERSE(LEFT(REVERSE(@str), CHARINDEX(',', REVERSE(@str))-1))

That can work.

Alternately you could aggregate the stuff you remove from the current table and just store the aggregated results if you don't need the details. Other option would...

You can't do that if the filegroup is offline, and besides, the OP stated that the...

Please note: 8 year old thread, and the author hasn't logged in in 3 years.

Buffer cache hit ratio is nearly useless as a counter.

Last time I saw this it did indeed turn into a catch-22 (worse in the other case as it was a production DB and the missing filegroup was completely missing)

As...

You're going to have terrible performance, even if you only have one or two of those. Terrible and erratic performance.

https://www.simple-talk.com/content/article.aspx?article=2280

After the fact, you don't. At the time it occurs, you could use something like Process Explorer to identify what has the file handle open.

Make sure your antivirus is correctly...

No, they're not both measuring pages read from disk. They're measuring completely different things

Memory\\Pages/sec is the rate at which pages are read from or written to disk to resolve hard...

Did you try the documentation? https://msdn.microsoft.com/en-us/library/ms189788.aspx

The nonclustered index is smaller, since it doesn't have the name column in it. Hence for a query that only references the ID column anywhere, the nonclustered index is slightly...

There is no solution to that. A log file is unlikely to contain all of the changes made back to the DB's creation, and you can't play it forward alone....

Full and log can run at the same time, so can diff and log. Diff and full block each other, so which ever starts first will run to completion first.

Then look for old files you can delete or move, and ask about getting more drive space.

Shrinking DBs...

Defaults. When you're creating a row and a column should go to a particular value, use defaults. If you need to set a column to a particular value when the...