Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,986 through 48,000 (of 59,102 total)

RE: Avoiding Curosr - Yet Another Situation

Heh... if you think THAT was fast, wait until you run the code. First time I demo'd it on a million rows in front of a group of people,...
--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)

October 3, 2008 at 5:39 pm

#880751
RE: Query String passed to URL

Jason Crider (10/3/2008)
Third party wants that data sent to a URL in the form of a query string.
So, create a chunk of code that will make a set of SELECT/UNION...
--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)

October 3, 2008 at 5:36 pm

#880749
RE: Pull data from one Column for a report

There's nothing there to relate state to county, etc, etc. Are the other columns in that table that might be used to do that?
--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)

October 3, 2008 at 5:22 pm

#880745
RE: sp_dboption

Don't do it that way... past the following URL into the URL box of Books Online and see...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8cfea566-8f89-4581-b30d-c53f1f2c79eb.htm
--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)

October 3, 2008 at 5:20 pm

#880744
RE: Difference between SQLServer 2005 and SQLServer 7.0 Queries

You can't rely on an "implicit" sort order... you'll need to use ORDER BY or GROUP BY WITH ROLLUP/CUBE.
--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)

October 3, 2008 at 5:13 pm

#880741
RE: Best way to reindex large tables/indexes

Yep... but with "VLDB's", hardware costs should be the least of your worries.
--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)

October 3, 2008 at 5:06 pm

#880740
RE: Autogrowth - Best Pratice

TheSQLGuru (10/3/2008)
>>Think "compound interest".
Think "read my post"! 😀
The default data file growth is ONE MEGABYTE, not TEN PERCENT (at least on all the servers I recall installing)....
--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)

October 3, 2008 at 5:01 pm

#880739
RE: Autogrowth - Best Pratice

Actually, I was talking about SQL Server 2000 'cause I'm still stuck in that world for better or worse. I forgot this was a 2k5 forum.
I just setup a...
--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)

October 3, 2008 at 4:58 pm

#880738
RE: Query help urgent

This is what happens when an OP doesn't post the correct requirements.
Sam... please read and heed the article at the link in my signature. I'm pretty much all...
--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)

October 3, 2008 at 5:51 am

#880405
RE: Hungarian notation convention

Andrew Gothard (10/3/2008)
...it's a snakepit of cursors and totally unnecessary temp tables and runs forever?
You just described the code at my new job... 😛 except instead of cursors, it's...
--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)

October 3, 2008 at 5:34 am

#880395
RE: Speed or Value?

I believe everyone knows what I'm going to say... good code can save a "slow" machine. I've seen too many people go down the primrose path of buying more...
--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)

October 2, 2008 at 9:55 pm

#880279
RE: sorting algorithm in sql server

Heh... the need for "bins" also explains the "Sort in TempB" option when rebuilding indexes. 😉
--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)

October 2, 2008 at 9:40 pm

#880277
RE: sorting algorithm in sql server

Sure... first, you have to know what a card sorter is...
http://en.wikipedia.org/wiki/IBM_80_series_Card_Sorters
Then, read the part that says...
Multiple column sorting is done by first sorting the least significant column, then proceeding, column...
--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)

October 2, 2008 at 9:38 pm

#880276
RE: Autogrowth - Best Pratice

TheSQLGuru (10/2/2008)
Jeff: Don't ever let the defaults for auto-growth on a database occur... it takes 73 disk fragments just to reach 1GB using the default settings.
I believe you are...
--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)

October 2, 2008 at 9:22 pm

#880272
RE: Script to return Rows count from table using sp_ExecuteSQL

Heh... No... I'm saying the following is wrong...
FROM sys.tables AS tbl where tbl.[font="Arial Black"]Name[/font] = CAST([font="Arial Black"]object_id(@TableName)[/font] AS VARCHAR(100)) ORDER BY 1
😉
--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)

October 2, 2008 at 9:15 pm

#880269

Viewing 15 posts - 47,986 through 48,000 (of 59,102 total)