Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,921 through 4,935 (of 59,101 total)

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
Reply To: Do You Have ALL the YAML?

Something else folks may not consider and that's the "native" format for transmitting data from SQL Server to SQL Server. It does really cool stuff such as leaving INTs in...
--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:55 pm

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

will 58232 wrote:
With the proliferation of file formats, perhaps it is time to revisit the delimited file and how its problems can be overcome.
CSV stands for comma separated values. As 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)

July 26, 2021 at 7:39 pm

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

On the subject of LOB compaction and deletes and page splits...
It may take 10 runs for REORGANIZE to actually get it to work right (yep... tried it and measured it).
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)

July 26, 2021 at 7:33 pm

#3914060

Viewing 15 posts - 4,921 through 4,935 (of 59,101 total)