Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,041 through 2,055 (of 59,067 total)

Reply To: The Complexity of Metrics

Heh... another "metric" that I'm really sick and tired of is "index fragmentation", especially when it comes to 3rd party vendors, both good and bad. You call them and ask...
--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)

January 30, 2023 at 3:21 pm

#4143340
Reply To: Read data based on date-range in huge table is slow

durai nagarajan wrote:
Hello Jeff ,
thanks but i suggested to consider not to create directly. as i don't see the plan, I suggested based on the data column he pulled.
I never created...
--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)

January 30, 2023 at 2:54 pm

#4143315
Reply To: DB Size

Talha222 wrote:
Optimizing indexes: Reorganizing or rebuilding indexes can improve the performance of a database and potentially reduce its size.
I strongly recommend against the use of Reorganize. It simply doesn't do...
--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)

January 30, 2023 at 2:36 pm

#4143313
Reply To: Read data based on date-range in huge table is slow

durai nagarajan wrote:
Can you consider Columnstore index , non clustered, if you need many columns & read is huge in the DB query.
Can we have full plan or highly used area...
--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)

January 30, 2023 at 4:51 am

#4143115
Reply To: The Complexity of Metrics

Great article. PLE reminds me of the "tree falling" riddle...
"If a tree falls in the forest (PLE crashes and starts coming back up) and no one was there to hear...
--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)

January 30, 2023 at 4:38 am

#4143114
Reply To: Are the posted questions getting worse?

SGAB, I had high hopes for the new GENERATE_SERIES() function in 2022, which I finally took the time to download the Developers Edition for and install. Things were looking promising...
--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)

January 30, 2023 at 4:26 am

#4143109
Reply To: Single index reorg took 2 full days or more to complete

p.s. If you want to see a presentation on all this, here's one that talks a lot about Random GUIDs just because they're the "poster child" for fragmentation. It shows...
--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)

January 30, 2023 at 3:29 am

#4143103
Reply To: Single index reorg took 2 full days or more to complete

JasonO wrote:
Or instead of reorg, will it be faster if I just rebuild index instead?
The answer to that question is a resounding OMG YES!!!! Even if you're in the Full...
--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)

January 30, 2023 at 3:23 am

#4143102
Reply To: DB Size

It sounds to me like the database was defined that large to begin with. And, no... SQL Server doesn't reduce the file size when data is deleted, either.
--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)

January 30, 2023 at 2:21 am

#4143086
Reply To: ROUND or CONVERT the output of the POWER function

And do remember that the resulting number is actually huge coming in at E33 and isn't just 3.97. Because of that, I'm seriously doubting this whole formula... especially since it...
--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)

January 29, 2023 at 5:40 pm

#4143021
Reply To: Blocking by select against sys.dm_db_index_physical_stats

Josh B wrote:
Ran a test after enabling TF 692 and continued to see blocking by the select against sys.dm_db_index_physical_stats, unfortunately.
Ooooo lordy. My apologies for missing your reply to your now 3...
--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)

January 28, 2023 at 4:22 pm

#4142819
Reply To: ROUND or CONVERT the output of the POWER function

Not being a math genius by any means, I'm still deeply interested in what the formula solves for?

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

January 28, 2023 at 12:39 am

#4142627
Reply To: ROUND or CONVERT the output of the POWER function

NM... Jonathan pulled it off mathematically. (Nicely done, Jonathan!!!)
I'd still like to know what question the math resolves. Thanks.
p.s. I know all the gazintas that Jonathan used to solve 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)

January 27, 2023 at 11:02 pm

#4142609
Reply To: Weird Log Backup Failure message

Lee Linares wrote:
I found the same error message in the SQL Error log on 3 dozen different SQL 2019 Standard instances. The message was:
BACKUP failed to complete the command BACKUP LOG...
--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)

January 27, 2023 at 7:22 pm

#4142552
Reply To: Roles in cluster

PJ_SQL wrote:
Hello!
When we failover one node from another, does the roles from the node failover to another node too?
Thanks
Test it. Even if someone says "yeah", you MUST test it!
I'd also...
--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)

January 27, 2023 at 7:14 pm

#4142551

Viewing 15 posts - 2,041 through 2,055 (of 59,067 total)