Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,686 through 14,700 (of 59,097 total)

RE: What is the purpose of dropping temp db?

It actually serves a very important function... troubleshooting. It's useless inside a proc but if someone is trying to troubleshoot the code in the proc, then it's nice to have...
--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)

July 26, 2017 at 8:44 am

#1952793
RE: Are the posted questions getting worse?

I renamed my wireless router "VirusTesting2". It's amazing how the hits on it have diminished.
--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)

July 25, 2017 at 4:19 pm

#1952702
RE: how to deploy 10 T-SQL scripts across 200 databases

sqlguy80 - Tuesday, July 25, 2017 12:37 PM
Hi ,
Can any one suggest an efficient way where we can apply about 10 T-SQL...
--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)

July 25, 2017 at 3:16 pm

#1952695
RE: time - missing colon :

sgmunson - Tuesday, July 25, 2017 7:26 AM
mxy - Monday, July 24, 2017 9:40 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)

July 25, 2017 at 9:29 am

#1952598
RE: The Current Date

@steve-2,
Heh... I can only imagine where such a question may have come from. 😉
--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)

July 25, 2017 at 9:24 am

#1952597
RE: The Current Date

Kaye Cahs - Tuesday, July 25, 2017 7:20 AM
56656
For most of my use cases, DATETIME2 seems to make 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)

July 25, 2017 at 9:22 am

#1952596
RE: Tempdb Spills

zouzou - Monday, July 24, 2017 8:06 AM
fixed it with changing the MAXDOP to 4
Maybe not. Adding MAXDOP would cause a recompile. ...
--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)

July 24, 2017 at 10:34 pm

#1952491
RE: Odd Behavior by Instance

Antares686 - Monday, July 24, 2017 2:20 PM
Lynn Pettis - Monday, July 24, 2017 2:05 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)

July 24, 2017 at 10:18 pm

#1952490
RE: Backup command with multiple threads.

If you want your backups to run faster and you're only writing to one physical spindle, then you need to play with the "pipe", not more threads. More threads 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)

July 24, 2017 at 10:03 pm

#1952489
RE: Powershell script transfers entire directory?

Heh... I'll likely not learn much more about PoSh than I already know. For things like this, I build a good ol' fashion DOS command in T-SQL and use xp_CmdShell...
--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)

July 24, 2017 at 7:23 pm

#1952484
RE: Looking Back

jasona.work - Monday, July 24, 2017 12:53 PM
Jeff Moden - Saturday, July 22, 2017 5:55 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)

July 24, 2017 at 7:09 pm

#1952483
RE: Dropping PKs

jbwa - Monday, July 24, 2017 3:36 PM
I think the correct answer depends upon how the clustered index is created. The posed...
--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)

July 24, 2017 at 7:04 pm

#1952482
RE: SSMS is Free

Steve Jones - SSC Editor - Sunday, July 23, 2017 11:02 AM
Jeff Moden - Saturday, July 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)

July 23, 2017 at 9:38 pm

#1952293
RE: Looking Back

ZZartin - Friday, July 21, 2017 10:09 AM
Chris Harshman - Friday, July 21, 2017 9:28 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)

July 22, 2017 at 5:56 pm

#1952252
RE: SSMS is Free

Steve Jones - SSC Editor - Friday, July 21, 2017 12:08 PM
Jeff Moden - Friday, July 21,...
--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)

July 22, 2017 at 5:50 pm

#1952251

Viewing 15 posts - 14,686 through 14,700 (of 59,097 total)