Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 59,067 total)

Reply To: Clustered Index leaves a lot of empty space

When you read this, Scott, remember that I LOVE page compression...
You say the following but you need to qualify, especially to a person who might not know what compression is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 29, 2022 at 12:09 am

#4081413
Reply To: Performance degradation - Help troubleshooting

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 11:18 pm

#4081410
Reply To: SQL Audit to File

Jeffrey Williams wrote:
Jeff Moden wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 10:55 pm

#4081405
Reply To: Clustered Index leaves a lot of empty space

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 5:00 am

#4081296
Reply To: Calculations in TSQL

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 4:51 am

#4081295
Reply To: SQL Audit to File

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 4:46 am

#4081293
Reply To: Read previous days transaction log .trn

I just looked up your user name and you're a known spammer.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 1:36 am

#4081273
Reply To: percentage of total trips broken down by month

Phil Parkin wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 1:29 am

#4081272
Reply To: percentage of total trips broken down by month

lin123 wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 1:24 am

#4081271
Reply To: sys.object

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 28, 2022 at 1:20 am

#4081269
Reply To: percentage of total trips broken down by month

lin123 wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 27, 2022 at 2:55 am

#4081101
Reply To: percentage of total trips broken down by month

lin123 wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 27, 2022 at 12:51 am

#4081087
Reply To: Cancel query and transactions

kuopaz wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2022 at 10:56 pm

#4081070
Reply To: between is not working the way I would think?

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......
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2022 at 7:10 pm

#4081036
Reply To: Clustered Index leaves a lot of empty space

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 26, 2022 at 7:02 pm

#4081035

Viewing 15 posts - 2,866 through 2,880 (of 59,067 total)