Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,956 through 32,970 (of 59,099 total)

RE: Testing box for sql servers

bitbucket-25253 (8/7/2011)
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.
Our production server will be enterprise version
For the license issue, can I just use...
--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 7, 2011 at 6:39 pm

#1364961
RE: Testing box for sql servers

@SQLFRNDZ (8/5/2011)
You want to test on testing environment and why do you compred to Production?
You use developer edition but really depends on what you want test I mean there...
--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 7, 2011 at 6:35 pm

#1364960
RE: What SQL Server Books Do You Recommend

I was in the middle of a huge rant on books but see that George and Tom covered some good amount of what I had to say on this subject....
--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 7, 2011 at 6:09 pm

#1364953
RE: How will you write a query for this scenario

Jeff Moden (8/7/2011)
vermarajiv (8/2/2011)
Thanks GSquared for confirming what I was thinking.
I tried recursive CTE and you are right it does not allow aggregate functions
Based on your tip, I found...
--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 7, 2011 at 4:53 pm

#1364944
RE: How will you write a query for this scenario

GilaMonster (8/7/2011)
I had to do something like that for a client a couple years back. The eventual solution was partially set-based, with a while loop tossed in and came out...
--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 7, 2011 at 4:47 pm

#1364942
RE: How will you write a query for this scenario

gah (8/5/2011)
Another possibility using quirky update.......thoughts anyone please?
I just checked through your QU code, Gah... VERY nicely done! It's not often I see someone follow all the rules especially...
--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 7, 2011 at 4:39 pm

#1364941
RE: How will you write a query for this scenario

eccentricDBA (8/2/2011)
Here is a technique. It would need to be tested for usuability with a large record set.
Done... and I think there may be a problem... it would appear...
--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 7, 2011 at 4:26 pm

#1364939
RE: How will you write a query for this scenario

Jeff Moden (8/7/2011)
Ben-Gan has some very interesting date-span code that runs like the wind. It would be perfect for this and actually negates the need for a Quirky Update....
--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 7, 2011 at 4:20 pm

#1364937
RE: How will you write a query for this scenario

vermarajiv (8/2/2011)
Thanks GSquared for confirming what I was thinking.
I tried recursive CTE and you are right it does not allow aggregate functions
Based on your tip, I found a semi...
--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 7, 2011 at 3:51 pm

#1364933
RE: help with the query

Nomvula (8/7/2011)
hi guys
thanks for the response, i realized that i won't be able to get the Max(TimeTo) since the transactions happened on the same date and same time.
i have another...
--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 7, 2011 at 3:04 pm

#1364930
RE: Analyzing a database

I can't even find anyone that knows the app well that the database supports!
I'd back it up, take it offline, and see who calls for it before I spent...
--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 7, 2011 at 3:01 pm

#1364928
RE: How will you write a query for this scenario

Ben-Gan has some very interesting date-span code that runs like the wind. It would be perfect for this and actually negates the need for a Quirky Update. 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)

August 7, 2011 at 2:58 pm

#1364926
RE: Testing box for sql servers

sqlfriends (8/5/2011)
I would like to do some testing on a testing box for installation.
Our production server will be enterprise version
For the license issue, can I just use developer version for...
--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 7, 2011 at 2:54 pm

#1364925
RE: How to convert this 'dd-mm-yyyy' to 'yyyy-MM-ddTHH:mm:ss.fff' string format?

Gosh, NO! You shouldn't ever save formatted dates and times in the database. It messes up just about everything and it's a real pain when the user changes...
--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 7, 2011 at 2:47 pm

#1364923
RE: while condition or loop

sdgray01 (8/7/2011)
Thank you both for your help, i do appreciate that. i have finally managed to crack it and all seems to be working now. In the end i was...
--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 7, 2011 at 2:41 pm

#1364921

Viewing 15 posts - 32,956 through 32,970 (of 59,099 total)