Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,871 through 42,885 (of 59,102 total)

RE: CLR Fail to load

Heh... Jonathan probably could have told you that I'd ask this question... What does the CLR actually do?
--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 21, 2009 at 5:27 pm

#1028019
RE: Query that normally runs in Less than a second. Has been running long

Perhaps it's also time to do a couple of other things...
1. Re-evaluate what the clustered index is.
2. Optimize the code to be a bit more bullet proof.
--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 21, 2009 at 5:25 pm

#1028018
RE: Create CSV file using sp_send_dbmail with field delimiters

Ironically, the article on how to post data for a thread also contains your answer. Please see the first link in my signature below.
--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 21, 2009 at 5:24 pm

#1028016
RE: Query to rebuild/reorganize all indexes in the database?

Heh... don't over look what's in Books Online. If you lookup "DBCC SHOWCONTIG" and scroll down, you'll find a section with the following label...
[font="Arial Black"]E. Using DBCC SHOWCONTIG and...
--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 21, 2009 at 5:16 pm

#1028009
RE: Need some Cursor help...well I think it's a cursor I need

Heh... ROW_NUMBER from SQL Server 2005+ would certainly make this easy. But, this is 2k so we have to go back to brute force every once in a while.
I...
--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 21, 2009 at 5:09 pm

#1028008
RE: Are the posted questions getting worse?

I turned my TV into an aquarium... that way there's always something good on and it's never the same thing twice. Using the DVR motor for the pump.
--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 21, 2009 at 2:33 pm

#1027922
RE: Simple Query - long time

As a sidebar, I wonder why they think that's non-deterministic. Same thing goes with many of the date functions.
--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 21, 2009 at 2:26 pm

#1027918
RE: Crosstab not returning desired results

You bet. And, I just noticed that you're new to this forum. You did an absolutely outstanding job of providing the data in a readily consumable format 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)

July 21, 2009 at 2:23 pm

#1027915
RE: Sort a string in a stored procedure: not order by

Absolutely not a problem, Wesley. I just wanted to make sure folks interpreted your good post correctly. Too many will read just one or two lines and hit...
--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 21, 2009 at 8:42 am

#1027671
RE: Normalising data in semicolon-delimited format

Thanks, Simon. I can't take the credit for the original idea, though.
As a side-bar, you did make my day. So many people take a bit of code and...
--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 21, 2009 at 8:38 am

#1027668
RE: Read a non-delimited file and insert into table

touchmeknot123 (7/21/2009)
hey Jeff,
Yes, As I had written earlier that certain records have fixed length.
Like say
H1234NRina
H2345A123abcstreet
H3456Z23456
Above, 1st record "type" i.e. type N will have columns of length 5,1,4 only
Similarly, 2nd...
--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 21, 2009 at 8:33 am

#1027660
RE: Simple Query - long time

Tara (7/21/2009)
As i have union all from 2 tables, i thout of creating to seperate view for each table with indexes and join them in 3rd view but when creating...
--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 21, 2009 at 8:29 am

#1027653
RE: Sort a string in a stored procedure: not order by

chandrika5 (7/21/2009)
The 4 values was just an example. The strings could be of varying length. I would not expect this to go in double digits.
I have not worked with tally...
--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 21, 2009 at 8:27 am

#1027648
RE: How to convert hhmm into datetime 13:30:00 T-SQL?

Chethan Srinivas Shetty (7/21/2009)
Thanks for enlightening me on the use of reverse and substring. Is a flexible way of manipulating string formats into numbers. cheers
Just be careful, Chethan... REVERSE is...
--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 21, 2009 at 6:28 am

#1027560
RE: Creating millions of records in one go

Chris Quinn (7/21/2009)
I have just tried both your and my procedures on a copy of my live database with the following results:
My procedure - 500,000 records - 1m 27s
Your procedure...
--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 21, 2009 at 6:21 am

#1027553

Viewing 15 posts - 42,871 through 42,885 (of 59,102 total)