Jeff Moden

Forum Replies Created

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

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
Reply To: New Index Maintenance Methods Recommended by Microsoft

Sergiy wrote:
Don't forget: Microsoft is a Cloud Service provider. Quite a big one. With no plans of retreating.
Increased load on in-house servers makes the argument for a company to move...
--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:24 pm

#3914059
Reply To: GoTo Looping

😀

--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 25, 2021 at 5:55 pm

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

Thanks for the response, Jeffrey. If you go to the first article I provided a link for and then search for "A/B", that 3 character link will take you 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)

July 25, 2021 at 3:58 pm

#3913684

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