Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,911 through 41,925 (of 59,098 total)

RE: Help writing a SQL

Greg Snidow (9/17/2009)
Ok, this might be a dumb question, but if I specify the physical order of the records on the insert, then why is the index so vital? ...
--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 17, 2009 at 10:06 pm

#1055358
RE: Help writing a SQL

Seth,
I haven't executed your good code but it looks right. My only suggestion would be to add OPTION (MAXDOP 1) to the update to prevent any parallelism which will...
--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 17, 2009 at 9:54 pm

#1055352
RE: Help writing a SQL

Garadin (9/17/2009)
It's ok. Everybody forgets the index :-P.
I'm still looking for another way to do iterative logic that can compare with this method. I've heard CLR functions can...
--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 17, 2009 at 9:47 pm

#1055351
RE: Help writing a SQL

First, apologies for not having the rewrite on the running total article done, yet.
Part of the reason it's not done yet is I've been testing the heck out of some...
--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 17, 2009 at 9:41 pm

#1055349
RE: How To Efficiently Index Using a VARCHAR Column?

Grant Fritchey (9/17/2009)
Jeff Moden (9/17/2009)
To the rest of you folks, I just want to say "Thanks" for backing me up. I've been under the weather and in bed 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)

September 17, 2009 at 8:56 pm

#1055343
RE: How To Efficiently Index Using a VARCHAR Column?

crainlee2 (9/17/2009)
Jeff,
I'll post my test code when I get back to work tomorrow morning.
In the meantime, may I suggest a hot toddy: A small glass, a little lemon juice,...
--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 17, 2009 at 8:52 pm

#1055342
RE: How To Efficiently Index Using a VARCHAR Column?

Matt Whitfield (9/17/2009)
Jeff Moden (9/17/2009)
I've been under the weather and in bed for the last 18 hours or so...
That doesn't sound like enough time to recover from being under the...
--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 17, 2009 at 8:49 pm

#1055340
RE: Single table format

ananda.murugesan (9/17/2009)
Jeff Moden Thanks for your reply ..
It is a good script. For find out unused spaces for all tables.
I could executed this script, but i am getting afried 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)

September 17, 2009 at 8:46 pm

#1055339
RE: How To Get Table Row Counts Quickly And Painlessly

SPK (9/17/2009)
SELECT object_name(id), rows
FROM sysindexes
WHERE INDID IN(0,1)
AND object_name(id) NOT LIKE 'sys%'
Gives all the tables and the rows in each table.
As has been said before in this thread, that won't be...
--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 17, 2009 at 8:16 pm

#1055336
RE: high CPU usage

chidev (9/15/2009)
I'm new at the job and the network admin claims that it is a quad core 8GHz. On the same box they have both x64 bit and x32...
--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 17, 2009 at 8:13 pm

#1055335
RE: Help with BCP format error

Ummm.... are you all set 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 17, 2009 at 7:51 pm

#1055331
RE: Gotcha with dates

Matt Whitfield (9/15/2009)
My guess (place your bets now people) is that in your UDF you are calling DateTime.Parse(). If that's the case, use DateTime.ParseExact(). Pass in null for the IFormatProvider.
I've...
--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 17, 2009 at 7:50 pm

#1055330
RE: CPU utilization going 100% while running a select query.

KKK-862329 (9/12/2009)
Hi,
The table has total nine Indexes. May be I have given the total indexes size. The other thing I observed from the query execution plan that the 92% cost...
--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 17, 2009 at 7:43 pm

#1055328
RE: Can't Import Data Fast Enough - Optimize or rethink the design?

winterminute (9/15/2009)
There are 18 columns. The 8 indexs corespond to a potential WHERE clause. I seem to recal reading that any column that could be used in 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)

September 17, 2009 at 7:40 pm

#1055327
RE: Are the posted questions getting worse?

Grant Fritchey (9/17/2009)
lmu92 (9/17/2009)
Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste...
--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 17, 2009 at 7:28 pm

#1055324

Viewing 15 posts - 41,911 through 41,925 (of 59,098 total)