Jeff Moden

Forum Replies Created

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

RE: insert into table execution of a stored procedure

The problem with using OPENROWSET is that it requires "SA" privs. That's ok for jobs but should not be ok for application logins.
--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 4:12 pm

#1670886
RE: Fusion-IO or Nimble?

alexandar_narayan (12/4/2013)
I think this thread is just about answered but I wanted to add that I think a lot of the things in SQL 2014 are going to be really...
--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 4:10 pm

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

sqlsurfing (12/4/2013)
I do a lot of restores in my Dev and QA environments. They both have a wealth of little connection greedy web services running against them 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)

December 4, 2013 at 4:06 pm

#1670884
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

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