Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,586 through 9,600 (of 59,091 total)

RE: TSQL: Grouping continuous timeslots together

tommired2000 99625 - Friday, March 22, 2019 1:47 AM
Dear Communitiy,
hope you can help me solving this issue:
I have to group continuous...
--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 10:21 pm

#2031742
RE: Limit Size of Tables

Jeffrey Williams 3188 - Monday, March 25, 2019 12:42 PM
RonMexico - Monday, March 25, 2019 8:16 AM
--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:14 pm

#2031740
RE: Are the posted questions getting worse?

Thom A - Monday, March 25, 2019 11:05 AM
ZZartin - Monday, March 25, 2019 10:54 AM
--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 5:46 pm

#2031738
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Monday, March 25, 2019 9:58 AM
Thom A - Monday, March 25, 2019 9:45 AM
--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 10:45 am

#2031696
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, March 25, 2019 9:02 AM
Thanks to everyone that did some testing on the new site....
--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 9:37 am

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

rpatlan - Monday, March 25, 2019 8:28 AM
This data is exported from another older dos system to text file and has additional...
--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 9:35 am

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

rpatlan - Monday, March 25, 2019 7:36 AM
Yes, it is not a problem. We already have the data so we can cross...
--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:51 am

#2031673
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

Viewing 15 posts - 9,586 through 9,600 (of 59,091 total)