Jeff Moden

Forum Replies Created

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

RE: Is the DBA Title Dying?

roger.plowman - Thursday, April 5, 2018 8:54 AM
Jeff Moden - Thursday, April 5, 2018 8:26 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)

April 6, 2018 at 7:42 am

#1985803
RE: Help with dertermining number of days between dates

LeeFAR - Friday, April 6, 2018 6:04 AM
Jeff, this is the method I was looking for and the results in are 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)

April 6, 2018 at 6:22 am

#1985790
RE: OPENQUERY error: An unexpected NULL value was returned

crmitchell - Friday, April 6, 2018 4:45 AM
A few things to consider
Ensure you are using the correct datasource provider - there are at...
--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)

April 6, 2018 at 6:10 am

#1985789
RE: Index rebuilt/Reorganize script didn't remove fragmentation

Also, as further proof that the bong water I'm drinking through two straws actually tastes pretty good, here's the diagram of supposed "Best Practice" methods when the bad page splits...
--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)

April 5, 2018 at 9:49 pm

#1985761
RE: Index rebuilt/Reorganize script didn't remove fragmentation

It doesn't matter what you use to do the defrags, if you're rebuilding or reorging indexes that suffer bad page splits (inserts other than at the end of the key...
--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)

April 5, 2018 at 9:34 pm

#1985760
RE: Help with dertermining number of days between dates

Ah... looking back at your original post, it looks like you don't care about anything but the period and the total days it may contain. The following code will do...
--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)

April 5, 2018 at 9:07 pm

#1985759
RE: Help with dertermining number of days between dates

If I'm understanding the problem correctly, this is a classic problem with overlapping and underlapping dates. Please see the following article...
http://www.sqlservercentral.com/articles/T-SQL/105968/
... to see why...
--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)

April 5, 2018 at 8:50 pm

#1985758
RE: Generate a unique number for a combination

komal145 - Thursday, April 5, 2018 2:06 PM
Jeff Moden - Friday, March 30, 2018 12:49 PM
--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)

April 5, 2018 at 5:36 pm

#1985752
RE: Is the DBA Title Dying?

Heh... is the DBA a dying title? Maybe the title is dying from severe misuse just as the term "Software Engineer" has been abused (most don't even know the true...
--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)

April 5, 2018 at 12:46 pm

#1985732
RE: taking very long time to execute

saptek9 - Thursday, April 5, 2018 8:57 AM
Grant Fritchey - Thursday, April 5, 2018 6:22 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)

April 5, 2018 at 12:42 pm

#1985730
RE: Is the DBA Title Dying?

Heh... all of this reminds me of the commercial from 4 decades ago and it was absolutely spot on, especially for this discussion... "You can change the box but it...
--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)

April 5, 2018 at 12:39 pm

#1985729
RE: Exercise to practise SQL

ManicStar - Thursday, April 5, 2018 7:11 AM
brraaainnns... (zombie thread)
Yep... and adding spam to the brains only makes them taste worse. 😀
--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)

April 5, 2018 at 8:38 am

#1985685
RE: Replica of Store Procedure taking more time

anoop.mehra - Wednesday, April 4, 2018 11:24 PM
Hi All,
I have optimized one store procedure. Original is taking 35 seconds to take data...
--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)

April 5, 2018 at 8:30 am

#1985680
RE: Is the DBA Title Dying?

roger.plowman - Thursday, April 5, 2018 7:18 AM
Jeff Moden - Thursday, April 5, 2018 6:58 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)

April 5, 2018 at 8:26 am

#1985678
RE: Is the DBA Title Dying?

I actually wouldn't want the server to do a whole lot of stuff auto-magically. Humans would have to write the code to get it to do all that and I...
--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)

April 5, 2018 at 6:58 am

#1985651

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