Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,996 through 38,010 (of 59,072 total)

RE: tempdb size

nadia-720162 (6/8/2010)
Would a continuous backup of transaction logs cause a growth from size 8 MB up to 10s of GB knowing that such backup is occurring periodically over short time...
--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)

June 11, 2010 at 7:13 am

#1179147
RE: Need help in SQL , Subtract column based on the condition in the Row

danielprabhu (6/10/2010)
Here i would close my book and sleep 🙂 my local time is 2.30 pm still searching and learning Sql
BWAA-HAAA!!!! Nope... you're NOT learning SQL... you're learning...
--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)

June 11, 2010 at 6:59 am

#1179135
RE: Database size quadruples after converting varchar, text to nvarchar

mack.talcott (6/10/2010)
CirquedeSQLeil (6/10/2010)
In addition to what Lynn has mentioned, you should look at free space vs. used space in your database. Despite having grown to 17GB, you may not...
--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)

June 11, 2010 at 6:51 am

#1179131
RE: Bi-Weekly Pay Period Total Worked Hours

canoedoceanprince (6/10/2010)
, CASE DATEPART(dw, startdate)
WHEN '1' THEN 'Sunday'
WHEN '2' THEN 'Monday'
WHEN '3' THEN 'Tuesday'
WHEN '4' THEN 'Wednesday'
WHEN '5' THEN 'Thursday'
WHEN '6' THEN 'Friday'
WHEN...
--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)

June 11, 2010 at 6:46 am

#1179129
RE: Are the posted questions getting worse?

Richard Gardner-291039 (6/11/2010)
The American market ... want to get gold all the time.
BWAA-HAAA!!!! Why would anyone "shoot for the bronze"? Go for the gold and settle 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)

June 11, 2010 at 6:26 am

#1179119
RE: Collapsing a Table

paul_ramster (6/10/2010)
I've done some performance checks.
I expect the performance would be poor where there are many (millions of) consecutive rows to flatten, but the data I need to process is...
--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)

June 11, 2010 at 5:55 am

#1179109
RE: Selecting the earliest month wrapping January to December

bteraberry (6/10/2010)
scott.pletcher (6/10/2010)
Did anyone even look at the code I posted that, to me, seems to get the answers desired??
Yes it works with the sample data provided, but without specific...
--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)

June 10, 2010 at 9:37 pm

#1179008
RE: Selecting the earliest month wrapping January to December

scott.pletcher (6/10/2010)
I think so.
It was fairly clear when he said month 11 was "before" month 1 that some other month was controlling the sequence.
For convenience, I used MONTH(GETDATE()), since 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)

June 10, 2010 at 9:35 pm

#1179006
RE: Is the MVP Worth It?

Grant Fritchey (6/10/2010)
GilaMonster (6/10/2010)
Dan.Humphries (6/10/2010)
I do not activly seek such things but I am not sure you would be able to wipe the smile off my face with a sand...
--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)

June 10, 2010 at 8:49 pm

#1179002
RE: Splitting One Row Data into Two Rows

scott.pletcher (6/10/2010)
You might want to look into the use of [0-9] and [^0-9] just to simplify the code a bit.
Except I've had some odd results sometimes from that :unsure:. ...
--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)

June 10, 2010 at 8:46 pm

#1179001
RE: Make a 100+ Server Inventory in 30 minutes

Phil Factor (6/10/2010)
Hi Phil... have you got a link for the method you mention above?
I use something similar myself. It is simple stuff. If you're interested I'll tidy it up...
--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)

June 10, 2010 at 8:39 pm

#1179000
RE: Make a 100+ Server Inventory in 30 minutes

Phil Factor (6/10/2010)
This would be handy for a DBA if all the servers are in the domain, but rather than make a batch file with a list of all your...
--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)

June 10, 2010 at 3:00 pm

#1178945
RE: Is the MVP Worth It?

Steve Jones - Editor (6/10/2010)
My ring looks surprisingly like one that came out of a cardboard box of sweet, corn based, treats :w00t:
Dan, I agree with you on one part....
--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)

June 10, 2010 at 2:21 pm

#1178917
RE: Selecting the earliest month wrapping January to December

scott.pletcher (6/10/2010)
Did anyone even look at the code I posted that, to me, seems to get the answers desired??
Does it work if the data is out "out of order" 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)

June 10, 2010 at 9:33 am

#1178686
RE: Collapsing a Table

paul_ramster (6/10/2010)
Thanks for the suggestion.
However, while that has one big advantage (in that it works), it has a problem for me (not SQL2000 compatible). Although that shouldn't matter on this...
--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)

June 10, 2010 at 7:33 am

#1178592

Viewing 15 posts - 37,996 through 38,010 (of 59,072 total)