Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,986 through 39,000 (of 59,072 total)

RE: Views vs Table-Valued function - Performance issues

pnmm (4/7/2010)
About ITVF suggestion, it will not work, because my TVF has logic inside.
Anything you can do in a view (not including indexed views), you can generally do in an...
--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 7, 2010 at 2:45 pm

#1147779
RE: Views vs Table-Valued function - Performance issues

Try using "Inline" Table Valued functions instead. The syntactical difference between a "Multi-line" Table Valued Function and an "Inline" table valued function is explained 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)

April 7, 2010 at 7:09 am

#1147293
RE: FizzBuzz

Lynn Pettis (4/6/2010)
Steve Jones - Editor (4/6/2010)
Unless someone has a great argument, I am going to choose Gianluca's entry here: http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question/4631#4631
It seemed to perform the fastest on my machine.
No complaints,...
--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 6, 2010 at 10:36 pm

#1147003
RE: Update current period data based on previous period data

VERY clever. Seriously. And, removing the following line doesn't hurt much...
WHERE S.flag_null = 1
In that same vain (playing around with your code), it also 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)

April 6, 2010 at 9:28 pm

#1146965
RE: Is the column with uniqueidentifier data type unique?

Thanks for the links, Paul. From what I've read in those links, it looks like SQL Server is using type 4, the random based values.
The confusing 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)

April 6, 2010 at 8:07 pm

#1146945
RE: staging table and indexes

Steve Jones - Editor (4/6/2010)
It's a normal view, just of one table. So for the customers table it's
create view PassThroughCustomers
as
select * from Customers
Correct. As a side bar, the only...
--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 6, 2010 at 7:27 pm

#1146935
RE: How to Build a Datawarehouse from a Database

It would seem that DBCC TIMEWARP would help here. 😉 Bits 69 and 77 need to be set for this 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 6, 2010 at 6:45 pm

#1146922
RE: FizzBuzz

Steve Jones - Editor (4/6/2010)
Unless someone has a great argument, I am going to choose Gianluca's entry here: http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question/4631#4631
It seemed to perform the fastest on my machine.
I agree... in fact,...
--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 6, 2010 at 6:31 pm

#1146917
RE: Update current period data based on previous period data

Paul White NZ (4/6/2010)
Please do read Jeff's article on Triangular Joins so you understand what an important concept it is.
It will also help you to understand why the code 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)

April 6, 2010 at 6:14 pm

#1146909
RE: Cursor - trying to find another method

steve-lauzon (4/6/2010)
2. Thanks also for the link. I will do so in my future post.
Heh... if you do it on this post, I might be able to provide 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)

April 6, 2010 at 3:37 pm

#1146842
RE: Cursor - trying to find another method

steve-lauzon (4/6/2010)
Hi all... this is my first post in the forums. I hope I'm following the guidelines
I need help!
I got a table that contains a list of several regions...
--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 6, 2010 at 3:27 pm

#1146834
RE: How to add a "Rank" column to a view on the fly using a self join.

dtguin (4/6/2010)
OK, found the answer.... well at least how to do the query. I just need to wrap it in a view.
SELECT a1.name, a1.score, COUNT(a2.score) Rank
FROM Test a1, Test a2
WHERE...
--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 6, 2010 at 3:19 pm

#1146825
RE: SSRS In a Flash

Very nice intro. Well done. I'm definitely looking forward to the rest of the series.
--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 6, 2010 at 3:13 pm

#1146823
RE: FizzBuzz

Steve Jones - Editor (4/6/2010)
Sorry, my fault. I'll go review the entries this week and award something soon. Likely by Monday
Heh... hey Lynn! Good suggestion on using the DBCC...
--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 6, 2010 at 2:50 pm

#1146805
RE: UDF, Computed Column, Persisted, Determinism

Paul White NZ (4/6/2010)
Al B (4/5/2010)
Any thoughts would be greatly appreciated. If I'm barking up the wrong tree, I'd love to hear some alternate solutions.
The problem here is not 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 6, 2010 at 2:45 pm

#1146802

Viewing 15 posts - 38,986 through 39,000 (of 59,072 total)