Jeff Moden

Forum Replies Created

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

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
RE: Purge database

Lidou123 - Thursday, April 5, 2018 5:33 AM
Hello everyone
I want to give you news of my project.
I was able to set up as...
--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:56 am

#1985650
RE: Issue with using Ola Hallengren Backup script

Ola Hallengren - Tuesday, April 3, 2018 7:38 AM
I have released a new version of the script with support for striping 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)

April 5, 2018 at 6:35 am

#1985640
RE: Exercise to practise SQL

svrtechnologies.com - Wednesday, April 4, 2018 10:51 PM
Hi,
Can you please give us the name , author, ISBN of 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)

April 5, 2018 at 6:01 am

#1985621
RE: imsage test

You might want to try just a copy'n'paste and see if you get the same good results. In the recent past, doing such a thing would certain paste to 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)

April 4, 2018 at 3:55 pm

#1985565

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