Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,631 through 51,645 (of 59,102 total)

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
RE: I got burned today at a SQL Server Interview!

Brandie Tarvin (3/19/2008)
Gotta laugh?? Says who?
Why... Larry TCG does... 😉
--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:40 am

#791379
RE: Syntax error converting datetime from character string.?

Man, you've got me... never saw such a thing.
But, riddle me this... why do you want the derived table when the query works fine without it?
select dt,datediff(dd,'2003-07-01',dt) as...
--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 18, 2008 at 11:15 pm

#791283
RE: Vardecimal

Man, do I ever understand that... there was this one thread that I had made about 7 posts on based on something I thought I knew... one of the guys...
--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 18, 2008 at 10:58 pm

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

By the way, you seem to haunt this site a lot.
Heh... can't dance and it's too wet to plow 🙂
Thanks for the awesome compliment, Lynn... lot's of good folks...
--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 18, 2008 at 10:50 pm

#791280

Viewing 15 posts - 51,631 through 51,645 (of 59,102 total)