Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,601 through 9,615 (of 59,099 total)

RE: Find missing numbers in sequence 1 thru 5

Jason A. Long - Sunday, March 24, 2019 8:24 PM
Jeff Moden - Sunday, March 24, 2019 7:22...
--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)

March 25, 2019 at 7:31 am

#2031668
RE: Find missing numbers in sequence 1 thru 5

rpatlan - Sunday, March 24, 2019 9:39 PM
Thanks for all your comments. This data is coming from text files. It is being...
--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)

March 25, 2019 at 7:25 am

#2031666
RE: Minimal Logging

As always, Paul, your technical knowledge is impeccable. Thank you very much.
The unfortunate part is that which Thomas realized in his testing isn't clearly explained in the MS...
--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)

March 24, 2019 at 7:52 pm

#2025320
RE: SSIS FTP Component ... LocalPath settings ... User::LocalFolderPath

Thanks for posting what you found, Allan.
--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)

March 24, 2019 at 7:41 pm

#2025319
RE: SQL Server slow but CPU,Memory and Network fine

I'd also like to know what methods were used to be able to make the claim that "CPU,Memory and Network are fine" and why no mention of I/O was included.
--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)

March 24, 2019 at 7:36 pm

#2025318
RE: Find missing numbers in sequence 1 thru 5

Great idea, Jason. Just a caution though...
While that will work for the given data, it won't always work... all you need is some gaps in the ID column...
--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)

March 24, 2019 at 7:22 pm

#2025317
RE: Best Practice while writing Insert statement in Procedures

Step one would be to post the code that you're found causing the deadlocks.
Step two would be to include the deadlock chart when you do step one above.
--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)

March 24, 2019 at 4:02 pm

#2025313
RE: Find missing numbers in sequence 1 thru 5

Jeff Moden - Sunday, March 24, 2019 3:42 PM
So create a small table (or use VALUES as a temporary table constructor) with...
--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)

March 24, 2019 at 3:47 pm

#2025312
RE: Find missing numbers in sequence 1 thru 5

So create a small table (or use VALUES as a temporary table constructor) with the numbers 1-5 in it and do an outer join to it with the table you're...
--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)

March 24, 2019 at 3:42 pm

#2025311
RE: Query Tuning Assistant: A Tool for Upgrades

The "old" Upgrade Adviser was nice... the new one (I can't remember it's name because they changed it and won't be using it again) isn't because you're going 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)

March 23, 2019 at 4:25 pm

#2025302
RE: Guide to Quickly Creating an Azure Data Lake Storage

From the article:
If you do not have an Azure Account, there is a good news. Microsoft let's you create your own Azure free account with 12 months of...
--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)

March 23, 2019 at 4:14 pm

#2025301
RE: Guide to Quickly Creating an Azure Data Lake Storage

Jo Pattyn - Tuesday, March 19, 2019 2:47 AM
Why did you pick data lake storage gen 1 instead of gen 2?
OK... where...
--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)

March 23, 2019 at 4:04 pm

#2025300
RE: Cleaning up tempdb

This is one of those questions where "It Depends" comes into play... please see the following article where the supposedly correct answer didn't work...
https://www.sqlskills.com/blogs/erin/remove-files-from-tempdb/
--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)

March 23, 2019 at 3:32 pm

#2025299
RE: Minimal Logging

ti 93734 - Saturday, March 23, 2019 11:06 AM
Hm. I just noted a small difference in the text between the 2088 and...
--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)

March 23, 2019 at 12:22 pm

#2025294
RE: Minimal Logging

Nope... Didn't miss a thing. I'm posting my test because 1) I made a claim against the MS documentation and 2) I want other people to have proof and 3)...
--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)

March 23, 2019 at 10:49 am

#2025292

Viewing 15 posts - 9,601 through 9,615 (of 59,099 total)