Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,156 through 34,170 (of 59,099 total)

RE: Select Records For Any Month

@Vedran,
Great post and absolutely correct on all accounts. It's not often that I see people with only 68 points turning out such a nice, informative answer like you did....
--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)

April 27, 2011 at 8:56 pm

#1316996
RE: First attempt at a blog

alan.berger (4/27/2011)
Could a few folks take a look at
http://bit.ly/lEFRls
and let me know what you think? It's a comparison of execution plans for 4 ways to get 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)

April 27, 2011 at 5:46 pm

#1316982
RE: Paging on huge tables with row_number

Thank you for the replies. I'm at work right now and I'll build some code for you tonight.
--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)

April 26, 2011 at 9:44 am

#1315973
RE: TSQL Complex Search

I believe you're going to have to explain that one. 😉
--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)

April 26, 2011 at 6:44 am

#1315829
RE: Paging on huge tables with row_number

Thinking about how to put this together for you and have just a few more questions.
What will be done with the 10,000 records per page that you speak of? ...
--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)

April 26, 2011 at 6:27 am

#1315822
RE: Paging on huge tables with row_number

How many rows are in the table now?
--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)

April 25, 2011 at 10:27 pm

#1315685
RE: Are the posted questions getting worse?

bitbucket-25253 (4/25/2011)
Jeff
Sent to you via email, the latest test results for the 4K splitter test. Just letting you know here to draw your attention to your e-mail
Thanks, Ron....
--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)

April 25, 2011 at 10:12 pm

#1315681
RE: Function To Add [n] Days to A Date and Adjust to the Nearest Business Date

I know the guy that wrote that article! 😛
That particular article calculates the number of week days between two given dates and I don't recommend it for this particular problem.
However,...
--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)

April 25, 2011 at 10:07 pm

#1315680
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (4/25/2011)
Craig Farrell (4/25/2011)
Steve Jones - SSC Editor (4/25/2011)
The UK had holidays Fri-Mon, so I struggled to get someone to come in and check on things...
--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)

April 25, 2011 at 9:17 pm

#1315675
RE: Best way to normalize

Alright... I'll just do like I normally do and test this type of thing on a million rows. Here's the code to make a million row test table like...
--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)

April 25, 2011 at 9:12 pm

#1315674
RE: Best way to normalize

The query creates a couple of Triangular joins where one internal leg consists of 270 rows and the other consists of 135 rows. Please see the following article 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)

April 25, 2011 at 7:01 pm

#1315664
RE: hierarchyid traversing the tree.

Very cool. Glad I could help and thank you for 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)

April 25, 2011 at 3:30 pm

#1315619
RE: Import/Export files (.txt/.csv/.xls) into SQL 2005 Compact Edition

Gah!... I didn't mean to turn it into a rant. Sorry. The only real advantage that CE has compared to custom code might be it's ability to sort...
--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)

April 25, 2011 at 8:09 am

#1315446
RE: Are the posted questions getting worse?

SQLkiwi (4/25/2011)
Jeff,
VSTA is installed by SQL Server 2008 for use with SSIS scripting (see http://msdn.microsoft.com/en-us/library/bb522527(v=SQL.100).aspx). SQL Server 2005 used something called VSA (notice the missing 'T'). VSTA can...
--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)

April 25, 2011 at 7:02 am

#1315404
RE: Are the posted questions getting worse?

Well, I learn something new everyday. Today may be a great day because I learned something quite by accident. Someone sent me the code for a CLR with...
--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)

April 24, 2011 at 9:08 pm

#1315305

Viewing 15 posts - 34,156 through 34,170 (of 59,099 total)