Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,756 through 19,770 (of 59,098 total)

RE: Monthly System Backups ?

Ola's stuff takes care of backups auto-magically and could easily be made to exclude the system databases. My question is, why even bother? The databases aren't big, take...
--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)

August 27, 2015 at 7:10 pm

#1822948
RE: Another SQL question, hopefull simple one

Let's hope that you never have someone that punches in one day and punches out the next day, like someone on a 3rd shift might.
--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)

August 27, 2015 at 6:51 pm

#1822947
RE: handling odd date format

OOOOOOHHHHHH!!!!! I GET IT!!! 😉 Now I know why the OP hasn't responded! He doesn't really need help. It was a ploy for him 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)

August 27, 2015 at 4:35 pm

#1822942
RE: What are your five most common T-SQL commands

Favorite name for a Temp Table when troubleshooting something that should never have made it to production...
[font="Arial Black"]#MyHead[/font]
--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)

August 27, 2015 at 4:27 pm

#1822941
RE: Need to keep a running total of OnHandQty Minus OrderQty

sdownen05 (8/27/2015)
Jeff,
Thanks for the tips. Two things. Right now, our data set is small enough that the performance hit will be negligible; however it is expected to increase, so 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)

August 27, 2015 at 4:24 pm

#1822939
RE: Command for adding new drives?

GilaMonster (8/27/2015)
Jeff Moden (8/27/2015)
JaybeeSQL (8/27/2015)
GilaMonster (8/27/2015)
JaybeeSQL (8/27/2015)
Should the system databases be best moved in any particular order?
To be honest, other than TempDB, I'd probably leave the others alone for now....
--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)

August 27, 2015 at 8:01 am

#1822768
RE: Slow site

robert.chipperfield (8/27/2015)
Fingers crossed, it's a permanent fix this time too:
Engineers isolated the issue to an aggregation router that was experiencing connectivity issues. The aggregation router was recabled, resolving the networking...
--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)

August 27, 2015 at 7:58 am

#1822767
RE: Command for adding new drives?

JaybeeSQL (8/27/2015)
GilaMonster (8/26/2015)
That would be a far better question, because there's no SQL command to add drives to a server. 😉
Firstly, you don't want to move the binaries, as 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)

August 27, 2015 at 7:49 am

#1822761
RE: Command for adding new drives?

GilaMonster (8/27/2015)
JaybeeSQL (8/27/2015)
Should the system databases be best moved in any particular order?
To be honest, other than TempDB, I'd probably leave the others alone for now. Moving master is not...
--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)

August 27, 2015 at 7:48 am

#1822760
RE: Command for adding new drives?

JaybeeSQL (8/27/2015)
GilaMonster (8/27/2015)
JaybeeSQL (8/27/2015)
Should the system databases be best moved in any particular order?
To be honest, other than TempDB, I'd probably leave the others alone for now. Moving master is...
--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)

August 27, 2015 at 7:47 am

#1822759
RE: Need to keep a running total of OnHandQty Minus OrderQty

sdownen05 (8/27/2015)
Here it is by OrderDate. Thank you for the solution. That works very well. I can't use the SSRS solution because this data has to go into a 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)

August 27, 2015 at 7:43 am

#1822753
RE: Email Formatted HTML Table with T-SQL

TomThomson (8/25/2015)
Interesting how many different ways there are to do this.
Back in the early SQL 2000 days I wanted to send HTML-formatted reports from SQL Server; DB_SENDMAIL was the first...
--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)

August 27, 2015 at 7:36 am

#1822748
RE: Slow site

Heh... good grief. Between 20 and 60 seconds between every click now (10:30PM EDST). This is brutal. I sure hope you good folks can get 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)

August 26, 2015 at 8:33 pm

#1822650
RE: How can I group near duplicate records under a new common field?

I found the code I was looking for and, unfortunately, it solves for a problem quite different that I thought I remembered and doesn't come close to solving this problem.
However,...
--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)

August 26, 2015 at 8:27 pm

#1822649
RE: How can I group near duplicate records under a new common field?

craig.bobchin (8/26/2015)
Jeff Moden (8/26/2015)
Off topic a bit, I'm not sure why anyone in the right mind would store an SSN in a Unicode data type and, unless the fact 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)

August 26, 2015 at 7:37 pm

#1822646

Viewing 15 posts - 19,756 through 19,770 (of 59,098 total)