Jeff Moden

Forum Replies Created

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

RE: Why do we need to reboot the SQL server..?

I'm with Grant... you should be able to run a server for years without a reboot. I'm also with the others on shrinking stuff. Don't do it unless...
--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:34 pm

#1055374
RE: Parse data colunm into 3 columns

Ah... almost forgot... I need to know the name of the table and I need to know some details about what the Primary Key is. The easiest way 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 17, 2009 at 10:14 pm

#1055366
RE: Parse data colunm into 3 columns

vmon,
Will the single column ALWAYS contain the data in the same order?
--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:12 pm

#1055364
RE: Parse data colunm into 3 columns

vmon (9/17/2009)
I have data stored in a single varchar(500) column. It contains data that is pipe delimited, 3 pieces of information that I want to put in 3 seperate...
--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:11 pm

#1055363
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

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