Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,881 through 41,895 (of 59,102 total)

RE: temp db is logspace used is >90%.

Wait just a minute here, folks... 90% of WHAT??? If it's 90% of the default size, no one cares. If it's 90% of the entire hard disk, then...
--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 20, 2009 at 4:36 pm

#1056068
RE: Passed 70-432

Dang... as old as the post is, I missed it. Way to go, Tommy, and thanks for the feedback on the book!
--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 20, 2009 at 4:28 pm

#1056067
RE: SQL query

newbieuser (9/19/2009)
Hi friends,
I run this query in Oracle to find the duplicates of all occurences in a table for the pk values.
SELECT * FROM qtral WHERE (tral_no, tral_pd)
in...
--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 20, 2009 at 4:26 pm

#1056066
RE: Importing csv files into SQL table using openrowset and format files

dbo.benyos (9/20/2009)
Microsoft LogParser does great job regarding varying commas inside CSV and type controlling what goes into SQL
Tal... I've not heard of the Microsoft LogParser. How do you use...
--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 20, 2009 at 4:22 pm

#1056065
RE: Please review BCNF (Put things where it belongs)

David Portas (9/19/2009)
Jeff Moden (9/19/2009)
With those kinds of semantics at your beckon-call
What do you mean by that? You have a different understanding of what a "surrogate key" is? Then please...
--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 20, 2009 at 3:51 pm

#1056064
RE: Help writing a SQL

Man, this is fun to watch... it's a real pleasure to see someone else willing to take on all comers in favor of the "Quirky Update".
Seth, keep 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)

September 20, 2009 at 3:32 pm

#1056062
RE: Are the posted questions getting worse?

Alvin Ramard (9/19/2009)
Jeff Moden (9/19/2009)
I had a peta byte once... Some antibiotics and a tetanus shot took care of the problem. 😛
Jeff, don't you know how to spell?
What you had...
--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 20, 2009 at 3:25 pm

#1056061
RE: find current CPU usage

No... there is no concrete solution because there is no concrete source to the problem. There are many things (usually bad code either from the GUI's or in stored...
--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 19, 2009 at 6:42 pm

#1056014
RE: high CPU usage

chidev (9/18/2009)
It normally takes 5-6 mins for the update stored proc I posted. It took around 45 mins to complete until I started archiving records from a 50 mil...
--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 19, 2009 at 6:30 pm

#1056011
RE: Are the posted questions getting worse?

D.Oc (9/18/2009)
Jeff Moden (9/18/2009)
Paul White (9/18/2009)
¿???p??? o? p??? si?? pui? lli? ????dsi??? u?????ou ??? ?o?? ?ldo?d ?i ??puo? i
Heh... I guess it literally depends on how you look at 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)

September 19, 2009 at 6:21 pm

#1056010
RE: Are the posted questions getting worse?

I had a peta byte once... Some antibiotics and a tetanus shot took care of 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 19, 2009 at 6:17 pm

#1056009
RE: selecting specific amount of strings

Well, shoot... I thought you might have been onto something, Dave. I did have to make some very minor changes to your code so it could handle CSV's with...
--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 19, 2009 at 4:31 pm

#1056002
RE: Pulling Filename from Windows directory into table

So far as why the filenames begin duplication at the 256th file, I have no idea. It must be a limit in the sp_AO* sprocs. I can't imagine...
--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 19, 2009 at 2:56 pm

#1055993
RE: Pulling Filename from Windows directory into table

Apologies for the delay. This will do the trick so long as you understand that if MS ever changes the spacing on the output of the DOS DIR command,...
--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 19, 2009 at 2:50 pm

#1055989
RE: Help writing a SQL

Richard Fryar (9/19/2009)
This is only designed for small data sets anyway...
I'm not sure how to say this without someone taking offense, so please take no offense. I know of...
--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 19, 2009 at 2:28 pm

#1055987

Viewing 15 posts - 41,881 through 41,895 (of 59,102 total)