Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,771 through 49,785 (of 59,099 total)

RE: difference between 2 values in the same column of a table

You can use a similar method in 2k, but you'll need to insert into a temporary table that has an IDENTITY column so that you get sequential numbers.
What you're looking...
--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 24, 2008 at 7:29 am

#833310
RE: Query Syntax error

Yep... suggestion is that you post the code that has the problem insert so we can see what you're actually doing and post the text from the actual error so...
--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 24, 2008 at 7:18 am

#833296
RE: help with data type and default value

I agree with Stephanie... you really need to find out both the what and the why... if they intend to use only numerics with leading zero's ... forever... then store...
--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 24, 2008 at 6:20 am

#833267
RE: Delete Rows from Table

Sound like you've got a pretty good plan...
Deleting from last month is easy... Let's change the definition just a bit to make this even more simple... you want 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)

June 24, 2008 at 6:13 am

#833261
RE: Concatenating Field Values

I'd try to help... but I can't even spell SSRS, yet. Sorry...
--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 24, 2008 at 5:59 am

#833254
RE: The Back Door DBA

Manie Verster (6/24/2008)
I downloaded on of your books on SQLServerCentral named SQL Server DBA Best Practices
Manie... what's the page link to get to that download?
--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 24, 2008 at 5:56 am

#833253
RE: database tuning engine problem

I've been having good success with DTA on set based code. Sometimes it's recommendations don't actually speed anything up but, as some have said about other tools, it's a...
--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 24, 2008 at 5:37 am

#833240
RE: For loop in sql server

venki (6/23/2008)
I got a doubt when I am trying to create a Stored Procedure.
I am pulling the data i.e recordset by written a query from different tables.
I supposed to modify...
--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 23, 2008 at 10:32 am

#832885
RE: Table var maximum row number

GilaMonster (6/23/2008)
Yup, though you can still get a stats-based recompile from the temp table, sometimes even more than once.
So... wouldn't that be a Catch-22? Optimizer says "I need a...
--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 23, 2008 at 10:29 am

#832882
RE: Table var maximum row number

GilaMonster (6/23/2008)
The main advantage I've seen for table vars is that they don't cause a stored proc to recompile.
That's pretty important for GUI code... which I normally don't write....
--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 23, 2008 at 10:15 am

#832866
RE: Forum Etiquette: How to post data/code on a forum to get the best help

JJ B (6/23/2008)
Jeff: Thanks for the response! I'll look into all those things.
- Jeannine Jennifer Bienn.
. According to family legend (my...
--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 23, 2008 at 10:10 am

#832857
RE: Forum Etiquette: How to post data/code on a forum to get the best help

JJ B... (Jar-Jar Binks???)
When you go to post code, take a look at the "IFCode Shortcuts" just to the left of the Edit window... click on the "code" pair there...
--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 23, 2008 at 9:31 am

#832806
RE: Table var maximum row number

Yeah... I know... Microsoft is pretty much non commital when it comes to stuff like that because the amount of memory and the I/O system will make it vary quite...
--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 23, 2008 at 9:01 am

#832768
RE: sa removal

Heh... Embarassingly simple. Thanks Stacey.
Mobasha... that's gotta be as good as deleting SA... still, your users are going to know that you can give SA privs to any login......
--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 23, 2008 at 8:54 am

#832759
RE: Pivot... I don't think it's possible...

By the way, Peter... you machine is about twice as fast as more poor ol' 6 year old single processor 1.8 GHz box... what are you using?
--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 23, 2008 at 8:48 am

#832753

Viewing 15 posts - 49,771 through 49,785 (of 59,099 total)