Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,561 through 40,575 (of 59,072 total)

RE: enable/disable xp_cmdshell before/after Windows schedule task

calico-604598 (12/20/2009)
Hi,
With SQL Server 2005 Expresse Edition CMDSHELL can be enable / disable with sp_configure or with surface area.
I ask this question because I dont want to manually enable...
--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)

December 21, 2009 at 8:01 am

#1094779
RE: Mean, Median, Mode

Thanks, Daipayan,
Just wanted to make sure you were covered on this. Lot's of folks simply do it wrong and they end up with a huge performance problem on their...
--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)

December 21, 2009 at 7:58 am

#1094777
RE: Exporting to Excel Using a CLR Stored Procedure

SQL Server is running the CLR... SQL Server must be runing as a user that has the privs to "see" the UNC.
--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)

December 21, 2009 at 7:55 am

#1094776
RE: trimming trailing spaces and zeros from a string

Heh... got it and thanks for taking the time to explain.
Depending on how you're pushing that to Excel, it's likely that the trailing 0's just won't matter... Excel...
--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)

December 21, 2009 at 7:53 am

#1094773
RE: Mean, Median, Mode

Just curious... did either of those links help you sort your problem out?
--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)

December 20, 2009 at 6:32 pm

#1094562
RE: How to split the value

shuzi,
Did you ever get this sorted out or do you still need some help?
--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)

December 20, 2009 at 6:30 pm

#1094561
RE: How to access a current row particular column value

You bet. Thank you for the feedback.:-)
--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)

December 20, 2009 at 6:18 pm

#1094558
RE: New to SQL

My recommendation would be to read the following article before you do anything...
http://www.sqlservercentral.com/articles/DBA/68526/
--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)

December 20, 2009 at 4:18 pm

#1094545
RE: How to access a current row particular column value

surya-434952 (12/20/2009)
Hi Jeff,
Thanks a ton for your kind help. Its working. Could you please explain a bit about quirky update So that i can reuse this when ever i...
--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)

December 20, 2009 at 11:40 am

#1094526
RE: enable/disable xp_cmdshell before/after Windows schedule task

Simple check in Books OnLine does it... 😉 Past the following into the URL box of the help system.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c147c9e1-b81d-49c8-b800-3019f4d86a13.htm
--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)

December 20, 2009 at 11:34 am

#1094524
RE: File Name

QQ-485619 (12/19/2009)
Can you please be more specific?
Thanks,
Yes, but then you'd miss out on all the fun. 😉 Did you lookup REVERSE in Books Online? Also lookup CHARINDEX which...
--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)

December 20, 2009 at 10:48 am

#1094519
RE: How to "Rebuild" all the indexes of all the tables in all the databases?

I'm not sure what's available in 2k8, but if you lookup DBCC SHOWCONTIG, there's a fully written script near the bottom of that help listing.
--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)

December 20, 2009 at 10:45 am

#1094518
RE: How to access a current row particular column value

surya-434952 (12/20/2009)
Hi Jeff,
Let me know explain the scenario clearly,
i have a table called balance sheet as follows
Dept Acct Date credit...
--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)

December 20, 2009 at 9:59 am

#1094514
RE: Looking for some fundamental help automating a query

If you don't know me by now, then let me tell you that I always have to ask "Are you sure?" when I see something like that. Same thoughts...
--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)

December 20, 2009 at 8:36 am

#1094510
RE: Dissecting SQL Server Execution Plans

Grant Fritchey (12/20/2009)
Hey Jeff,
Thanks for the great review and the kind words. "I'm not worthy" doesn't begin to cover it, but thanks for the sentiments.
Heh... Humility and knowledge will get...
--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)

December 20, 2009 at 8:27 am

#1094506

Viewing 15 posts - 40,561 through 40,575 (of 59,072 total)