rebuilding the indexes is a maybe here... if you only keep 10 clients worth of data, you might not need to with so little selectivity.

checkpoint is a command, look it up in books online.

to shrink the whole db :

USE [PRODDB_restored]

GO

DBCC SHRINKDATABASE(N'PRODDB_restored')

GO

If you have active transactions in the system you won't be able to shrink the log, hence you need to back the tlog to allow the shrink (especially after a...

The only...

Care to make one (I can't find a better match)? I think you'd explain it better than me.

Let me know either way and I'll vote for it.

Is this the one G?

https://connect.microsoft.com/SQLServer/feedback/details/177308/enhancement-to-isnumeric

Do you have a link to the connect ticket? I'm searching on sql 2008 and I'm not finding it!!

Tx G... so I guess a small insert hit is not that big a deal after all :hehe:.

Compare both queries... you'll most likely find only 1-2 characters difference in the query and that will explain the 2 plans.

Or plan B not using the temp table and saving some overhead.

DECLARE @tst VARCHAR(100)

SET @tst = 'fail'

SELECT 1 WHERE NOT @tst LIKE '%[^0-9]%'

SET @tst = '0123456789'

SELECT 1 WHERE NOT @tst...

Jeff Moden (2/1/2011)

---

Craig Farrell (1/31/2011)

---

dajonx (1/31/2011)

---

Hi,

I was wondering if there is a way to remove a killed SPID that has been in rollback for a week without restarting SQL service....

I'm a total 0 in SSIS so I think I'd rather wait for your true framework.

I just opened the package and I just don't know where to start.

HowardW (2/1/2011)

---

I...

lindbergh_ddv (2/1/2011)

---

Thank you Ninja's_RGR'us. I noticed that warnings, and the 'query writers' are working.

The server update status is ** SQL Server - Product version: 10.50.1600.1 - Product level:...

What patch level are you on on that server?