p.s.  And please provide answers to all of the questions I asked.  All of them are important to this and the idea I have in my head to accomplish this...

1) App team managed has to delete 1 million records, but when we trying to shrink the data file, the space is not getting released to OS. Why? how...

sp_phelp_remove isn't a native  SQL stored procedure.  Please provide the code for it or we're just guessing.

It would be of great benefit, like I said, to converse with the Developers of the code and see if  you can find out how they're creating the values for...

Thanks for the replies guys, I get s:\ and l:\ when I run those queries.  I have already checked the default paths thats why this is so confusing to...

Of course, you can do an immediate reseed to whatever number you want after that.  Heh... and if you want the table to handle up to 4 Billion rows, start...

I have a few servers where in my restore database dialog/wizard for some reason the default path to the files for "restore as" is missing the "\" for the...

We combine OPENQUERY against a LinkedServer and it does appear to help performance quite a bit (especially when pointing at AS400s or IBM PowerSystems).  I have no measured stats on...

I agree with John and will restate it... sys.dm_exec_sessions isn't the best idea by a...

Shoot... I'm just happy to be on someone's list. 😀 😀 😀

I meet Steve and Grant before they knew how to spell RedGate.  I don't remember exactly but it was...

good evening

I need to migrate packages ssis 2008 to 2017

I am looking for a method to export my packages that are on the 2008 server

on the net I find...

Query store capture long running query  for last 1 hr period  in following format

(@P1 bigint, @P2 bigint, @P3 bigint,  ...@P120 )select  Order_Id  from Orders where item_Id in (@P1, @P2,...

Thanks for the feedback.  IIRC correctly, PureStorage also makes it pretty easy to add on later.

As a bit of a sidebar and especially with SSDs, I tend to "over-provision".  It's...

Heh... I know you meant BILLION...

Great and thoughtful idea, Steve, but I'm not sure what you mean by...