Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,061 through 42,075 (of 59,102 total)

RE: Unique Index Causing Slow Read Performance

GilaMonster (9/8/2009)
(Hey, please, I know this site is prettly much dedicated to the hunting down and elimination of dynamic SQL. I know what rbar is and who Jeff Moden...
--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 8, 2009 at 8:12 am

#1050536
RE: IF condition in CURSOR

Before you do, please read the following article for the best format to present that info in... it'll really help folks concentrate on your problem...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--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 8, 2009 at 8:05 am

#1050530
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

Folks, it doesn't need to be ugly (although this won't take care of the double spaces at the end of a sentence) and it doesn't need to be difficult 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)

September 8, 2009 at 12:02 am

#1050311
RE: Using the Best

Aye... you've hit a sore spot for me. I love new things but only when they actually are the "best" for the job. When 2k5 first came out,...
--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 7, 2009 at 10:39 pm

#1050295
RE: OPTION (Max Recursion)

I'd love to see a performance test between HID's and the Nested Set Model for both up and downline queries as well as the addition and deletion of mid hierarchy...
--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 7, 2009 at 7:06 pm

#1050264
RE: Please Help

"Full tablespace"... this is obviously an Oracle interview question. You should consult an Oracle forum because an SQL Server answer will be totally different.
--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 7, 2009 at 4:00 pm

#1050243
RE: Fastes way to increment an id column

This isn't a true 'quirky' update unless there's a clustered index to determine the order of the ID assignment
I kind of agree and kind of don't. In the 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)

September 6, 2009 at 10:06 pm

#1049965
RE: Auto Increment

Yeah... I know... which 5 days? What happens if you reach 60 hours before 5 days is complete? I know he didn't say it, but I've got 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 6, 2009 at 9:06 pm

#1049960
RE: Auto Increment

I guess I don't understand a couple of things... when you say you want to "randomly generate the 3rd and 4th column", do you mean just for the test data...
--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 6, 2009 at 4:34 am

#1049805
RE: Use DSN in SQLCLR

meelan (9/5/2009)
Okey, great.
This is the scenario. I need to pull only selected information from a NAV Customer table. So, I bult a stored procedure in CLR to accept a customer...
--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 5, 2009 at 7:55 pm

#1049798
RE: how to convert number to minute

And... don't use the following unless you can tolerate up to a second of error...
SELECT DATEADD(ss,d.NumericTime/1000000.0,0)
FROM --This must makes the test data
...
--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 5, 2009 at 12:48 pm

#1049779
RE: how to convert number to minute

Ummm... your original request said "minutes", but the following will give you seconds, as well.
SELECT DATEADD(ss,d.NumericTime/3600000000.0*3600,0)
FROM --This must makes the test data
...
--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 5, 2009 at 12:45 pm

#1049778
RE: Stored procedure Usage

Sure...
First, if you format dates or currency in SQL Server, you have to unformat it to do any math on the GUI side.
Second, if you format dates or currency 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 5, 2009 at 12:24 pm

#1049775
RE: how to convert number to minute

Replace the ",0" in the DATEADD with the WHOLE date you want to add the time to.
SELECT DATEADD(mi,d.NumericTime/3600000000*60,0)
FROM --This must makes the test data
...
--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 5, 2009 at 12:19 pm

#1049774
RE: Can we schedule a job to generate scripts for objects?

If you have an old copy of SQL Server 2000 laying around and it doesn't share an instance of 2005 (which deletes the program), make a copy of the SCPTXFER.exe...
--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 5, 2009 at 10:40 am

#1049763

Viewing 15 posts - 42,061 through 42,075 (of 59,102 total)