Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,291 through 52,305 (of 59,098 total)

RE: Analyzing membership "churn" -- gap duration and frequency

Thanks, JP...
--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)

February 28, 2008 at 5:21 pm

#783533
RE: View Hints (?)

colin Leversuch-Roberts (2/25/2008)
I never understand why it's assummed that a simple query from a view ( which is probably complex ) will work well. Forget your views and expand 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)

February 28, 2008 at 5:20 pm

#783531
RE: The Cost of Function Use In A Where Clause

Jeremy Giaco (2/28/2008)
Jeff Moden (2/28/2008)
Yes, they both "utilize" the index... but how? I think you'll find that utilization is limited to an Index SCAN and that you cannot get...
--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)

February 28, 2008 at 4:40 pm

#783517
RE: Alter column order

Ian Yates (2/28/2008)
I second Andras - I'm wary of software that absolutely requires the columns be in exact order due to their use of select * in queries and then...
--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)

February 28, 2008 at 11:59 am

#783396
RE: Sequential numbering issue

With as often as I've seen folks refer to it, we should all put the Forum Ettiquette link in our signature. I'll mod my sig tonight. Thinking about...
--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)

February 28, 2008 at 11:46 am

#783391
RE: I got burned today at a SQL Server Interview!

Oh yeah... that's it... oh... no, wait... I was thinking of just "flakes"... wrong show 😀
--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)

February 28, 2008 at 11:36 am

#783387
RE: The Cost of Function Use In A Where Clause

jeremy.giaco (2/28/2008)
I liked the article, but I don't seem to have the problem with my queries that you are describing when using functions like IsNull in the where clause. ...
--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)

February 28, 2008 at 11:31 am

#783385
RE: I got burned today at a SQL Server Interview!

Um... star schema's? Isn't there a sidewalk like that somewhere in Hollywood? 😀
--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)

February 28, 2008 at 9:06 am

#783293
RE: Sequential numbering issue

Ian Crandell (2/28/2008)
Thanks for the info. I have seen you use or refer to the tally table in many of your posts and now that I read this 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)

February 28, 2008 at 9:01 am

#783282
RE: I got burned today at a SQL Server Interview!

One piece of advice, I suspect these are meant to be open-ended questions,
I suspect they're really meant to find out if you actually know SQL Server or not. :P...
--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)

February 28, 2008 at 7:58 am

#783182
RE: I got burned today at a SQL Server Interview!

I'm curious, Mark... what position were you applying 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)

February 28, 2008 at 7:54 am

#783179
RE: The Cost of Function Use In A Where Clause

Matt Miller (2/28/2008)
I'm thinking he means that if you persist the computed column, you can then include it in the index being used to optimized the query. saves all...
--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)

February 28, 2008 at 7:45 am

#783169
RE: The Cost of Function Use In A Where Clause

smonarch (2/28/2008)
Why not create an index computed column where you can provide this capability for routinely used functions.
Ummmm.... not sure what you mean by an "index computed column".... how does...
--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)

February 28, 2008 at 7:35 am

#783161
RE: The Cost of Function Use In A Where Clause

GSquared (2/28/2008)
Alternately, if you don't often select by year, month, day, but do often join on the whole date, you can add a calculated column:
alter dbo.TableA
add DateColumnDate as cast(convert(varchar(25), DateColumn,...
--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)

February 28, 2008 at 7:23 am

#783151
RE: The Cost of Function Use In A Where Clause

David Jackson (2/28/2008)
This looks complex but will use your index.
where CreatedDate between dateadd(dd, datediff(dd,0,Getdate()),0) --midnight TODAY
and dateAdd(ss,-1,dateAdd(dd,1,dateadd(dd, datediff(dd,0,Getdate()),0)))...
--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)

February 28, 2008 at 7:14 am

#783146

Viewing 15 posts - 52,291 through 52,305 (of 59,098 total)