Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,331 through 54,345 (of 59,098 total)

RE: Inserting random order of numbers between defined range

Kewl! Anyone interested in a million row duration test on this? 😀 I'd need some help 'cause I don't have 2k5...
--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)

November 6, 2007 at 8:11 am

#748686
RE: Does the location of the AND part of a join clause affect the data returned

Thanks, Antares!
--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)

November 6, 2007 at 8:06 am

#748680
RE: Check a table exist and Delete

IF OBJECT_ID('sometablename,'U') IS NOT NULL
DROP TABLE sometablename
Lookup OBJECT_ID in Books Online... it's worth the read. 😉
--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)

November 6, 2007 at 7:37 am

#748663
RE: Speeding up query in a VBScript file

Heh... you've basically pulled the wings off of any chance of performance by using outside code to do something inside the database... you said that you want to import 26MB...
--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)

November 6, 2007 at 7:36 am

#748662
RE: maximum row size exceeds the allowed maximum of 8060 bytes

Heh... Michael, thank you for the high compliment! Made my day... 🙂
o1000, Michael is correct... what you want to do just seems tremedously odd and I want to see...
--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)

November 6, 2007 at 7:20 am

#748648
RE: Does the location of the AND part of a join clause affect the data returned

Heh... if you're worried that it will affect the data returned, you need to test!
And the position of the AND somecol = someval code does make a difference...
--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)

November 6, 2007 at 7:14 am

#748645
RE: Inserting random order of numbers between defined range

Since the numbers you want are 1 to 354 and not 0 to 353, you'll probably have to change John's code just a bit...
UPDATE Random_region_lookup_table
SET Place_key = Entry_key%354
... should probably...
--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)

November 6, 2007 at 7:09 am

#748640
RE: help need writing a query

This is a fairly common request and it always amazes me that folks would have two identical tables and be worried about synching up their contents. The only time...
--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)

November 6, 2007 at 6:55 am

#748633
RE: Table Hints

Catcha,
Someone tried to force some serious tuning on that query... the FORCE ORDER tells the optimizer to only consider the tables in the same order as they appear in 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)

November 6, 2007 at 6:48 am

#748630
RE: Inserting random order of numbers between defined range

Are the random numbers allowed to repeat within a generation and are others allowed to be missing as would a true random number provide?
--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)

November 6, 2007 at 6:24 am

#748616
RE: Join Help

Uh huh... sure does. Thanks, Matt 🙂
--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)

November 5, 2007 at 11:27 pm

#748515
RE: T-SQL

Heh... I appreciate the feedback and, if you look at my post, I agree... I was trying to point out that Books Online leaves a bit to be desired 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)

November 5, 2007 at 11:25 pm

#748514
RE: TSQL Error using Cursor to loop through sysdatabases (Syntax Error)

Koji Matsumura (11/5/2007)
search this forum on sp_MSforeachdb
Gosh... I wouldn't use that on a bet... it's got a cursor with some steroid rage going on. I suppose it's ok 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)

November 5, 2007 at 11:20 pm

#748513
RE: maximum row size exceeds the allowed maximum of 8060 bytes

Heh... I know what you mean, Pam... I've just got this insatiable curiosity... 😀
So, what say thee o1000? Why do you need to make over 300 NVARCHAR(MAX) columns?
--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)

November 5, 2007 at 11:16 pm

#748512
RE: Difference between Work Tables and TempTables

Also, to help you with the "dame good technical answers" for the "dame" good interview, test, or homework question ;), you really should turn to Books Online. A simple...
--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)

November 5, 2007 at 10:40 pm

#748509

Viewing 15 posts - 54,331 through 54,345 (of 59,098 total)