Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,921 through 7,935 (of 59,098 total)

Reply To: Require Recommendations | Index Rebuild

Michael L John wrote:
I agree. Download and run Ola Hallengren's solution. It's far more complete, and is far more flexible, than what you have written.
https://ola.hallengren.com/
Ola's code is, indeed, the "Gold Standard". ...
--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 14, 2020 at 4:28 pm

#3715281
Reply To: Require Recommendations | Index Rebuild

Ola's code is great but it doesn't help you if you use the current "Best Practice" (it's not) of blindly rebuilding indexes after you've exceeded 30% logical fragmentation. Even "Books...
--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 14, 2020 at 4:23 pm

#3715278
Reply To: SQL Query Performance problem

Tony... what is your Cost Threshold of Parallelism set to?
--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 14, 2020 at 3:30 pm

#3715257
Reply To: SQL Query Performance problem

Jonathan AC Roberts wrote:
What you mean by "MAXDOP 1,2,3,4" as it only has one parameter?
I'm thinking that it means that he tried all 4 settings.
--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 14, 2020 at 3:19 pm

#3715255
Reply To: Validating meta data of xls file
Phil Parkin wrote:
Hi Jeff, I've had some trouble getting your demo working on my home PC.
I installed 32- and 64- bit ACE drivers and then ran this:
```
sp_configure 'show...
```
--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 13, 2020 at 5:54 pm

#3715010
Reply To: Does the amount of DB reduces the speed of the server if DBs are not in use?

jbeclapez wrote:
Hello,
I am running a server and I was telling my colleagues that the amount of database has hardly nothing to do with the speed of the server. Basically we...
--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 13, 2020 at 3:33 pm

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

jasona.work wrote:
Jeff Moden wrote:
jasona.work wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
jasona.work wrote:
Steve Jones - SSC Editor wrote:
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if 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 13, 2020 at 3:27 pm

#3714925
Reply To: Pivot: Rows to Column and Values as rows

There's nothing in the original data you've posted to preserve the required order of the data to do this. Your addition of a calculated row number doesn't cut it 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 13, 2020 at 3:18 pm

#3714922
Reply To:

To answer your question at the end of your original post, yes... there are other ETL tools... and, they're quite expensive and they have steep learning curves and are subject...
--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 13, 2020 at 3:10 pm

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

It probably is the "Insert Bulk" things happening. MS tried to make code faster faster with an "improvement" called "Fast Inserts", which came about in SQL Server 2016. It allocates...
--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 12, 2020 at 8:28 pm

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

jasona.work wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
jasona.work wrote:
Steve Jones - SSC Editor wrote:
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Yeah,...
--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 12, 2020 at 7:42 pm

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

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
That was precisely my thought. A fellow DBA in another company recently went through a bout with a ransom-ware. The ransom-ware was able to track down where 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)

January 12, 2020 at 3:12 pm

#3714756
Reply To: Creating Test Data

Steve Jones - SSC Editor wrote:
Jeff, you want CI to be fast, because you want to get feedback quickly. This runs constantly, so it needs to be fast.
This IS NOT THE ONLY TESTING done...
--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 11, 2020 at 8:27 pm

#3714694
Reply To: Creating Test Data

David.Poole wrote:
@jeff, how do they know the mid string search will always work? How is that more provable than your method?
They don't, actually. 😀 It's more of a visceral fearon...
--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 11, 2020 at 6:33 pm

#3714683
Reply To: Creating Test Data

Chris Harshman wrote:
One of the hardest things to do when generating test data as opposed to obfuscating production data is the non-normal situations. I've found in my years in IT that...
--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 10, 2020 at 4:25 pm

#3714487

Viewing 15 posts - 7,921 through 7,935 (of 59,098 total)