Viewing 15 posts - 2,851 through 2,865 (of 59,067 total)
This is going to sound strange but it's happened where I work at twice now...
On high performance storage, there's usually a rechargeable cache battery. Most people don't even know such...
August 28, 2022 at 11:18 pm
Instead of using PowerShell, why not make a call to BCP and us the "out" functionality? It's nasty fast. I'll also tell you that if they have SQL...
August 28, 2022 at 10:55 pm
It doesn't take much to cause a page split with compression enable on tables that aren't suffering from page splits to being with. If you're going to use compression on...
August 28, 2022 at 5:00 am
What about your QA Department??? They're the ones that should be checking to see if things worked.
Also, did you check it? Have you found any problems with it? Generally, forums...
August 28, 2022 at 4:51 am
Instead of using PowerShell, why not make a call to BCP and us the "out" functionality? It's nasty fast. I'll also tell you that if they have SQL Server at...
August 28, 2022 at 4:46 am
I just looked up your user name and you're a known spammer.
August 28, 2022 at 1:36 am
Jeff, that's nice work. Thanks for reminding me of ROLLUP and GROUPING too.
Good sir, I'm humbled. Thank you for the very kind feedback. And thank you again for the...
August 28, 2022 at 1:29 am
Oh wow! Thanks for all the help guys, I just checked my servers and now it works. I greatly appreciate all the information I will be sure to take...
August 28, 2022 at 1:24 am
To be honest, we've been bouncing all over the place and you're posting snippets and a whole bunch of things. The only thing that I remember about of of this...
August 28, 2022 at 1:20 am
I have a massive data set which breaks down how many trips were taken on which days of which months for years 2016 & 2017.
What do YOU consider...
August 27, 2022 at 2:55 am
Sorry Phil - still doesn't work. Keeps coming up with syntax error, do you mind explaining to me what the purpose of the over command in line 3 of...
August 27, 2022 at 12:51 am
I open a new query window in SSMS and execute: EXEC stored procedure. The stored procedure contains BEGIN TRAN and COMMIT / ROLLBACK TRAN.
I hit the cancel button and...
August 26, 2022 at 10:56 pm
You should read the following article on the performance and other issues having to do with the STR() function.
And to those that say "Sometimes performance doesn't matter"... It always does......
August 26, 2022 at 7:10 pm
Just as a bit of a sidebar, remember that page compression causes CI rebuilds to take about 3 times longer. I'm NOT saying that makes it not worth it but...
August 26, 2022 at 7:02 pm
Actually, if you have LOB off-page data, that data will not be moved simply by CREATEing the clustered index on another filegroup.
To be sure, that's one of the many...
August 26, 2022 at 6:39 pm
Viewing 15 posts - 2,851 through 2,865 (of 59,067 total)