Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,661 through 42,675 (of 59,067 total)

RE: Query Performance is very slow

balbirsinghsodhi (7/30/2009)
2. Fragmentation. There is no fragmentation
Heh... "Must Look Eye". 😛
--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)

July 30, 2009 at 6:06 pm

#1032754
RE: Is it legal to use Developer edition in QA environment??

All of that certainly sounds right and it's certainly coming from two of the folks that I have a high degree of inherent trust for, but I'd like 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)

July 30, 2009 at 6:04 pm

#1032753
RE: comma delimited file, header has a different number of columns than the body

It's all TOO common and, yes, it's a bad practice. That "extra" information should usually be a part of the file name.
The method you've chosen isn't bad for your...
--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)

July 30, 2009 at 5:05 pm

#1032739
RE: Are the posted questions getting worse?

Roy Ernest (7/29/2009)
Congratulations to Grant for winning the "Best Thing I Learned at PASS Summit" contest. 😀
What's the link?
--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)

July 30, 2009 at 4:48 pm

#1032736
RE: Recursive User Defined Procedure

bhavesh_183 (7/30/2009)
I got it guys .... Thanks every one
Bhavesh
Heh... have what? Share some code! 😉
--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)

July 30, 2009 at 4:44 pm

#1032735
RE: Recursive CTE Vs Temp Table in Recursive User Defined Procedure

Here's a link...
http://www.intelligententerprise.com/001020/celko.jhtml
Just be a little careful... one of the many articles on the Web for Nested Sets has two things to be slightly concerned with and I don't remember...
--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)

July 30, 2009 at 11:48 am

#1032575
RE: More Can Come From Less

Lynn Pettis (7/30/2009)
I think I may have a solution to businesses that think salaried people should be expected to work 40+ hours all the time. With the exception 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)

July 30, 2009 at 10:25 am

#1032515
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Lynn Pettis (7/30/2009)
Jeff Moden (7/30/2009)
Lynn Pettis (7/30/2009)
Well, it's late and i need to go to work later this morning. Missed work yesterday due to a family emergency. Mother-in-law...
--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)

July 30, 2009 at 10:23 am

#1032512
RE: GetDateTime Function

Ummm... CONVERT is relatively expensive and so are all of the substrings not to mention the use of a UDF...
SELECT CAST(STUFF(STUFF('200907111400',11,0,':'),9,0,' ') AS DATETIME)
--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)

July 30, 2009 at 9:58 am

#1032493
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Lynn Pettis (7/30/2009)
Well, it's late and i need to go to work later this morning. Missed work yesterday due to a family emergency. Mother-in-law had a heart attack....
--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)

July 30, 2009 at 9:48 am

#1032487
RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Grant Fritchey (7/30/2009)
Glad to hear it's fixed. I don't think you did what I was going to suggest, clean out the registry & then try the reinstall. I had 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)

July 30, 2009 at 9:46 am

#1032485
RE: More Can Come From Less

Man, do I agree with that. I just turned down a huge offer from a company because they actually expected a 55 hour work week.
Managers and owners, wake up......
--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)

July 30, 2009 at 9:43 am

#1032484
RE: Select into from huge table with indexes

I agree with Grant.... BCP out to a file at the source, BULK INSERT from the file to the destination. If you use the "NATIVE" option of BCP, it'll...
--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)

July 30, 2009 at 9:39 am

#1032478
RE: Loading Data from Text file to SQL Server

Bulk Insert will work fine if the server can see a "share" on your local machine.
So far as the "0'/Null thing goes... load it into a staging table and change...
--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)

July 30, 2009 at 9:36 am

#1032477
RE: Sql cursor is not returning data

You don't need a cursor for this. Use a simple two table join.
--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)

July 30, 2009 at 9:32 am

#1032474

Viewing 15 posts - 42,661 through 42,675 (of 59,067 total)