Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,506 through 44,520 (of 59,101 total)

RE: Slow performing select statement on large table

Yeppp... couple/three things... first, it sounds like you may have a little "parameter sniffing" going on. Google'ing that will produce a pot wad of information on what it is...
--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)

March 21, 2009 at 4:13 pm

#964028
RE: CEO

Amit Lohia (3/18/2009)
Steve Jones - Editor (3/18/2009)
http://www.steverrobbins.com/articles/ceojob.htm
Steve, in your own word please. One sentence.
Shoot... you don't need a whole bloody sentence... you can sum it all up in one word...
[font="Arial...
--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)

March 21, 2009 at 4:02 pm

#964026
RE: T-Sql rant

Sure... well, maybe except for the article thing. I was thinking that the idea of using a sequence table correctly would make a good article right after I wrote...
--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)

March 21, 2009 at 3:31 pm

#964023
RE: updating CLR UDFs / Procedures strategy: contributions needed.

You've managed to hit the other area that I drop the sword and shield on for CLR deployment... file management. 😉
As you know, hierarchical data in SQL Server is 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)

March 21, 2009 at 3:17 pm

#964022
RE: query

ab5sr (3/21/2009)
Tell him "it depends". Ask him if DBCC FREEPROCCACHE or DBCC DROPCLEANBUFFERS has been executed first, and then follow up with the parse, optimize, etc. steps answer. You can...
--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)

March 21, 2009 at 11:38 am

#964005
RE: T-Sql rant

You get no argument by me... I'd much rather use the highly scalable high performance method of using IDENTITY than going through all of the headaches of using the likes...
--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)

March 21, 2009 at 11:28 am

#964003
RE: updating CLR UDFs / Procedures strategy: contributions needed.

... and, I apologize for not being able to help you with your original question.
--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)

March 21, 2009 at 10:40 am

#963995
RE: updating CLR UDFs / Procedures strategy: contributions needed.

Giovanni (3/21/2009)
Well,
I know about the ever going discussion on pros/cons, dos/donts between CLR UDTs/UDs and T-SQL ones.
I must admit I am not a fan of religion wars, so I generally...
--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)

March 21, 2009 at 10:38 am

#963993
RE: serial no

Dangit... sorry folks... I posted in a hurry and left out the underscore in ROW_NUMBER(). Andrew has the correct code and I went back to my previous erroneous post...
--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)

March 21, 2009 at 9:36 am

#963982
RE: T-Sql rant

Lynn Pettis (3/20/2009)
Jeff Moden (3/20/2009)
If you did it your way, which numbers would be reserved if you needed 100 numbers as the increment?
You know, I was looking at it from...
--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)

March 21, 2009 at 9:21 am

#963974
RE: Being More Productive

Heh... I agree... all of the technology is fasinating. But the thing that increases my productivity the most is... downtime. Even the hour long drive to work is...
--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)

March 20, 2009 at 9:16 pm

#963908
RE: Buils a select statement from another select statement

cmaciasg (3/19/2009)
Only a more questions, for maintenance issues.
How could manage all that stuff dinamically? That is, If the columns aren´t 3, but many of them, col1, col2, col3, ...., coln....
--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)

March 20, 2009 at 9:05 pm

#963906
RE: serial no

Then the query I included with my post should do it.
--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)

March 20, 2009 at 9:02 pm

#963905
RE: Isues with Identity columns? Char as primary key

Florian Reischl (3/19/2009)
I've begun a new project and my predecessor used a char(10) field as the primary key in all tables. The key is generated by using the last 10...
--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)

March 20, 2009 at 8:54 pm

#963904
RE: query

My answer would be that the DBA chases you with a well equipped pork chop launcher until your heals smoke because you selected too much 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)

March 20, 2009 at 8:45 pm

#963903

Viewing 15 posts - 44,506 through 44,520 (of 59,101 total)