Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,601 through 45,615 (of 59,101 total)

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
RE: Why do people need to do this?

RBarryYoung (1/23/2009)
Some day you have to tell me how you get everyone's name like that. :unsure:
Heh... It's easy... be good to good people and then ask. 🙂
To make a longer...
--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 8:05 am

#932215
RE: Limiting users to views only in database

gisles (1/24/2009)
I was thinking about option 2 - create another database - but have never done that and do not know how to setup the views to be seen 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)

January 24, 2009 at 7:49 am

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

Hemin,
There's another way to do the same thing that's actually much faster if you have a large table you need to do this on. It, too, is covered 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)

January 24, 2009 at 7:20 am

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

Garadin (1/23/2009)
He wrote an article on it actually. See the Running Totals link in my signature.
Heh... I'm getting closer... normally, you beat me to this on providing solutions. ...
--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 7:02 am

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

hemin.shah85 (1/23/2009)
Jeff tons of thanks for this solution. It works perfect for my data. I would definately like to know logic behind this if you can throw some light on...
--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 6:54 am

#932204
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

tony.hayes (1/23/2009)
If it was a simple mail merge that might be possible, but we produce custom legal certificates in house on z-fold self seal documents, as well as W2's etc......
--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 23, 2009 at 9:51 pm

#932172
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

tony.hayes (1/23/2009)
URL is here:
http://pe.usps.com/text/dmm300/L801.htm
Typical government thinking - they only provide an electronic format in pdf
Thanks, Tony... lemme see what I can do.
--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 23, 2009 at 8:52 pm

#932161
RE: The Set-Based Limit

Like I said... just a little of 2.8 GB... I've got files much larger than that.
I've been through that with 2 companies now... they ignore the flagship product 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 23, 2009 at 8:49 pm

#932158
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

tony.hayes (1/23/2009)
Sorry, first post ever. The only way I could get the data electronically was to copy from where USPS had posted to their website. An example 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)

January 23, 2009 at 8:08 pm

#932145

Viewing 15 posts - 45,601 through 45,615 (of 59,101 total)