Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,231 through 25,245 (of 59,099 total)

RE: file rename with store procedure

Heh... and stop using spaces in file names. It complicates things further down the line. If you must have separation between "fields" in the file names, use underscores.
--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)

December 4, 2013 at 8:30 am

#1670745
RE: Regarding tempdb usage

nagasai88 (12/4/2013)
Thanks, Will update you once he implement this tempdb usage.
Even if this could be done (and I'm sure it can't be done but will bow deeply if proven wrong),...
--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)

December 4, 2013 at 8:24 am

#1670742
RE: What Is Your Favorite Books For SQL Server Study

Your survey is proof positive as to why I don't like to take multiple-guess style tests or surveys. The correct answer isn't actually available in your list of possibilities.
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)

December 4, 2013 at 8:14 am

#1670738
RE: Maintain Delete flag in target table

Koen Verbeeck (12/4/2013)
If both source and target are on the same server, you could use the TSQL MERGE statement.
Unless the table is absolutely huge, why not just copy the whole...
--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)

December 4, 2013 at 8:02 am

#1670733
RE: Fusion-IO or Nimble?

alexandar_narayan (12/3/2013)
The two 10 GBe ports make the nimble more attractive in my eyes.
Thanks, Alexandar.
--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)

December 4, 2013 at 7:29 am

#1670718
RE: Antivirus on large SQL Server instances

Luke L (12/2/2013)
Jeff thanks for checking into it. I'm curious how he handles that problem in other ways.
Me too! I hoping that he doesn't somehow think...
--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)

December 4, 2013 at 7:20 am

#1670712
RE: server automatic restart

sqlfriends (12/3/2013)
Thanks much, Jeff.
Could you tell me where you can see it could be issue with memory module 3 or 4 in the attachment?
Oh, I see - I accidently...
--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)

December 4, 2013 at 2:06 am

#1670628
RE: Need your help...SQL Developer interview questions..pls

Lynn Pettis (12/2/2013)
Jeff Moden (12/1/2013)
...
How do I know this? Because those are the only jobs I've sought for the last 12 years so I've been on plenty of those...
--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)

December 2, 2013 at 2:24 pm

#1670226
RE: Fusion-IO or Nimble?

@SQLFRNDZ,
Thanks for the legup! That'll help a lot.
--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)

December 2, 2013 at 1:21 pm

#1670222
RE: Looking for a Sr. SQL DBA out of SF

amber.richard (12/2/2013)
Thanks for taking the time to read the requirements. Unfortunately, onsite work is a requirement from our client. If you want to send me your resume (Amber.Richard@staffmark.com), I can...
--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)

December 2, 2013 at 12:20 pm

#1670200
RE: Cannot restore database. Cannot get exclusive accesss

Markus (12/2/2013)
Interesting.... I got this Kill SP from this forum years ago... I have never seen anything to the effect of do not kill SPIDs... except system ones obviously. ...
--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)

December 2, 2013 at 12:15 pm

#1670198
RE: Antivirus on large SQL Server instances

Luke L (12/1/2013)
Thanks Jeff! We're looking at upgrading to systems in that neighborhood and want to get this resolved prior to putting them into production.
Luke.
Wow! I talked 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)

December 2, 2013 at 11:10 am

#1670177
RE: Looking for a Sr. SQL DBA out of SF

Amber,
Some typical questions to help you in your quest...
City and State?
Can the job be filled by someone working remotely?
--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)

December 2, 2013 at 10:48 am

#1670171
RE: Cannot restore database. Cannot get exclusive accesss

Markus (12/2/2013)
Create this stored Proc, run it as a step before your restore step. I use this to refresh NonProd databases all the time. The syntax for 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)

December 2, 2013 at 10:44 am

#1670168
RE: regarding automatic backup job

For the record, I don't actually use Maintenance Plans to do backups. I've developed my own stored procedures that are scheduled as jobs. Maintenance Plans just don't fit...
--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)

December 2, 2013 at 8:47 am

#1670137

Viewing 15 posts - 25,231 through 25,245 (of 59,099 total)