Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,226 through 39,240 (of 59,098 total)

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
RE: DateTime input with time always at 00:00:00.0000

john.campbell-1020429 (3/22/2010)
select cast(cast(getdate() as varchar(12)) as datetime)
gives
2010-03-22 00:00:00.000
John.
Like I said in my previous post above... that's a bad idea 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 7:23 am

#1137582
RE: what to call the daily reporting server?

Heh... and whatever you don't, don't put dashes in the name. Use underscores if you must but never dashes. (Well, unless you also have a great amount of love...
--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:22 am

#1137581
RE: Table Splitting

DBTeam (3/22/2010)
Hi All,
I have 28+ million table with 30 columns. Now we want to split into
multiple tables.
It having the information
like name info, address info , company info, employees,...
--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:16 am

#1137571
RE: where to learn 'advanced' querying

AndrewSQLDBA (3/22/2010)
I think the BOL tells all
I agree that it's a very good start but it won't teach you to think of things like how to use a Tally table...
--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:12 am

#1137568

Viewing 15 posts - 39,226 through 39,240 (of 59,098 total)