Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,866 through 20,880 (of 59,098 total)

RE: execute xp_cmdshell - cant get it to work - no matter what - any one?

Lynn Hendricks (5/5/2015)
I've tried every possible solution found on the web to get xp_cmdshell working from within a stored proc, called from within an application. The current_user when the stored...
--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)

May 5, 2015 at 9:03 pm

#1795804
RE: EXEC master..xp_cmdshell wont send to URL

I'd be real careful about having a share on my SQL SERVER that has been given privs to EVERYONE. In fact, I don't generally allow any shares on my...
--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)

May 5, 2015 at 5:59 pm

#1795791
RE: t-sql 2012 return number with 2 leading zeroes

Ohhhhh, be REAL careful about using STR for formatting. Its slow and can be the source of rounding problems that you might not expect.
http://www.sqlservercentral.com/articles/T-SQL/71565/
I'll also state that, unless you're...
--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)

May 5, 2015 at 5:52 pm

#1795788
RE: Get Fiscal Week Number

andyscott (5/5/2015)
Why have ISO when you can have Her Majesty's Revenue and Customs! 🙂 🙂 🙂
http://www.taxadvisorypartnership.com/tax-compliance/why-does-the-uk-tax-year-start-on-6-april-each-year/
Owwww!!!! So THAT's where that date comes 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)

May 5, 2015 at 10:51 am

#1795689
RE: EXEC master..xp_cmdshell wont send to URL

456789psw (5/5/2015)
Any ideas?
#1 works, #2 dont. Just to make sure it was not a rights issue, I added everyone to the folder for #2 but no luck.
1. EXEC master..xp_cmdshell'bcp "SELECT...
--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)

May 5, 2015 at 10:41 am

#1795685
RE: Get Fiscal Week Number

Now we know why the ISO Week was born. Removes a whole lot of all this guessing.
--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)

May 5, 2015 at 8:15 am

#1795624
RE: Reducing Index Fragmentaion during Inserts

RonKyle (5/5/2015)
Just a really simple idea.
Try setting PAD_INDEX = ON and FILLFACTOR = 80 as an initial step.
I recently did something like this in a situation you describe and it...
--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)

May 5, 2015 at 8:13 am

#1795623
RE: Server Logins

Orlando Colamatteo (5/5/2015)
Jeff Moden (5/4/2015)
I don't understand why anyone would need to do this through PowerShell. Can someone who actually had such a need please explain? I'm looking...
--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)

May 5, 2015 at 6:54 am

#1795571
RE: Server Logins

I don't understand why anyone would need to do this through PowerShell. Can someone who actually had such a need please explain? I'm looking for someone that actually...
--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)

May 4, 2015 at 11:56 am

#1795429
RE: To get the average of two largest number amount three column for particular identity.

Excellent. 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)

May 4, 2015 at 10:39 am

#1795421
RE: Are the posted questions getting worse?

There's also no excuse for people breaking out their "I've got 20 years of experience" rings. which looks like might have been the start of it all. Doesn't matter...
--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)

May 4, 2015 at 9:41 am

#1795396
RE: Are the posted questions getting worse?

Lynn Pettis (5/4/2015)
Jeff Moden (5/4/2015)
Jack Corbett (5/4/2015)
And for back to back posts to the thread. I really can't stand it when an OP says something like:
Please 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)

May 4, 2015 at 9:20 am

#1795383
RE: Can't Kill SPID

Jpotucek (5/4/2015)
I have a SQL Server 2000 Database. 30+ GB with a 15+GB log file.
I attempted to backup the Database and I receive the following error:
Server: Msg...
--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)

May 4, 2015 at 8:51 am

#1795370
RE: Running Balance Updation

vikramchander90 (5/4/2015)
Hi Jeff,
Sorry for late reply and thanks a lot for your reply. Your solution worked out perfectly which helped reduce from hours to seconds. Thanks a lot.
Outstanding. ...
--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)

May 4, 2015 at 8:47 am

#1795368
RE: Are the posted questions getting worse?

Jack Corbett (5/4/2015)
And for back to back posts to the thread. I really can't stand it when an OP says something like:
Please help me fix this poorly...
--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)

May 4, 2015 at 8:38 am

#1795365

Viewing 15 posts - 20,866 through 20,880 (of 59,098 total)