Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,141 through 40,155 (of 59,072 total)

RE: Is there any justification for really using SQL CLR

Adam Machanic (1/22/2010)
Jeff Moden (1/21/2010)
Although I very much agree with most of that, the "Catch 22" there is that most T-SQL users don't know what a "complex computation" actually 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)

January 22, 2010 at 4:59 pm

#1107649
RE: Date Calculation

Yes, I know what you're looking for. If you take the time to post the data in a readily consumable format (like in the article I referred you to),...
--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)

January 22, 2010 at 12:17 am

#1107126
RE: Poor performance while using Union/Intersect on bulk data

Do you have indexes on the other two 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)

January 22, 2010 at 12:02 am

#1107122
RE: How Do You Handle the Stress of Being a DBA?

CirquedeSQLeil (1/21/2010)
A good hardy laugh is also very useful in keeping the stress at bay.
That's what I normally do although I have been known to accelerate a pork chop or...
--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)

January 21, 2010 at 11:58 pm

#1107121
RE: How to read list of files in folder using T-SQL?

Yes...
The first "1" controls how many "levels" to go down from the directory listed in quotes with the directory listed in the quotes being "Level 1". In other words,...
--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)

January 21, 2010 at 11:48 pm

#1107119
RE: passing out put of one sql statement into another as a input and looping using cursor

Heh... after two days, I wonder if it's still "urgent". :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)

January 21, 2010 at 11:43 pm

#1107117
RE: Split the month as weeks

KpSQL123 (1/21/2010)
Hi,
Can some one please let me know how to split the month as weeks. Let's take January has 6 months
1-2 as 1st week
3-9 as 2nd week
10-16 as 3rd week
17-23...
--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)

January 21, 2010 at 11:41 pm

#1107116
RE: select comma Separated values

Here are a couple of more suggestions along with some caveats to watch out for.
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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)

January 21, 2010 at 11:35 pm

#1107115
RE: Mishi Kobe Niku

What? No pork chops? :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)

January 21, 2010 at 11:27 pm

#1107114
RE: Update with rowcount

This is one of the very few places where I'd condone the use of a Trigger. Read about triggers in 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)

January 21, 2010 at 11:26 pm

#1107112
RE: Date Calculation

Anitha,
You're probably not getting the help you need just because of the way you posted the data. Take a look at the first link in my signature below to...
--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)

January 21, 2010 at 11:15 pm

#1107108
RE: Syntax Help PLEASE

I'm not sure that you need the ISNULL, Lowell... if "0" isn't a value in the table, NULL will give the same result as "0" because NULL isn't even equal...
--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)

January 21, 2010 at 11:12 pm

#1107107
RE: Need help using While

Sharul Nizam (1/21/2010)
My table and row as follow,
My hat's off to you, Sharul... you really made it easy for folks to help you with the way you posted. Well...
--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)

January 21, 2010 at 11:08 pm

#1107103
RE: Need help using While

lmu92 (1/21/2010)
Why not using a solution that doesn't use any while loops at all and do it all in one path?
Well done, Lutz!
--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)

January 21, 2010 at 11:06 pm

#1107102
RE: Mistake or #Fail

Excellent pod cast and excellent points. To coin a phrase, "Invest in yourself or people will invest in others." 🙂
--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)

January 21, 2010 at 10:56 pm

#1107099

Viewing 15 posts - 40,141 through 40,155 (of 59,072 total)