Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,511 through 45,525 (of 59,101 total)

RE: Earning Credit

Writing can be hard.
Heh... I'd have to say it's a real bugger for me. I don't know how you do it everyday. My hat's off to you.
--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 27, 2009 at 8:47 pm

#933603
RE: Execution Plans

phoqueme (1/27/2009)
When giving examples, there is no need to blunder through every possible case of Table Scans before "realizing" MS SQL will only use the index scan on the 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)

January 27, 2009 at 8:30 pm

#933599
RE: help me in improving my server performance

Stop using SSIS for ETL. Use BULK INSERT and some good T-SQL programming, instead.
--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 27, 2009 at 8:17 pm

#933597
RE: HELP WITH QUERY

JROCK (1/27/2009)
Thanks Lynn for the quick response. I was thinking that we could do an update query to select all records that was less than 9 characters long. ...
--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 27, 2009 at 8:11 pm

#933595
RE: Get 2nd Occurence

What is the maximum number of spaces that could occur and are periods ever going to appear in the 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)

January 27, 2009 at 8:09 pm

#933594
RE: SQL 2005 Ad-hoc reporting

Oh, yea... almost forgot. If you're going to allow end users to build their own queries through and ad hoc reporting tool, even if it's something as sophisticated as...
--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 27, 2009 at 8:06 pm

#933593
RE: SQL 2005 Ad-hoc reporting

Excel... with pass through queries to views in the database.
--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 27, 2009 at 8:04 pm

#933592
RE: Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables

I guess I should first say thank you for the wonderful acknowledgements. Thanks, Lynn.
It's also a real pleasure to read an article with a logical progression and a whole...
--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 27, 2009 at 7:54 pm

#933590
RE: Are the posted answers getting worse?

GilaMonster (1/26/2009)
Jeff Moden (1/26/2009)
The backup to such a "break" for the quirky update method is that the ORDER BY method also works although it works at about half the speed....
--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 27, 2009 at 7:13 pm

#933586
RE: Temp Tables vs. Physical Tables

ALZDBA (1/25/2009)
general performance guidelines can be found overhere http://support.microsoft.com/kb/110352/
Wow... they don't write 'em like that anymore.
--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 27, 2009 at 7:05 pm

#933585
RE: SMO vs SQL-DMO

Heh... WOW! C-O-F-F-E-E N-E-E-D-E-D H-E-R-E! 😛
--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 27, 2009 at 6:47 pm

#933583
RE: Calling VBScript or command file from within T-SQL without xp_cmdshell??

You still haven't answered my question... what does the VB Script do? Also, which direction is the BCP 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)

January 27, 2009 at 6:46 pm

#933582
RE: percentile in SQL Server 2005

Go back and look at my previous post... problem is NOT in the rowcount... it's how you're doing the math. Integer math will only yield integers and you need...
--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 27, 2009 at 6:43 pm

#933580
RE: SQL or Oracle

Heh... there are some places in Oracle that require RBAR... try writing a set based trigger in Oracle sometime... 😛
--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 27, 2009 at 6:29 pm

#933578
RE: Finding out UnUsed/sleeping indexes by srihari nandamuri

GilaMonster (1/27/2009)
Jeff Moden (1/26/2009)
Also, will that snippet of code tell you if the index was used as a SEEK or SCAN?
The query, as written won't. The DMV includes that info...
--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 27, 2009 at 6:23 pm

#933576

Viewing 15 posts - 45,511 through 45,525 (of 59,101 total)