Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,001 through 54,015 (of 59,098 total)

RE: Jobs in Sqlservercentral.com

karthikeyan (11/22/2007)
if nobody working for this site ,then how the databases are maintained ?
Really i dont know can you tell me how does this site is running ? Atleast they...
--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)

November 23, 2007 at 4:13 pm

#753709
RE: Fun with datetime

So long as they don't change it to decimal math... that would just slow it down 😀
--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)

November 23, 2007 at 4:08 pm

#753708
RE: drop constraint fails

Is this the constraint that you cannot delete?
if exists (select * from dbo.sysobjects where name = 'FK_tdta_ebMatrix_tkey_eBaum')
ALTER TABLE [dbo].[tdta_EntscheidungsbaumMatrix] DROP CONSTRAINT FK_tdta_ebMatrix_tkey_eBaum
GO
If so, what happens when you manually run the...
--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)

November 23, 2007 at 4:06 pm

#753707
RE: Pattern Matching

Roger that... fix is simple... same code except where highlighted... will take care of up to 16 spaces between elements...
SELECT s.RowID,
Type...
--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)

November 23, 2007 at 3:44 pm

#753706
RE: What is mean by Programming styles?

Heh... I'd normally agree, but I can't buy that one in this case, Brian. Unless the company puts crack in the coffee machines, they're not going to give the...
--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)

November 23, 2007 at 3:33 pm

#753705
RE: Why upgrade from SQL 2000 to SQL 2005?

Heh... that's better... thanks, Brian.
--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)

November 23, 2007 at 3:26 pm

#753704
RE: BCP from Non SQL Servers

Brian is correct...
Yes... you can copy and register just the two BCP files. But, it's against the law and it breaks the licensing agreement. Microsoft does NOT...
--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)

November 23, 2007 at 12:04 pm

#753691
RE: Why upgrade from SQL 2000 to SQL 2005?

Maybe the new security features for parts of the server that point to the outside world and the fact that MS won't support 2k soon are worth it... but most...
--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)

November 23, 2007 at 11:59 am

#753689
RE: Insert row by row

Sure, you can use a cursor or while loop to perform such a feat...
But that also means you're doing one of the worst things possible in any RDBMS... you're programming...
--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)

November 23, 2007 at 11:48 am

#753688
RE: Update only changed rows, Insert only new rows

Do you have any triggers on the target tables? It's important...
--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)

November 23, 2007 at 11:43 am

#753687
RE: Pattern Matching

There were no spaces in your original sample data. If that continues to be a problem, let me know... the fix is simple...
--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)

November 23, 2007 at 11:36 am

#753686
RE: Manipulating a String

The code I posted extracts all three fields even for the "01" records...
You didn't even try the code, did 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)

November 23, 2007 at 11:12 am

#753684
RE: Pattern Matching

Why are you still fighting this problem, Ray? I gave you an answer and code that resolves all of these problems last night...
http://www.sqlservercentral.com/Forums/Topic425054-149-1.aspx#bm425122
--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)

November 23, 2007 at 11:10 am

#753683
RE: What is mean by Programming styles?

Heh... good point, Brian. And, (I forget who said it) sometimes you must unlearn what you have learnt in order to find and fix a problem.
But, I believe the...
--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)

November 23, 2007 at 11:05 am

#753681
RE: How to improve our written skill ?

Heh... and there's another good example... words like "spelt" and "learnt" may be good and proper words in "European English"... it the U.S.A., they are more correctly written and pronounced...
--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)

November 23, 2007 at 4:59 am

#753600

Viewing 15 posts - 54,001 through 54,015 (of 59,098 total)