Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,746 through 41,760 (of 59,067 total)

RE: Passed 70-432

SQL Noob (9/28/2009)
and PrepLogic is having a sale. $10 for the 70-432 pdf download with 150 questions
Hmmm... I suppose it comes with the answers to those 150 questions,...
--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)

September 28, 2009 at 7:35 pm

#1059280
RE: Are the posted questions getting worse?

Bob Hovious 24601 (9/28/2009)
But I thought the frozen ones hurt more, Jeff. 😛
I used to think that but I did an experiment and found that if you cook...
--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)

September 28, 2009 at 7:26 pm

#1059277
RE: Are the posted questions getting worse?

Bob Hovious 24601 (9/28/2009)
I guess my question is: If you see an answer that you think misses the mark, why you don't just go ahead and answer it 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)

September 28, 2009 at 11:21 am

#1059108
RE: Help writing a SQL

Dave Ballantyne (9/28/2009)
Jeff Moden (9/28/2009)
Heh... what ordering issues?
Well , just that on your base table , you dont ( disclaimer More testing needed) need a clustered index in 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)

September 28, 2009 at 9:31 am

#1059054
RE: Help writing a SQL

Dave Ballantyne (9/28/2009)
this goes some way to resolving quirky update ordering issues.
Heh... what ordering issues?
--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)

September 28, 2009 at 8:30 am

#1059019
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks Greg.
--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)

September 28, 2009 at 8:25 am

#1059017
RE: Returning records with matching days of the week

brett.davis1 (9/28/2009)
Jeff,
I'm not certain that we will have the kinds of problems you are refering to - but correct me if I'm wrong.
Now that I know what the table 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)

September 28, 2009 at 4:44 am

#1058942
RE: Can't Import Data Fast Enough - Optimize or rethink the design?

winterminute (9/27/2009)
I don't create an indexes on my staging table, should I? Once I implement a merge flag, then it would make sense to add an index for that...
--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)

September 27, 2009 at 9:28 pm

#1058901
RE: view performance deteriorated significantly

I've run into this problem many times especially when the view calls other views and aggregations are involved. Every system has a "tipping point" very much like the proverbial...
--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)

September 27, 2009 at 9:25 pm

#1058900
RE: Query Statement - SQL 2000

For better answers quicker, I recommend the following article...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--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)

September 27, 2009 at 9:08 pm

#1058899
RE: Row to Column Conversion

roy.neelanjana (9/27/2009)
Hi All,
I have a requirement in sql server 2005 reporting services where I need multiple selection. But my database is in Sqlserver 2000.
If the input is as follows:
declare...
--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)

September 27, 2009 at 9:05 pm

#1058898
RE: Check Yourself

Grant Fritchey (9/25/2009)
Flat out, it depends. I get something from Jeff, Gail, Lynn, the usual suspects, I will review it and test it, but I'll generally assume it's right. 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)

September 27, 2009 at 8:07 pm

#1058893
RE: Returning records with matching days of the week

I've got to ask... what do you do next week since this original table posted gives no clue as to date? I don't know if you can change 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)

September 27, 2009 at 8:04 pm

#1058892
RE: MDX to generate CSV file as Output

I agree with you, but you didn't tell them how to export to a CSV. Keep in mind that T-SQL is part of the stack and the user doesn't...
--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)

September 27, 2009 at 7:48 pm

#1058890
RE: Split String and ordering

jwhisman (9/27/2009)
Wow, thank you, Jeff. I'd been trying to think how to use your Tally example, but hadn't quite wrapped my head around how to do it in a...
--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)

September 27, 2009 at 7:40 pm

#1058889

Viewing 15 posts - 41,746 through 41,760 (of 59,067 total)