Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,351 through 31,365 (of 59,101 total)

RE: Are the posted questions getting worse?

Chad Crawford (1/25/2012)
Evil Kraig F (1/24/2012)
Anyone else losing CR/LFs when they copy paste code off the site recently? I've had the problem in anything in a code="", plain...
--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)

January 25, 2012 at 6:37 pm

#1438526
RE: Are the posted questions getting worse?

Brandie Tarvin (1/25/2012)
Anyone can fly. You just throw yourself at the ground and miss.
BWWWAAAA-HAAAAAA-HAAAAA!!!! Now THAT's funny!!! Major T-Shirt material there, Brandie! 😀
--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)

January 25, 2012 at 6:35 pm

#1438524
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/25/2012)
SQL Kiwi (1/24/2012)
Steve Jones - SSC Editor (1/24/2012)
But you can ski?
I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to convince...
--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)

January 25, 2012 at 6:31 pm

#1438523
RE: whle loop in ssis?

Apologies for the distraction from "Charmer's" questions... I just want to say "thanks" to Craig and Matt for the feedback on my 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)

January 25, 2012 at 6:25 pm

#1438522
RE: Removing Commas in derived Column?

Agh... My apologies. The reason I didn't offer up any code is because it would appear that Francesc has sussed this problem and I meant to say so.
--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)

January 25, 2012 at 6:19 pm

#1438521
RE: How to modify $pshome PowerShell 2.0 variable so that it points to a different directory

babatmanpub (1/25/2012)
Just for those who would like to change $pshome : you can do it here :
with regedit
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\PSConfigurationProviders\Microsoft.PowerShell]
"ApplicationBase"="c:\\Windows\\System32\\WindowsPowerShell\\v1.0"
Nicely done.
Shifting gears a bit (and no implications about the code...
--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)

January 25, 2012 at 6:17 pm

#1438519
RE: Table-valued UDF on one database selects data from another database on the same SQL instance - how to make this work without assigning explicit user permissions on db_2?

Hmmm... I haven't tried it but I wonder if using a synonyn for the remote table would work in this case.
Also, is the function being used alone? (Probably 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)

January 25, 2012 at 6:08 pm

#1438517
RE: Notify Operator Task - Unable to set "Notification Message Subject"

You know... that's probably the only thing I haven't tried. I'll give it a whirl when I get back to work tomorrow. Thanks, Brandie.
--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)

January 25, 2012 at 6:03 pm

#1438515
RE: Notify Operator Task - Unable to set "Notification Message Subject"

I've not been able to find a solution for this other than someone saying that the problem doesn't occur if you use the deprecated SysMail. I guess the work...
--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)

January 25, 2012 at 6:23 am

#1438199
RE: Removing Commas in derived Column?

phil.walter 85406 (1/24/2012)
simply REPLACE([FIELD NAME],',','')
It won't work for the third example the OP gave where the comma between two items must be preserved.
--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)

January 25, 2012 at 6:16 am

#1438189
RE: Database design question

SQLKnowItAll (1/23/2012)
SQLKicksButt (1/23/2012)
Jared, you are correct that there could be different implications for adding a new appliance versus just updating. I would say adding a new appliance is a rare...
--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)

January 23, 2012 at 7:43 pm

#1437450
RE: Better Backups

KWymore (1/23/2012)
Good question. Made me look up BOL as I had never thought to use Resource Governor that way.
BWAA-HAAA!!! The only "Resource Governor" that I use is denial of...
--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)

January 23, 2012 at 7:30 pm

#1437448
RE: whle loop in ssis?

I have to ask... is a FOREACH loop in SSIS going to be as effecient as creating a result set in a stored procedure that uses FOR XML PATH() and...
--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)

January 23, 2012 at 7:20 pm

#1437447
RE: Table-valued UDF on one database selects data from another database on the same SQL instance - how to make this work without assigning explicit user permissions on db_2?

SQLKnowItAll (1/23/2012)
Is EXECUTE AS not an option?
http://msdn.microsoft.com/en-us/library/ms188354.aspx
It might not be an option if you've written a nice, high performance, inline Table Valued Function.
--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)

January 23, 2012 at 7:17 pm

#1437446
RE: Removing Commas in derived Column?

Charmer (1/23/2012)
Hi Friends,
i have a column having some records like ",Clayton" and "Township," and "Clayton, Dept" ...
i want to remove unnecessary commas which is presented in...
--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)

January 23, 2012 at 6:41 am

#1437055

Viewing 15 posts - 31,351 through 31,365 (of 59,101 total)