Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,246 through 43,260 (of 59,102 total)

RE: Enable sp_MakeWebTask in 2k5

{edit} I still need some help on this because the following didn't work. Please see the 3rd post on this thread. Thanks, folks.
Aw shoot... I guess I'm going...
--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)

June 26, 2009 at 12:27 pm

#1016234
RE: Are the posted questions getting worse?

Jack Corbett (6/26/2009)
Here's a legitimate and, in my opinion, interesting question about indexes and included columns. I've tried to help but don't know enough to answer the real question....
--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)

June 26, 2009 at 10:25 am

#1016175
RE: Are the posted questions getting worse?

Lynn Pettis (6/26/2009)
I'll have to wait a bit before replying directly as all I can come up with are snide comments about having to earn the right to be funny...
--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)

June 26, 2009 at 10:20 am

#1016171
RE: Are the posted questions getting worse?

Florian Reischl (6/26/2009)
Noticed the answer and don't really believe it. However - from my side - sometimes saying nothing says all.
I absolutely agree... I hate feeding trolls whether they're malicious...
--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)

June 26, 2009 at 10:18 am

#1016169
RE: printing 1 to 100 in SQL Server as a batch....

Sinshith S Anand (6/26/2009)
Hi friends,
I am really happy to see Lots of ideas....You can visit my blog also
http://sinshith.wordpress.com/
And let me know your comments...I started writing blog recently
I'd recommend...
--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)

June 26, 2009 at 10:08 am

#1016163
RE: Are the posted questions getting worse?

Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.
I hope (s)he did. Next posts have been really okay.
Heh... I'm not...
--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)

June 26, 2009 at 9:51 am

#1016144
RE: printing 1 to 100 in SQL Server as a batch....

Sinshith S Anand (6/25/2009)
Still many methods are there.....Please contribute your ideas
Ummmmm... WHY? You writing a book or what?
See ya...
--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)

June 26, 2009 at 6:24 am

#1015957
RE: Slack SQL Server

Heh... not to worry, Tom. We've all gotten versions and products confused at one time or another. Thanks for the feedback.
The underlying problem still remains though - cross...
--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)

June 26, 2009 at 6:17 am

#1015950
RE: Are the posted questions getting worse?

Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.
I hope (s)he did. Next posts have been really okay.
Heh... I'm not sure where the link...
--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)

June 26, 2009 at 6:11 am

#1015944
RE: User-defined function not recognized

Let's see if it actually made it from one server to another. What do you get when you run the following?
SELECT *
FROM sys.Objects
WHERE Name = 'fn_Split'
If the answer...
--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)

June 25, 2009 at 3:01 pm

#1015640
RE: Split string using XML

jo stovall (6/25/2009)
We are converting SS2000 DTS packages to SSIS 2005.
I need help using a User Defined Function within a query on a table.
The function performs correctly.
select * from...
--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)

June 25, 2009 at 1:17 pm

#1015568
RE: Split string using XML

Senthilnathan.Karunakaran (6/25/2009)
We did performance and scaling test to split the comma separated string value using XML query and SQL function.
The plan was better with XML split than SQL function; however...
--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)

June 25, 2009 at 12:37 pm

#1015545
RE: printing 1 to 100 in SQL Server as a batch....

Sinshith S Anand (6/23/2009)
Please contribute ur ideas...I have got only one correct answer....
Heh... the correct answer is "Anything that doesn't resort to RBAR or hidden RBAR."
--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)

June 24, 2009 at 8:25 am

#1014682
RE: Converting non-clustered index to clustered index

Eswin (6/23/2009)
Since there is already a non-clustered index for the primary key constraint on emp_id i need to convert this non-clustered index "PK__Employees__1D4655FB" to a clustered index.
CREATE UNIQUE CLUSTERED
...
--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)

June 24, 2009 at 5:59 am

#1014564
RE: Converting non-clustered index to clustered index

When you specify the PK for a table, unless you explicitly ask for a non-clustered PK, it will automatically create a clustered index on the PK.
--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)

June 24, 2009 at 1:12 am

#1014465

Viewing 15 posts - 43,246 through 43,260 (of 59,102 total)