Jeff Moden

Forum Replies Created

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

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
RE: updating CLR UDFs / Procedures strategy: contributions needed.

I'd have to ask what you're doing with CLR's that you think you can't do in T-SQL.
--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:43 pm

#963902
RE: How to write codes that display sub-colum names under main column header name

josephptran2002 (3/20/2009)
Please please please email me at josephptran2002@hotmail.com So I can explain to you on the regular mail.
Nah... keep it all here so we might all learn something, please.
--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:40 pm

#963900
RE: is possible thro a single query

ramu.valleti (3/20/2009)
what do you mean by "single query".?
You can use sub queries to achieve this.
Regards,
Ramu
Cool... let's see it, Ramu.
--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:36 pm

#963899
RE: how to break phone and exension data

Ok... again... here's the test data...
drop table #OriginalTable
go
SELECT '913.135.9000 x:6390' AS FullPhoneNumber
INTO #OriginalTable UNION ALL
SELECT '(305)529-6911x2101' UNION ALL
SELECT '(206)965-2626' UNION ALL
SELECT '109.391.3261' 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)

March 20, 2009 at 8:33 pm

#963898

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