Jeff Moden

Forum Replies Created

Viewing 15 posts - 58,111 through 58,125 (of 59,067 total)

RE: Deleting duplicate records

I absolutely agree with Richard and Tim... if you have dupes in a table, something is usually wrong. However, it might not be your fault because of data you receive...
--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)

June 17, 2006 at 9:29 pm

#644483
RE: Is it better to use sprocs or functions?

It really depends on the sproc you build... if it returns a scalar value, as does a function, then there's no advantage to a sproc and it's easier to use...
--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)

June 17, 2006 at 7:48 am

#644460
RE: Float as primary key

BigInt should do just about anything you need. BigInt holds a huge number ((2^63) -1) and much less behind the scenes processing is done by SQL Server on the Int and...
--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)

June 17, 2006 at 7:33 am

#644457
RE: What are the negative performance hits from using table variables?

SOMETIMES the performance is similar... SOMETIMES a table variable will absolutely kill performance... read the following to find out why... pay particular attention to "Q3" and "Q4"...
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
--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)

June 17, 2006 at 7:16 am

#644456
RE: Transaction lvel isolation with INSERT/UPDATE

I'd recommend that, whatever you do, you do NOT use "Set Transaction Isolation Level" in updatable views... don't know when it will happen but you will eventually run across an...
--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)

June 17, 2006 at 7:09 am

#644455
RE: which one is best

I'm pretty sure that you cannot pass an array... guess that leaves a CSV parameter...
If you don't have very many parameters in the "list", why not pass them as individual...
--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)

June 16, 2006 at 6:00 pm

#644442
RE: Indexed View Creation Problem:

Unless it is a homework problem, I see no practical reason to index the view... the underlying indexes of the tables will inherently be used during normal view resolution.
--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)

June 15, 2006 at 11:31 pm

#644144
RE: Anyone have ideas how to solve deadlock problems

Strangely enough, you'll usually find a direct correlation between poor performance code and deadlocks and, with the exception of not allocating enough memory, hardware is not usually the problem nor...
--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)

June 15, 2006 at 11:20 pm

#644143
RE: Importing and Exporting Data

It's apparent, now, the interviewer was asking the interviewee to think outside the box. The original poster didn't explain it was an interview question until after I asked "why". 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)

June 15, 2006 at 11:11 pm

#644140
RE: Distributed App SQL Help

I have an SQL Server based IVR at work (actually, 400 miles away from the main DB)... it uses a linked server connection with multiple pass through views as 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)

June 14, 2006 at 5:09 pm

#643828
RE: Looping?

Got it! Thanks for the feedback, Susan.
--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)

June 14, 2006 at 5:01 pm

#643827
RE: Anyone have ideas how to solve deadlock problems

You bet, Kevin. Thank you and Niles for the feedback...
Kevin, could you tell us the actions you took? Bet, lot's of folks would like to hear what the lickiest guy...
--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)

June 14, 2006 at 4:48 pm

#643826
RE: Temp Table Vs table variable

Thanks for looking, John. If I find anything from Microsoft, I'll be sure to post it.
--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)

June 14, 2006 at 7:51 am

#643644
RE: Looping?

One other BIG thing to consider before you delete anything... do you have a permanent backup of the data you are about to delete? One of the 10 commandments 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)

June 14, 2006 at 7:45 am

#643641
RE: Distributed App SQL Help

Sorry about the confusion on the owners... I'm used to folks putting everything into production as "dbo". Yes, the views you speak of would certainly and easily solve that problem...
--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)

June 14, 2006 at 7:36 am

#643636

Viewing 15 posts - 58,111 through 58,125 (of 59,067 total)