Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,906 through 4,920 (of 59,089 total)

Reply To: New Index Maintenance Methods Recommended by Microsoft

Toby Harman wrote:
One thing I am disappointed not to be hearing more about is the use of resumable index rebuilds.
I've stopped using reorganize on huge tables where we can't rebuild because...
--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 2, 2021 at 11:27 am

#3916096
Reply To: Slow performance after database shrink
Jonathan AC Roberts wrote:
Jeff Moden wrote:
1. Rebuild your non-unique non-clustered indexes that have NOT been disabled. Rebuild them from smallest to largest.
2. Rebuild your previously disabled non-clustered indexes from smallest to largest.
3. Rebuild...
--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 2, 2021 at 11:17 am

#3916095
Reply To: How to limit SQL Job Success events

My suggestion is to stop monitoring successes. Job history does that well enough.

--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 2, 2021 at 12:11 am

#3915972
Reply To: Slow performance after database shrink

When you do a shrink-file on a data file, pages from the end of the file are moved to unused pages at the beginning of the file. That very effectively...
--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 2, 2021 at 12:06 am

#3915971
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

David Burrows wrote:
I'd like to add my thanks as well, a great and thoroughly enjoyable presentation (and I actually understood it 🙂 ). Lots of good stuff. Now I just have...
--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 1, 2021 at 7:25 pm

#3915947
Reply To: SELECT records from table 1 that does not exist in table 2 via UNION

So, the next question is, why do they want to know if you know this? Is there a non-obvious performance advantage? I wouldn't believe so but who knows?

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

July 30, 2021 at 6:23 pm

#3915538
Reply To: the reads of SQL profiler is the number of SQL Server logical read?

Grant Fritchey wrote:
892717952 wrote:
Jeff Moden wrote:
892717952 wrote:
I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found...
--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)

July 30, 2021 at 6:01 pm

#3915533
Reply To: SELECT records from table 1 that does not exist in table 2 via UNION
Jonathan AC Roberts wrote:
Here's a way, though it would be pretty stupid to do it.
```
SELECT x.CustomerID
  FROM (SELECT c.CustomerID, 0 Col1
       ...
```
--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)
July 30, 2021 at 5:51 pm

#3915529
Reply To: the reads of SQL profiler is the number of SQL Server logical read?

892717952 wrote:
I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its logical reads...
--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)

July 29, 2021 at 12:50 pm

#3915052
Reply To: SELECT records from table 1 that does not exist in table 2 via UNION

Erland Sommarskog wrote:
Maybe it was a trick question where the expected answer was "you can't do that" or "that's a completely meaningless thing to do". Remember, the purpose of interview questions...
--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)

July 29, 2021 at 12:42 pm

#3915051
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

Thanks, David. I really appreciate you taking the time to provide feedback.
I went overtime because I got comfortable and slowed down. I needed to keep the pace up on 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)

July 29, 2021 at 5:33 am

#3914947
Reply To: New Index Maintenance Methods Recommended by Microsoft

Grant Fritchey wrote:
However, Jeff, in all seriousness, their mistakes & shortcomings aside, would you say that "the last people you should be listening to are Microsoft employees"?
See... that's a 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)

July 29, 2021 at 4:55 am

#3914936
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

jfogel wrote:
Asking for and getting a consistent format for incoming data from multiple clients is often wishful thinking. Sure, if you've done previous conversions from a system(s) that is 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)

July 27, 2021 at 9:15 pm

#3914455
Reply To: New Index Maintenance Methods Recommended by Microsoft

Grant Fritchey wrote:
Sergiy wrote:
Do you again think I’m wrong on it?
Yes.
Unfortunately, that actually proves that they don't know. Bob Ward is still talking about the use of reorganize for index maintenance. ...
--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)

July 27, 2021 at 8:39 pm

#3914448
Reply To: Do You Have ALL the YAML?

will 58232 wrote:
Thanks Jeff
That and control characters 28 thru 31.
I'm writing them how I would decode them in JavaScript -
Row split:
data.split("\u001e")
column split:
data.split("\u001f")
It is possible to define a whole set of JavaScript...
--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)

July 26, 2021 at 8:58 pm

#3914087

Viewing 15 posts - 4,906 through 4,920 (of 59,089 total)