Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,616 through 51,630 (of 59,091 total)

RE: Select date columns value which are older than 10 days from today?

Heh... did I make ya blow coffee out your nose, Matt? 😛
--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 19, 2008 at 7:27 am

#791432
RE: Vardecimal

Heh... yeah... nothing like the "TimeStamp" data type here... isn't hind site wonderful? :hehe:
--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 19, 2008 at 7:25 am

#791431
RE: Vardecimal

Heh... Hence the name... varDECIMAL 😛
--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 19, 2008 at 7:07 am

#791422
RE: Basic Query Taking Too Long

No link required, actually... The term "Well formatted" should be common knowledge. But even if it's not, here's what your text attachments look like because you have no carriage...
--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 19, 2008 at 7:03 am

#791419
RE: Working with Stored Procedures in Sqlserver-2005

I also recommend you lookup CREATE PROCEDURE in Books Online and study it... there's a wealth of information about parameters and defaults for parameters there.
--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 19, 2008 at 6:32 am

#791402
RE: Record the SQL arriving at the server

Not sure, but I think "C2" auditing may do this... I've never used it so I don't know all of the details... check Books Online.
--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 19, 2008 at 6:29 am

#791401
RE: SQL Server File Query

I assume they already know this... but they need to do a "disk cleanup" and probably a defrag before they start manually selecting files for deletion.
--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 19, 2008 at 6:21 am

#791398
RE: Case statement in sql

Jeff Moden (3/19/2008)
Yes... lookup CASE, BREAK, and RETURN in Books Online (comes free with SQL Server)
On second thought... it looks more like you're trying to do control of flow... lookup...
--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 19, 2008 at 6:16 am

#791397
RE: Case statement in sql

Yes... lookup CASE, BREAK, and RETURN in Books Online (comes free with SQL Server)
--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 19, 2008 at 6:15 am

#791395
RE: Multiple after update triggers on same table

Start by removing the BEGIN TRAN/COMMIT statements. They serve no use here because you have no error detection.
Check your Java program... is it keeping a file open?
Get...
--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 19, 2008 at 6:09 am

#791392
RE: Create tables from flat file

Cross posted 5 times... if you answer, recommend you use the first URL below...
http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx
http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx
http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx
Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...
--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 19, 2008 at 5:59 am

#791390
RE: Create tables from flat file

Cross posted 5 times... if you answer, recommend you use the first URL below...
http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx
http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx
http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx
Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...
--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 19, 2008 at 5:59 am

#791389
RE: Create tables from flat file

Cross posted 5 times... if you answer, recommend you use the first URL below...
http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx
http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx
http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx
Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...
--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 19, 2008 at 5:58 am

#791388
RE: Create tables from flat file

Cross posted 5 times... if you answer, recommend you use the first URL below...
http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx
http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx
http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx
Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...
--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 19, 2008 at 5:58 am

#791387
RE: Create tables from flat file

Cross posted 5 times... if you answer, recommend you use the first URL below...
http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx
http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx
http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx
Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...
--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 19, 2008 at 5:58 am

#791385

Viewing 15 posts - 51,616 through 51,630 (of 59,091 total)