Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,101 through 47,115 (of 59,101 total)

RE: My application's response time has gone down from 20 sec to 2 sec after upgrading from SQL Server 2000 to SQL Server 2005.

You're lucky... I've also seen it do just the opposite.
--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)

November 20, 2008 at 8:05 pm

#901397
RE: Select based on Date- How to?

mpdillon (11/20/2008)
It was late. The DateAdd function is incorrect. It should read.
DateAdd("d",1,Now)
or in VB 2008
DateAdd(DateInterval.Day,1,now)
T-Sql to the left of the operator, VB to the right.
Nope... should be DateAdd(d,1,GETDATE()) in T-SQL....
--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)

November 20, 2008 at 8:03 pm

#901396
RE: Any one can send me answers for these

venkat (11/19/2008)
Hello Mister
I don't know who you are? And remind one thing may be you are not a Database Administrator because of as...
--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)

November 20, 2008 at 7:52 pm

#901391
RE: How to minimize processing time when using a cursor

Lynn Pettis (11/20/2008)
Kicking_Fish0713 (11/19/2008)
Thanks for a quick response.I don't use hardcoded values that's why I'm using a cursor.Can you pls send me a sample script using a cursor?
Thanks in advance.
First...
--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)

November 20, 2008 at 6:48 pm

#901373
RE: SQL Table Variables

longobardia (11/20/2008)
Chris,
I couldn't bare the pain any longer reading your suggestions.
Let me give hime the answer:
SELECT T1.ObjectID FROM....
SELECT T2.ObjectID FROM ....
see below:
IF EXISTS(SELECT T1.ObjectID FROM @tmp_subjects t1
...
--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)

November 20, 2008 at 6:43 pm

#901371
RE: Are the posted questions getting worse?

Adrian Nichols (11/20/2008)
Jeff Moden (11/19/2008)
Boy oh boy do I ever agree with that! Guess that makes us "elitists", huh? 😛
I wouldn't say that makes you elitist in the slightest....
--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)

November 20, 2008 at 6:38 pm

#901370
RE: Update Table based on Sum()

Christopher Stobbs (11/20/2008)
Thanks Jeff,
Very useful info there 🙂
You bet, Chris... thanks for the feedback.
--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)

November 20, 2008 at 6:02 pm

#901362
RE: Update Table based on Sum()

riverswillbeer (11/20/2008)
Wow ... that would suck !! I thank you for the correction. I obviously try to solve the issue using web resources and trial...
--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)

November 20, 2008 at 5:59 pm

#901360
RE: Bulk Insert Grief

Jim Russell (11/20/2008)
Jeff: did your "awesome idea" involve something other than BULK INSERT?
Combination of that and "something else". Dunno if it'll be worth it, but wanted to give 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)

November 20, 2008 at 5:46 pm

#901358
RE: How to minimize processing time when using a cursor

You already have one. Any cursor code is going to be slow.
--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)

November 20, 2008 at 12:28 am

#900904
RE: Select based on Date- How to?

That's a pretty good and correct summary (heh... except for the format function). And, yes, you do understand.
--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)

November 19, 2008 at 10:19 pm

#900878
RE: MS SQL Aggregate Function

You bet. Thank you for the feedback.
Now you know why I asked to see your query. For more information on how to get better answers quicker on future...
--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)

November 19, 2008 at 10:16 pm

#900875
RE: getting rid of 0's in the start of a varchar(6) column

Phil Parkin (11/19/2008)
If it's numeric, cast to integer, otherwise leave as is:
declare @value varchar(10)
Set @Value = '0000006708'
if IsNumeric(@value) = 1
select cast(@value as integer)
else
select @value
Phil
Works fine......
--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)

November 19, 2008 at 9:36 pm

#900863
RE: MS SQL Aggregate Function

SELECT t.Title_ID, t.Type, t.Price, d.AvgPrice
FROM dbo.Titles t
INNER JOIN
(--==== Derived table "d" finds average Price for each...
--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)

November 19, 2008 at 9:32 pm

#900862
RE: Update Table based on Sum()

Thanks for the feedback...
Just a bit of undocumented warning... we've had several problems in the past where using a correlated subquery in the WHERE clause of an update will occasionally...
--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)

November 19, 2008 at 9:14 pm

#900858

Viewing 15 posts - 47,101 through 47,115 (of 59,101 total)