Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,241 through 51,255 (of 59,102 total)

RE: Optimizing SQL Query

Grant Fritchey (4/7/2008)
By the way, from what I can see, GetMatricule is going to force the query to function like a cursor, running this select statement for each row 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)

April 7, 2008 at 8:14 pm

#799510
RE: T-SQL Help

Uh, huh... several different ways in the following URL along with some performance pit-falls to avoid...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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, 2008 at 8:02 pm

#799508
RE: Back door on Information_Schema

It would be an aggregate query to sum all the CDRs (Call Detail Records for Telephone Billing) for a about 120 thousand customers in a 4-5 million row table. ...
--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, 2008 at 7:57 pm

#799507
RE: Back door on Information_Schema

Steve Jones - Editor (4/7/2008)
Yikes!
Just put it in the Version Control script for database creation 🙂
Hi Steve,
As with Matt, I always appreciate it when you jump in on one 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 7, 2008 at 6:13 pm

#799487
RE: Back door on Information_Schema

Matt Miller (4/7/2008)
That level of detail ain't going to help you much.
Matt... thanks for the help. You're right, though... not a big fan of CLRs but could be convinced...
--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, 2008 at 6:07 pm

#799486
RE: Back door on Information_Schema

Matija Lah (4/7/2008)
Almost. If there's a view of the same name in the current database then the local view will be used.
Thanks Matija Lah... I agree... that's why it's never...
--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, 2008 at 2:49 pm

#799442
RE: Back door on Information_Schema

Matt Miller (4/7/2008)
I know this is a REALLY ugly trick.... put "SP_" as the prefix. by doing that - it will go try to find the view in MASTER....
--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, 2008 at 2:47 pm

#799440
RE: How to split cells in table format?

meghna.bhargav (4/7/2008)
In sql , how it can be done?
thanks
Like I said in my previous post, I don't think spreading a single header over 3 columns can be done. 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 7, 2008 at 7:38 am

#799123
RE: How to split cells in table format?

I don't know if it can be done in reporting services... header "cells" would need to be "merged" as if on a spreadsheet. I'm sure it can't be done...
--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, 2008 at 7:15 am

#799097
RE: How to split cells in table format?

Sorry... I'm still not getting it and I want to make sure... you posted the following...
for item : A B
...
--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, 2008 at 7:00 am

#799085
RE: join problem

Sergiy (4/6/2008)
I once improved responce time of the query from 10 s to under 1 s just by replacing NOT IN with NOT EXISTS.
Don't remember exactly how many rows were...
--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, 2008 at 6:52 am

#799079
RE: join problem

rbarryyoung (4/7/2008)
Well, NOT IN has had some bugs in SQL Server 2000, so that is certainly possible. They are mostly cleared up in Sql2005.
What kind of bugs, Barry?
--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, 2008 at 6:51 am

#799078
RE: Indexed View Sql Server 2005

You will never get an INDEX SEEK using SELECT *... only index scans.
My most sincere apologies... the comment above does NOT apply to INDEXED VIEWs.
What matters is what 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)

April 7, 2008 at 6:36 am

#799062
RE: What kind of DBA are you?

rbarryyoung (4/6/2008)
Jeff Moden (4/6/2008)
Heh... I handed Babbage gears 😉
Good one. 🙂
I was serious about my Uncle though, he really did do all of that stuff.
I have no...
--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, 2008 at 5:57 am

#799044
RE: What kind of DBA are you?

Either way, you're going to annoy someone!
Not to worry... Anyone who actually takes the time to get upset at either isn't someone you have to worry about offending because, although...
--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, 2008 at 5:51 am

#799043

Viewing 15 posts - 51,241 through 51,255 (of 59,102 total)