That kind of control, while well intended, may mask a bad DBA or admin.  I've seen rigid change control policies set up but management still does not question a...

Great question, Mike.

I'm thinking that it's...

the only way that can happen is if it is in the same session and the previous cursor did not shut down correctly

put a try catch block around the code...

another question - it's so blindingly obvious that I forgot to ask.

when you are shrinking, are you using truncateonly in the dbcc script?

lol - then we work 150 miles away from each other, but we do the same thing.

keep up the good work

this is always going to be slow, if you have pipe delimited fields then you're not even in 1st normal form (remove repeating data groups)perhaps put that data into a...

my advice

script it as delete 50 records then go for 500, then 5000 etc

time them and figure out your economy of scale.

Hi John

the original poster mentioned "when we trying to shrink the data file, the space is not getting released to OS. Why? how to reclaim the space?"

my understanding is that...

Yeah definitely possible but you need to map a drive from your synology to your laptop first, afterwards you can use this drive for your DB. And as MVDBA...

I suspect the ntext fields are why it's slow. it's not a huge number of rows, but quite a high data size... I am guessing here

as for reclaiming the space...

as far as i'm aware it's possible

https://ask.sqlservercentral.com/questions/33733/ms-sql-server-install-on-external-hard-drive-usb.html

just don't expect it to be fast

I have an application from a 3rd party vendor (a network monitoring tool) that uses the dac all of the time - if I need to use the dac then...

A lot of people will disagree with me on many fronts but I always keep an active SSMS session running in an RDP session on my production servers.  It...

hi - is this a datetime conversion error?

2nd question - if it is, is it stored in a varchar field

are you sure we don't work...