Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,586 through 45,600 (of 59,095 total)

RE: percentile in SQL Server 2005

Don't use any type of "INT" if you want decimal answers.
--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)

January 24, 2009 at 12:42 pm

#932270
RE: high cnter

samsql (1/23/2009)
the sp which was running was taking 1 hr rite now it is taking 7 hrs to complete...
There's a thousand things that can cause that to happen. Find...
--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)

January 24, 2009 at 12:41 pm

#932268
RE: Correct use of @variables and uniqueidentifiers

No, no... that's not it... I put them in my mouth to get them all lubricated up before I put them in the cannon. 😀
--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)

January 24, 2009 at 12:34 pm

#932266
RE: DBAs and the art of persuasion

anil.mahadev2009 (1/24/2009)
But then with a bit of luck and help from Google. I managed to download a tool and have the documentation done within 15 mins ;).
Heh... no, no... not...
--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)

January 24, 2009 at 12:27 pm

#932262
RE: How to replace a cell value with a cell value in previous row

Garadin (1/24/2009)
Way to hold out on me with the whole Order by trick by the way!
BWAA-HAA!! 😛 Dude! 😀 No hold out... it's in the article, too!...
--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)

January 24, 2009 at 12:12 pm

#932261
RE: How to replace a cell value with a cell value in previous row

hemin.shah85 (1/24/2009)
Jeff you are right. With(index(0)) works really fast...as I have a dataset of 6 million records..Thanks for your help..But I was thinking, can we do this without updating that...
--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)

January 24, 2009 at 12:10 pm

#932260
RE: Are the posted questions getting worse?

Gail has complained about the really ignorant answers that some folks place on the forum. I've got a perfect example of such ingnorance and it really burns me up...
--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)

January 24, 2009 at 11:45 am

#932254
Reply To: What is RBAR? How can I avoid it?

Sankar Reddy (1/24/2009)
Set based solutions tend to be faster than the RBAR operations while taking less system resources. Doing a task 100 times is much likely to take more time...
--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)

January 24, 2009 at 11:29 am

#932251
RE: What is RBAR? How can I avoid it?

By the way... the following article on "Alternatives to SQL Server Cursors"...
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AlternativesToSQLCursors&referringTitle=Home
... sucks. In one case, they use a WHILE LOOP instead of a cursor and in other...
--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)

January 24, 2009 at 11:25 am

#932250
Reply To: What is RBAR? How can I avoid it?

I agree with Seth and would like to point out a couple of other forms of RBAR to avoid...
CTE's are a wonderful tool... until you write a recursive CTE which...
--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)

January 24, 2009 at 11:17 am

#932248
RE: How to delimit ‘-’ string?

Sankar Reddy (1/24/2009)
There are no built-in SQL server functions that handle this. You have to write this yourself although this problem has been solved in many ways as Chris pointed...
--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)

January 24, 2009 at 9:30 am

#932231
RE: DBA job without experience? Is it possible?

You want experience and something you can point to on a "beginners" resume? Spend the 50 to 60 bucks to buy a copy of the SQL Server Developer's Edition....
--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)

January 24, 2009 at 9:26 am

#932229
RE: Globally filtering database tables

I agree with Jacob... well, except for combining everything into a single table and using views. Instead, look into the advantages of using a "partitioned table" and views. ...
--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)

January 24, 2009 at 9:19 am

#932228
RE: Storing NULL in a Varchar(MAX)

jacob sebastian (1/24/2009)
Swirl80 (1/24/2009)
thanks for the reply. If that is the case then why is there the "Sparse" column feature in 2008? If NULL takes up not space at 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)

January 24, 2009 at 9:15 am

#932227
RE: Temp Tables vs. Physical Tables

ALZDBA (1/24/2009)
also keep in mind temp tables (@ / # / ## ) are hosted in tempdb. tempdb is used at (sqlserver) instance level, for more than only storing temp...
--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)

January 24, 2009 at 9:13 am

#932226

Viewing 15 posts - 45,586 through 45,600 (of 59,095 total)