Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,796 through 54,810 (of 59,087 total)

RE: Table Description

Open Query Analyzer...
Press f8...
Drill down to table and "columns"...
--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)

September 30, 2007 at 8:09 am

#737513
RE: Secure part of table

I think you might need two roles... one for WebGroup and one for WebGroupAdmin which is where you'd put Tracey. Then maybe do some correct grants?
--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)

September 30, 2007 at 8:03 am

#737512
RE: Day Month Year D.B. fields vs YMD field using date functions

Simply put, there are more reasons than I could possibly post here as to why you should not, nay, must not store dates as 3 separate columns. The efficiency...
--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)

September 29, 2007 at 11:24 pm

#737498
RE: Filling in numbers

I gotta ask, because you're a newbie....
Why are you worried about reassigning barcodes? Bar codes can be made to easily exceed 2 billion (approximate max for an INT). ...
--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)

September 29, 2007 at 11:13 pm

#737497
RE: deduping query optimization

Hey there PoleCat... long time no "see"...
Is it the goal of this bit of code to update all but the "first" row for each customer what has been entered within...
--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)

September 29, 2007 at 11:06 pm

#737495
RE: More newbie system table help

Sergiy (9/28/2007)
Un-bloody-believable!
How could possibly a dude having no idea about binary get any job in IT industry???
BWAAAAA-HAAAAAAA-HAAAAAA!!!! Oh, stop it! You're killing me!!! 😀 They don't even...
--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)

September 29, 2007 at 10:22 pm

#737493
RE: Sproc calling Sproc

Transactions??? Why do you need transactions for this??? That's the 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)

September 29, 2007 at 10:03 pm

#737491
RE: can we modify system tables in SQL Server 2000?

A little exuberant on Remi's part... but I absolutely agree with Serqiy and Remi... writing to system tables is a form of "Death by SQL"... you will make a mistake...
--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)

September 29, 2007 at 10:01 pm

#737490
RE: Selecting Preformatted Dates in SQL Server 2000

I got the following from a fellow by the name of "Jeff Smith"... it's pretty much spot on and is a long winded version of what Serqiy posted, which is...
--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)

September 29, 2007 at 9:54 pm

#737488
RE: Sproc Design Question

OMG!!! Table driven code! What a concept 😉
Nice job, Serqiy...
--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)

September 29, 2007 at 9:43 pm

#737486
RE: "primary key" in Table Variable

Paul (5/3/2007)
Forget my original question...
Make believe that this has nothing to do with cursors, stored procs or anything else. I just want to know if anyone has ever seen...
--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)

September 29, 2007 at 9:39 pm

#737479
RE: How to update field in multiple Tables in database

Steve Jones - Editor (9/28/2007)
Ouch!
Noted and added to the list.
Heh... when are they going to get to the list I submitted, Steve?
--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)

September 29, 2007 at 9:31 pm

#737476
RE: About tuning store procedure

Bob Fazio (9/12/2007)
The following does a much better job explaining when/why to use table variables.
Also, be careful not to get into optimization overload. I still suggest that you spend...
--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)

September 29, 2007 at 9:26 pm

#737471
RE: Table Size

Normalize 'til it hurts! It'll save lot's of pain later on... kinda like the pain you're going through right now... 😉
--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)

September 29, 2007 at 9:21 pm

#737467
RE: Is this workable

Ninja's_RGR'us (9/29/2007)
Wow, 52 gig of space!!!! That's a lot of crap to put up with ;).
Ouch! Brain freeze! You just reminded me of a girl I used 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)

September 29, 2007 at 9:16 pm

#737463

Viewing 15 posts - 54,796 through 54,810 (of 59,087 total)