Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,926 through 5,940 (of 59,072 total)

Reply To: Creating indexes on a very large table takes over 5 hours

pamkagel wrote:
Tried creating the view. It was non performant .
Then you're doing it wrong. Please answer the questions I posted or I don't know enough how to help you.
--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)

December 9, 2020 at 6:51 pm

#3818710
Reply To: how to capture login 'sa' begin used ot not

My recommendation would be to do what the industry best practice normally recommends and disable it. If the phone rings, you'll have your answer and, yes, you should answer 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)

December 9, 2020 at 5:07 am

#3818494
Reply To: Same execution plan but different run time

paphilly wrote:
Hi, I am running into similar situation, except that my procedure consistently runs slow compared to other environment, when in comparison both environments have similar execution plan and statistics,...
--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)

December 9, 2020 at 4:56 am

#3818485
Reply To: Subtract running amount

Steve... the OP has posted in a 2005 forum which is before SUM() OVER had the ability to produce a running sum. I'm thinking we're going to need another "Quirky...
--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)

December 9, 2020 at 4:17 am

#3818480
Reply To: Creating indexes on a very large table takes over 5 hours

pamkagel wrote:
I have a table that is 125GB. It only has 5 Columns but has almost a billing rows. This is a fact table that gets regenerated nightly . I...
--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)

December 9, 2020 at 4:12 am

#3818479
Reply To: Boost performance of your SQL Server tables with a TURBO button

trimjib wrote:
A heap can have a non-clustered index and leaves won't be ordered on that index.
If I'm reading that correctly, I'm really sure that's not true. All non-clustered indexes are...
--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)

December 9, 2020 at 12:15 am

#3818427
Reply To: Boost performance of your SQL Server tables with a TURBO button

To the best of my knowledge (and I could be wrong), inserts into heaps follow no order. They're almost always added to the last logical page of the heap. 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)

December 8, 2020 at 11:16 pm

#3818417
Reply To: Order By Slowness

Jackie Lowery wrote:
I may not have had to rebuild them, but doing a full sample on the statistics definitely fixed the slowness.
Should I have to do a full sample on 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)

December 8, 2020 at 10:25 pm

#3818394
Reply To: Inflow / outflow report per day

milo1981 wrote:
Looks like I'll have to migrate to a newer version of SQL. Thank you everyone for their support!
There's no need to wait... simply use the following code 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)

December 8, 2020 at 10:11 pm

#3818390
Reply To: The default ORDER BY

It doesn't work just in the old punch-card days. It works fine now, as well. 😀

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

December 8, 2020 at 6:26 pm

#3818307
Reply To: Seeking Growth

"Mastery" can also be an illusion... remember that "In the land of the blind, the one-eyed man (even with less than perfect vision) is king".
--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)

December 8, 2020 at 6:24 pm

#3818306
Reply To: Inflow / outflow report per day
milo1981 wrote:
Thank you, Jeff for taking the time to write and comment your response.
However, I get the following error when I run the script:
```
Msg 208, Level 16,...
```
--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)
December 7, 2020 at 4:55 pm

#3817874
Reply To: Seeking Growth

One of the problems that I've witnessed since the fateful day of Monday, January the 18th, 2016 when I discovered that it was the supposed "Best Practice" index maintenance 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)

December 7, 2020 at 4:12 pm

#3817863
Reply To: The default ORDER BY

Lordy... Let us hope that MS never makes a DB or Server-Wide setting for 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)

December 7, 2020 at 2:39 pm

#3817829
Reply To: How to mantain index in SQL and size of Database

@ Evgeny Garaev ,
I totally agree that Ola's good code will take a huge number of different settings. There's no argument there or on the quality of Ola's code.
The problem...
--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)

December 6, 2020 at 10:38 pm

#3817600

Viewing 15 posts - 5,926 through 5,940 (of 59,072 total)