Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,891 through 4,905 (of 59,070 total)

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
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

If it's done right on both the part of the sender and the receiver, it's actually not a "lengthy process". It can be nasty fast and super easy to setup...
--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 24, 2021 at 6:45 pm

#3913509
Reply To: Define All The Steps Up Front

You never said... what's the closest city you're moving to?
I also wish you luck with the move and, just like getting a DBA involved, I'll also say that the 6%...
--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 24, 2021 at 5:24 pm

#3913501
Reply To: Non clustered index fragmentation problem

vineet6824 wrote:
Hi,
Table schema
RouteID bigint,
DLRStatus tinyint,
DLRID nchar(50)
ReceivedDate datetime
This table contains millions of records and we need to fetch the record by DLRID which is received from several sources from outside 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 23, 2021 at 10:45 pm

#3913348

Viewing 15 posts - 4,891 through 4,905 (of 59,070 total)