Viewing 15 posts - 1 through 15 (of 95 total)
Sorry, I don't have a cool better way of solving this issue.
LOL. Not sure there's a cool way to solve it!
Regarding the developer AD group: Do you grant it those...
May 16, 2019 at 6:38 pm
Great article! I've implemented similar mechanisms and also solved the backup security problem (how to avoid granting backup/restore rights to developers) by polling a status table from a Server Agent...
May 16, 2019 at 3:46 pm
rchantler - Monday, December 10, 2018 2:12 PMSeparate logical or physical drives?
Not sure who you're asking, but I meant "logical". We use...
December 10, 2018 at 2:33 pm
Michael L John - Friday, December 7, 2018 11:16 AMI still create separate drives, only because it's easy to see things.
Agreed! With...
December 10, 2018 at 2:05 pm
May 30, 2017 at 11:09 am
I wrote a similar script and I used a wait loop to display encryption progress every 2 seconds. I found it helpful when encrypting large databases so I can tell...
May 25, 2017 at 2:23 pm
patrickmcginnis59 10839 (7/6/2015)
Again I am not sure why Oracle can make their PL/SQL using cursors as fast as set based operations and MS cannot. Cursors are not evil, and not...
July 7, 2015 at 11:34 am
You are correct. If you scroll up to Jeff's reply to Hugo you'll see he mentions that usage of cursors.
An alternative to granting select on the dbo schema could...
July 6, 2015 at 2:30 pm
fundpc (6/2/2015)
June 2, 2015 at 3:12 pm
@james Stephens
Got it! I agree with you. My apologies for the snide remarks, earlier. If an sp is run once a year and it loops through...
June 2, 2015 at 3:10 pm
James Stephens (6/1/2015)
I think you grossly misunderstood my point. I was not saying that all set based operations should be replaced by cursor-loops. My point could be distilled...
June 1, 2015 at 2:59 pm
Jeff Moden (6/1/2015)
June 1, 2015 at 9:57 am
Nakul Vachhrajani (9/16/2012)
March 24, 2015 at 10:40 am
@ Ron:
I go pretty far back with SQL server too, and would never have even considered using "while not exists" over a "left join" to retrieve orphans until I skeptically...
March 3, 2015 at 7:58 pm
Viewing 15 posts - 1 through 15 (of 95 total)