Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,426 through 49,440 (of 59,091 total)

RE: what would be the maximum seed value for a bigint column in a table in SQL Server 2000

dakshinamurthy (7/5/2008)
I would also helpfull if i get to know what to do if we exceed the seed value for a bigint field in a table
If you exceed the maximum...
--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)

July 5, 2008 at 1:04 pm

#838542
RE: DateTime to Date only....

BitBucket... I like your signature line... I think everyone should have that line in 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)

July 5, 2008 at 12:58 pm

#838541
RE: obtain data from 2 weekdays?

Ooooohhh! Be real careful... unless all of your dates have a midnight time, the following will miss all but the first millisecond of the date carried by @friday...
select *...
--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)

July 5, 2008 at 12:27 pm

#838540
RE: CLR - Stored Procedure Lock

Of course, the real question is...
What have you written a CLR for that you think can't be done in T-SQL?
Seriously... several of us have had several major "races"...
--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)

July 5, 2008 at 9:41 am

#838512
RE: DateTime to Date only....

Looks like Carl beat me to the notation about formatting being done on the client side...
Carl... no, I don't have the link that you're asking about... sorry.
--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)

July 5, 2008 at 9:37 am

#838511
RE: DateTime to Date only....

b_boy...
Along with what Mouse suggested, lookup CONVERT in Books Online to find all of the built-in date patterns. It's worth the read.
As a side bar, if there's a GUI...
--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)

July 5, 2008 at 9:36 am

#838510
RE: DateTime to Date only....

Carl Federl (7/5/2008)
There was a very long forum post on various methods to get only the date portion from a datetime datatype. One of the most efficient was 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)

July 5, 2008 at 9:28 am

#838507
RE: Spliting a string

Talib Khan (7/5/2008)
Hey.. Thanks everyone for your valuable suggestions as i have already solved my problem. But...
--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)

July 5, 2008 at 9:09 am

#838505
RE: ANSI_NULLS and Performance

In the meantime, why don't you just go ahead and tell us what the solution 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)

July 4, 2008 at 10:13 pm

#838466
RE: Raima Database Data Import

I don't believe there's anything in SQL Server that will import such a thing... does it have any export capabilities, say, to a CSV or fixed field text file?
--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)

July 4, 2008 at 10:08 pm

#838465
RE: Trigger Not Firing

The trigger fires just fine... the UPDATE is the problem... or rather the data, data order, and criteria for the update is the problem... This never qualifies with 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)

July 4, 2008 at 9:46 pm

#838464
RE: Avoid Stored proc Fire triggers

Actually.... I want to see both the trigger and the proc... it would also be nice if you'd post the Create statements for the table being deleted from and any...
--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)

July 4, 2008 at 9:14 pm

#838462
RE: Randomly Pick Specified Number of Rows?

ywb (7/4/2008)
It does. Thanks!
Two way street... I'm always curious about these type of things...
Why do you need to do this, 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)

July 4, 2008 at 9:09 pm

#838460
RE: www.sqlservercentral.com

The OP "left the building" 2 months ago...
--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)

July 4, 2008 at 9:08 pm

#838459
RE: Raima Database Data Import

What is a "Raima" database? Never heard that one before...
--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)

July 4, 2008 at 9:07 pm

#838458

Viewing 15 posts - 49,426 through 49,440 (of 59,091 total)