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...

my only issue with 2 user authentication is when the "crap" goes sideways at 2am

it could be a new sql agent job or a new process from an app, but...

this normally occurs for one of 2 reasons (they are the bane of my life)

the execution plan is too big for management studio to handle (it's basically a big xml...

sorry - I clicked on the wrong button and reported the last entry - completely my bad. - I wanted to "quote"

I'd love to hear how you use...

root paths

I once failed a job interview where I was set a technical challenge to install sql and create a database (simple I know)

It was on a virtual machine with...

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

1. OPENQUERY is your friend. Linked servers and letting SQL Server figure out if, maybe, this...