Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,781 through 33,795 (of 59,099 total)

RE: Tally Table vs. While Loop

Nadrek (6/1/2011)
May I suggest as an optimization fewer but more complex UPDATE statements, to reduce the amount of I/O?
As a very rough example, the first two statement could collapse to:
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)

June 1, 2011 at 11:23 pm

#1332906
RE: Tally Table vs. While Loop

jarid.lawson (5/31/2011)
I need to go through this list and update all date fields into one format,...
I strongly recommend against that. First, DATE datatype "fields" cannot be formatted. Second,...
--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 1, 2011 at 11:20 pm

#1332905
RE: TSQL Count by Week - Show Period

sql_jr (6/1/2011)
It doesn't matter when the period starts,...
Actually, it does and the reason I asked it is because I believed I could save you a lot of pain 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)

June 1, 2011 at 10:51 pm

#1332903
RE: Are the posted questions getting worse?

Fal (6/1/2011)
Can you tell me what Hoot means?
Actually, it's the sound made when you blow a pork chop out of your nose. 😛
--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 1, 2011 at 10:42 pm

#1332899
RE: HTML Report using SQL

Ahhhh... you've left out the third member of the team to make it all happen securely; the Master database. 😉
--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 1, 2011 at 10:29 pm

#1332898
RE: importing large flat files

Based on item #7 of the article that SteveB posted, I'd like to make a couple of recommendations.
1. Set the database you're loading to to "Bulk-Logged" recovery.
2. Lookup...
--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 1, 2011 at 10:12 pm

#1332896
RE: How to set Empty value for first row third column value.

thundersplash845 (5/31/2011)
Hi ,
I want to set the first row third column (e-mail) value as empty. How do i handle?? Can anyone help on this??
Expected output
NAME-----PHONE-------EMAIL
A---------3333---------
B---------4444---------XXX
I've just gotta ask... Why do...
--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 1, 2011 at 7:17 am

#1332489
RE: TSQL Count by Week - Show Period

sql_jr (6/1/2011)
Trying unsuccessfully to get a count of tasks by week, and also want to display the week period.
This doesn't return the correct results -the count is wrong (probably due...
--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 1, 2011 at 7:13 am

#1332488
RE: importing large flat files

coenie-353912 (6/1/2011)
I am importing a large flat file with over 80 millions records using SSIS into a SQL table, it takes a very long time to import. I have tried...
--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 1, 2011 at 6:33 am

#1332469
RE: datetime in MSSQL 2008

I agree with Steve... language and region are probably the reason and should be compared old to new.
--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 1, 2011 at 6:30 am

#1332467
RE: Are the posted questions getting worse?

Craig Farrell (5/31/2011)
Jeff Moden (5/31/2011)
The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?
Nope... it's the terminal velocity for a pork chop with a bone 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)

May 31, 2011 at 9:10 pm

#1332347
RE: does max dop query hint over write max dop setting at server level?

Lookup MAXDOP in Books Online. The answer is 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)

May 31, 2011 at 8:53 pm

#1332345
RE: Using Rollup

Sorry... didn't read the post correctly and withdrew my post.
--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)

May 31, 2011 at 8:43 pm

#1332343
RE: Use of Partitioning to increase import AND query speed?

If you don't have the Enterprise Edition, Table Partitioning isn't an option (IIRC).
You could pull off a similar trick with a "Partitioned View". Look for it in Books Online.
--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)

May 31, 2011 at 8:33 pm

#1332340
RE: Calculations using the Money data type

Let's stop and think about a calulator for a minute. Would you use one that only had a scale of 4 decimal points? Probably not. Would you...
--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)

May 31, 2011 at 7:34 pm

#1332331

Viewing 15 posts - 33,781 through 33,795 (of 59,099 total)