Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,786 through 52,800 (of 59,098 total)

RE: Slow clustered index seek?

Thanks for the feedback... as always, my test data may not be 100% the same as your situation... once you've tried the index, lemme know how it works... might be...
--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)

January 22, 2008 at 8:56 pm

#770721
RE: Listing gaps in numeric sequences

There is... assuming that your serial numbers are actually integers...
SELECT GapStart = (SELECT ISNULL(MAX(b.SerialNumber),0)+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)

January 22, 2008 at 8:25 pm

#770716
RE: Extended Stored procedures - SQL 2000

Heh... make sure you get rid of that pesky TempDB database while your at it. 😛 All it does is take up room and cause headaches... saves a lot...
--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)

January 22, 2008 at 8:00 pm

#770712
RE: bulk loading from flat files

ashishchap (1/22/2008)
We are storing the information as xml instead of the tables to minimize the storage space. XML is a MUST for our database.
Just a passing thought... maybe even 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)

January 22, 2008 at 7:49 pm

#770711
RE: What is the advantage of telecommute?

I'll add a couple of more...
Everyone who doesn't telecommute will hate you (for obvious reasons).
Everyone who doesn't telecommute will perceive you as a slacker unless you produce double the work...
--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)

January 22, 2008 at 7:40 pm

#770709
RE: Slow clustered index seek?

Heh... I know what you're thinking and "No", do NOT change the order of the columns in the index I recommended 😉
--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)

January 22, 2008 at 7:31 pm

#770706
RE: Slow clustered index seek?

The PK Clustered Index you have might be good for something else, but it's no good for this query even though the execution plan say's you're using the clustered index......
--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)

January 22, 2008 at 7:30 pm

#770705
RE: Slower and slower.. what will you do...?

For testing purposes, how many file names are we talking about? And, if you don't mind, can you post the CREATE statment for the table, any existing indexs, 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)

January 22, 2008 at 6:38 pm

#770699
RE: Stripping out double quotes (") in bulk insert

Yowch! The data's a bloody mess. Who in their right mind would list the word "NULL" for a null in a transmitted text file nevermind add trailing spaces...
--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)

January 22, 2008 at 5:40 pm

#770696
RE: Coding Standards - Part 1

Steve Rosenbach (1/13/2005)
Jeff, you have expressed more eloquently and in far less words my frustration with ISO-11179... and I only read Part 5 - the part about naming conventions!
Thanks, Steve......
--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)

January 22, 2008 at 5:17 pm

#770692
RE: What T-SQL commands exist which can be used in Query Analyzer to export a select statement within a stored procedure?

That's not nice... Matt was spot-on by saying you weren't providing enough information. I simply took a guess and didn't say much more than he did.
--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)

January 22, 2008 at 5:04 pm

#770688
RE: Quarterly Breakdown

I do. In fact, I wrote an article about it that should be coming out soon! It was submitted way back on 11 Dec 2007...
--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)

January 22, 2008 at 5:01 pm

#770687
RE: Quarterly Breakdown

And that, folks, is a Triangular join... works seemingly fine on small groups... cripples CPU's on larger groups... be careful...
See the following URL for more details on Triangular joins...
http://www.sqlservercentral.com/articles/T-SQL/61539/
--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)

January 22, 2008 at 4:10 pm

#770682
RE: What T-SQL commands exist which can be used in Query Analyzer to export a select statement within a stored procedure?

Simply stated, there is no equivalent for Oracle's spool command. You can use OSQL with a DOS redirect to a file or BCP or DTS or...
--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)

January 22, 2008 at 2:11 pm

#770659
RE: A Reporting System Architecture

Gregory,
I'm curious... What size (in gig or tera-bytes) is your OLTP and Reporting databases?
--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)

January 22, 2008 at 1:51 pm

#770649

Viewing 15 posts - 52,786 through 52,800 (of 59,098 total)