Viewing 15 posts - 18,031 through 18,045 (of 59,069 total)
ZZartin (3/21/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 1:10 pm
GeorgeCopeland (3/21/2016)
Could not agree more. I am much more interested in how you think and how you work than whether you know all of the parms on a raiserror statement.
Cool....
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 11:04 am
vigneshlagoons 51204 (3/21/2016)
got it!reverse(right(reverse(app), len(app) - charindex('-',reverse(app),1)))
That uses 3 reverses and that's expensive. I'll try to get back to this tonight.
Personally, I wouldn't use any reverses for this.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 10:33 am
The execution plan shows at least two Cartesian products probably because of insufficient criteria. You can see these areas in the execution plan quite easily... they're the ones with...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 10:26 am
ZZartin (3/21/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 10:01 am
GeorgeCopeland (3/21/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 9:52 am
Whether it does or not, the drop still happened. Apparently BI didn't help them.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 1:37 am
aaron.reese (3/9/2016)
It seems reasonable...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 21, 2016 at 1:25 am
Solomon Rutzky (3/16/2016)
Jeff Moden (3/16/2016)
Solomon Rutzky (3/16/2016)
Given the nature of the operation, it is most likely to be serial / sequential...
True enough but get Microsoft to post the guarantee of...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2016 at 9:40 am
spaghettidba (3/17/2016)
What I ended up doing is moving...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2016 at 9:37 am
TheRedneckDBA (3/19/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 20, 2016 at 8:06 am
mburbea (3/19/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2016 at 8:32 pm
quagmired (3/19/2016)
Jeff Moden (3/19/2016)
I'm a big fan of using the right tool to the job (even when others don't think it's the right tool). With that in mind, what...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2016 at 8:11 pm
tarr94 (3/18/2016)
Thanks for the response! I marked it as the correct solution because I know I've seen SSIS used for this purpose, but I actually ended up dumping the...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2016 at 1:11 pm
Mac1986 (3/18/2016)
foreach ($line in $ReturnString)
{
$array = @()
if ($line -notmatch "ID,...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2016 at 12:55 pm
Viewing 15 posts - 18,031 through 18,045 (of 59,069 total)