Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,196 through 39,210 (of 59,072 total)

RE: The Missing Certification

Gift Peddie (3/26/2010)
There are a lot of technical experts even in this site who will not pass the MCM because of their differences with Microsoft implementation.
I would definitely be one...
--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 26, 2010 at 7:52 pm

#1140860
RE: Are the posted questions getting worse?

Lynn Pettis (3/26/2010)
I know enough about basketball to teach kids to dribble, pass, and shoot. Tactics, maybe man-to-man defense at a limited level.
BWAA-HAAA!!! I'm getting old so all...
--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 26, 2010 at 7:43 pm

#1140858
RE: Are the posted questions getting worse?

Negative + chip on shoulder = bad combination.
--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 25, 2010 at 9:38 am

#1139741
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

doug.bass (3/24/2010)
Just wanted to say: excellent, well-written article. Kudos.
Always a pleasure to get that kind of feedback. Thanks Doug.
--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 24, 2010 at 4:49 pm

#1139301
RE: Are the posted questions getting worse?

Guess that settles it... Barry is back and feelin' fine! 😛
--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 23, 2010 at 8:39 pm

#1138672
RE: Does a development DBA need to learn dot.net language. ?

Heh... self inflicted pork chops are the worst punishment there 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)

March 23, 2010 at 8:11 pm

#1138659
RE: How to transform table with few rows to one row?

Jagger-784276 (3/23/2010)
How to group by If I don't have sum or count?
Use MAX instead.
--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 23, 2010 at 8:06 pm

#1138658
RE: Debug a stroed proc

It would appear that your test server is a wee bit behind in the service pack department. My redcommendtion would be to bring it up to speed and try...
--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 23, 2010 at 7:59 pm

#1138656
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Perry Whittle (3/22/2010)
Jeff Moden (3/22/2010)
It's a real shame that we have to try to rewrite that which works so well...
[font="Arial Black"]Dir c:\*.* /s /b[/font]
Good old DOS Jeff, you can't beat...
--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 23, 2010 at 6:01 am

#1138119
RE: Are the posted questions getting worse?

Gianluca Sartori (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
A consulting company here installed a SQL clustered Server with two nodes and they...
--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 22, 2010 at 4:10 pm

#1137909
RE: On the Trail of the ISO Week

Lookup CREATE FUNCTION in Books Online... Example "A" is a nice, short function that determines ISO week. It could probably be optimized to be an INLINE function for performance...
--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 22, 2010 at 11:28 am

#1137708
RE: DateTime input with time always at 00:00:00.0000

Heh... Paul won't like the zero notation but, yes, that general form is the most effective because it's the second fastest method and, unlike the fastest method, is upwardly mobile...
--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 22, 2010 at 11:17 am

#1137702
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

It's a real shame that we have to try to rewrite that which works so well...
[font="Arial Black"]Dir c:\*.* /s /b[/font]
--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 22, 2010 at 11:09 am

#1137697
RE: Getting date + Filter it !!! how ???

karthikeyan-444867 (3/22/2010)
Hi All,
I have a scenario.
I have table like
create table dt
(
dt datetime
)
select * from dt
insert into dt
select '01/jan/2010'
union
select '03/jan/2010'
union
select '04/jan/2010'
union
select '31/jan/2010'
union
select '01/feb/2010'
union
select '03/feb/2010'
union
select '04/feb/2010'
union
select '28/feb/2010'
I would like to filter...
--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 22, 2010 at 7:31 am

#1137588
RE: What is the life time of temporary table?

chandrasekaran.ganapathy (3/22/2010)
When it will be deleted automatically?
Gosh... haven't you stopped to read any of the responses or visit any of the web sites that BitBucket posted?
--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 22, 2010 at 7:27 am

#1137586

Viewing 15 posts - 39,196 through 39,210 (of 59,072 total)