Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,306 through 31,320 (of 59,101 total)

RE: Automate Restore 1

SQLRNNR (1/19/2011)
Consider it taken then
Heh... Talk about serindipity. I was just doing this very same thing on a production server and said to myself "this would make a great...
--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)

January 30, 2012 at 10:24 am

#1440140
RE: how write split function for this store procedure

er.sivaganesh (1/30/2012)
i posted the details
Gosh... I understand the details on the table side. What does the delimited parameter you're passing or the CSV column that you're trying 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)

January 30, 2012 at 10:11 am

#1440125
RE: Need the best way of doing it in SSIS...SSIS experts please suggest

Sri8143 (1/30/2012)
I am using ssis not ssms ....and they want to do it thru ssis ..
Apollogies... I meant SSIS. Koen's method will work just fine through SSIS. In...
--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)

January 30, 2012 at 10:04 am

#1440117
RE: Rounding problem in sql 2008

I'ts not my solution. JLS posted it.
It uses the MODULO function (% operator) which simply returns the remainder of a division. Try running just Amount % .05 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)

January 30, 2012 at 12:28 am

#1439850
RE: Least privilege required for taking and restoring db backups

Siva Ramasamy (1/27/2012)
Thanks Lowell.
Actually, this is what I have granted to the user..I tried to use the db_backupoperator_role. It did not help.
I was just wondering is there any...
--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)

January 30, 2012 at 12:08 am

#1439846
RE: COUNT No of occurrances in a text field

AccidentalDBA:) (1/29/2012)
Thanks guys for all you help, managed to fix my script a differnet way instead of count in numbe of occurances of a specific word for my while...
--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)

January 30, 2012 at 12:05 am

#1439845
RE: Where do you save your Create By/Date and Modify By/Date information?

Sam, I have to agree with the others. Why all the concern over them being the last 4 columns?
--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)

January 29, 2012 at 11:46 pm

#1439844
RE: Where do you save your Create By/Date and Modify By/Date information?

ALZDBA (11/23/2011)
I tend to add those columns. (period) and don't maintain them to be first or last in the list.
I don't rely on sprocs to fill out their values....
--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)

January 29, 2012 at 11:45 pm

#1439843
RE: Need the best way of doing it in SSIS...SSIS experts please suggest

Gosh... I wouldn't use SSMS for such a thing. If everything needs to be copied, just do a restore. If you want to avoid lengthy downtime, setup transactional...
--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)

January 29, 2012 at 11:33 pm

#1439841
RE: Rounding problem in sql 2008

andre-394971 (1/29/2012)
Hello There,
The solution proposed works as expected BUT I carnt use it as is.
I need to be able to perform a statement similar to the below
Select Name,Address, Function(Amount) 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)

January 29, 2012 at 10:52 pm

#1439833
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

PBaekdal (1/29/2012)
Nice and enlightening ... on a par with your original tally table article.
Cheers,
Pete.
Thanks Pete. I really appreciate the feedback.
--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)

January 29, 2012 at 10:09 pm

#1439827
RE: how write split function for this store procedure

er.sivaganesh (1/29/2012)
in a single store procedure iam just inserting values for 3 table in that among the 3 table the seond...
--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)

January 29, 2012 at 10:46 am

#1439760
RE: Totaling Hours and Minutes

ramses2nd (1/24/2012)
Thanks I was able to combine a couple of the suggestions and come up with a good solution.
Two way street here. Please share your solution. Thanks.
--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)

January 27, 2012 at 8:10 pm

#1439652
RE: Converting datetime

They're taking all of the fun out of 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)

January 27, 2012 at 4:44 pm

#1439646
RE: The maximum recursion 100 has been exhausted before statement completion

Sys.columns is simply being used as a row source to drive a cross join to produce a lot of rows instead of using an rCTE, WHILE loop, or Cursor. ...
--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)

January 27, 2012 at 2:12 pm

#1439616

Viewing 15 posts - 31,306 through 31,320 (of 59,101 total)