Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,171 through 52,185 (of 59,072 total)

RE: Recursive query with different where clauses - very slow

The temp table is built in the first of the 5 queries I posted. Temp tables are session sensitive... they only "live" as long as the current session 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)

March 4, 2008 at 7:41 am

#784946
RE: Invalid use of 'newid' within a function.

Heh... It's always good to have someone else confirm the test in their own way. Thanks, Ian.
--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)

March 4, 2008 at 7:01 am

#784916
RE: Physically restarting the server

Rohit Chitre (3/4/2008)
10% Growth for mdf and ldf files of tempdb database is allocated. Maxsize is unlimited
When performance is said to be down number of users are deifinately high. But...
--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)

March 4, 2008 at 6:55 am

#784912
RE: Invalid use of 'newid' within a function.

I think you'll find that NEWID() is the exception to many rules that apply to other functions. Strange as it seems, it's the only true random number generator 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)

March 4, 2008 at 6:38 am

#784901
RE: Query improvement

Roy Ernest (3/3/2008)
Jeff Moden (3/3/2008)
I'm curious... why would you use UNION ALL or OR on such a thing?
I believe the person wants to do the query based on the year...
--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)

March 4, 2008 at 6:31 am

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

It's certainly no Panacea, but the following article has some insight as to why you can have performance problems with some UDF's in the SELECT list...
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)

March 4, 2008 at 6:29 am

#784894
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Heh... it's only fitting, Jack. I stayed up too late to write it 😛
Thanks for both the feedback and the tip on the PDF stuff... I really appreciate...
--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)

March 4, 2008 at 6:26 am

#784891
RE: Physically restarting the server

Ed is correct... and I go one further... what are the growth setting for your databases... I'm interested in all of the databases but I'm particularly interested in the growth...
--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)

March 4, 2008 at 6:21 am

#784888
RE: Recursive query with different where clauses - very slow

Not a problem... First, it can't be done in a view because of the temp table.
I'm not really using any form of recurrsion... I only stuff that meets the first...
--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)

March 4, 2008 at 6:18 am

#784886
RE: CLR and UDF

Muhammad Furqan (3/4/2008)
well "overkill"
?????????????????
Whats the alternative then?
because alternative people over here are mentioning are not working for me.
"EXEC @sql;" doesnt work in a UDF and if put in a stored...
--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)

March 4, 2008 at 6:12 am

#784879
RE: Invalid use of 'newid' within a function.

ST! Man, good to see you're still around! I thought you dropped off the face of the planet.
--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)

March 4, 2008 at 6:06 am

#784876
RE: Need some Logic Help on some row by row process

Oh yeah... I almost forgot... the CLUSTERED INDEX (PK in this case) is absolutely essential. Normally, I'd name the key in the FROM clause using a WITH(INDEX(indexname,TABLOCKX)) hint to...
--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)

March 3, 2008 at 8:54 pm

#784769
RE: Need some Logic Help on some row by row process

It's actually in Books Online under UPDATE...
Syntax
UPDATE
{
table_name 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)

March 3, 2008 at 8:51 pm

#784768
RE: How to lay out SQL Code

I have a really unique method of getting developers to follow the standards... I take them out to dinner and feed them nice juicy pork chops... with a slingshot! ...
--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)

March 3, 2008 at 8:42 pm

#784766
RE: to use break and continue

salinasalina2001 (3/2/2008)
hi all
i need to quote my columns into strings like
'"'+cast(columnname as data type())+'"' so that if the column name is FristName
to be displayed in notepad as "FirstName" ie...
--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)

March 3, 2008 at 8:24 pm

#784759

Viewing 15 posts - 52,171 through 52,185 (of 59,072 total)