Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,671 through 47,685 (of 59,099 total)

RE: user tables and data types

tjm (10/20/2008)
Yes. I can see the max_length, but not data_types? Any suggestions?
SELECT * FROM Information_Schema.Columns
--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)

October 20, 2008 at 8:07 pm

#887398
RE: Query Analyzer sends 'Results to File'

Nikhil Shikarkhane (10/20/2008)
I dont know what are you using the file for but you can also use sp_send_dbmail to query output into a flatfile
and have it comma separated cause using...
--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)

October 20, 2008 at 7:26 pm

#887392
RE: SQL Server 2000

Nicely done, Greg. And, if you want the date/time to change no matter which column is updated, just remove the IF...
CREATE TRIGGER tr_your_trigger_name
ON [YourTable]
FOR INSERT,UPDATE
AS
IF @@ROWCOUNT = 0 RETURN
...
--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)

October 20, 2008 at 7:11 pm

#887390
RE: Extreme long UPDATE action, advice needed.

FreeHansje (10/20/2008)
I'm not sure how many actual updates have been done, since I get an update result for each individual update; a guestimate makes me believe there are about 13000...
--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)

October 20, 2008 at 7:04 pm

#887389
RE: The Financial Crisis

Heh... I'm not a religious man, but what ever happened to following the original 10 laws? They're well written and cover, quite literally, a wealth of sins. 😉
--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)

October 20, 2008 at 7:01 pm

#887388
RE: Clustered index seek is ver very slow

I'd seriously consider doing some DB and disk maintenance... I don't let the Scan Density get below 90% before I do a rebuild, especially if the clustered index isn't chronological...
--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)

October 20, 2008 at 6:55 pm

#887386
RE: Query Analyzer sends 'Results to File'

If you have the file open with something when you try to do the run, you will get an error like you did.
--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)

October 20, 2008 at 6:45 pm

#887384
RE: Who Wants to Be Rich?

Steve Jones - Editor (10/20/2008)
Interesting comments, and no complaints, Jeff. Just wondering. Usually I get a good diatribe if I've stoked your interest.
Heh... which definition of "diatribe" do you mean...
--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)

October 20, 2008 at 6:44 pm

#887383
RE: Test-Driven Development of T-SQL Code

I agree with the problems that the folks in the posts above have cited. Further, there is an absolutely glaring problem with this method (no fault of the author)...
"refactor...
--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)

October 20, 2008 at 5:46 am

#887062
RE: Who Wants to Be Rich?

Steve Jones - Editor (10/19/2008)
That's it? I wear you two out on the Financial Crisis poll 🙂
Heh... the one time I agree with anybody 100% and you ask if "That's...
--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)

October 20, 2008 at 5:13 am

#887059
RE: Help Needed with TSQL

Prakash.Padmanabha (10/19/2008)
Hi,
I am recently into SQL Server programming and assuming we need a single row for each line, I have written this query which is giving the results 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)

October 19, 2008 at 10:23 am

#886881
RE: Who Wants to Be Rich?

Exactly... 😉
--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)

October 18, 2008 at 6:49 pm

#886825
RE: The Financial Crisis

Heh... I pretty much agree with what Loner said. I'll go a step further... although I feel bad for some of the "Joe Bag-o-Donuts" guys that lost a good...
--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)

October 18, 2008 at 6:28 pm

#886823
RE: Pass array/csv into stored proc and doing LIKE statements

You bet... thank you for the feedback. Let us know if you have any additional problems with this... 🙂
--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)

October 18, 2008 at 6:05 pm

#886822
RE: Cursor

senthil_gobi04,
Just to add to the concensus forming here, about the only thing you really need to know about cursors is how to stay away from them. Even a nice...
--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)

October 18, 2008 at 6:01 pm

#886821

Viewing 15 posts - 47,671 through 47,685 (of 59,099 total)