Viewing 15 posts - 46 through 60 (of 151 total)
SQL Kiwi (8/24/2012)
Usman Butt (8/24/2012)
SQL Kiwi (8/23/2012)
ChrisM@Work (8/23/2012)
UNION ALL SELECT NULL -- eliminated by CROSS APPLYThe NULL is not eliminated by the CROSS APPLY.
I will second that CROSS...
August 24, 2012 at 3:24 am
SQL Kiwi (8/23/2012)
ChrisM@Work (8/23/2012)
UNION ALL SELECT NULL -- eliminated by CROSS APPLYThe NULL is not eliminated by the CROSS APPLY.
I will second that CROSS APPLY will eliminate the...
August 24, 2012 at 1:44 am
SQL Kiwi (8/23/2012)
mburbea (8/22/2012)
August 24, 2012 at 1:28 am
ChrisM@Work (8/23/2012)
mtassin (8/23/2012)
I'm not seeing the XML trouncing the Delimittedsplit8k tvf though.....
Nor me. I've plugged it into the splitter test harness from the article attachent and on some permutations of...
August 23, 2012 at 10:12 am
Lynn Pettis (8/23/2012)
ChrisM@Work (8/23/2012)
mtassin (8/23/2012)
I'm not seeing the XML trouncing the Delimittedsplit8k tvf though.....
Nor me. I've plugged it into the splitter test harness from the article attachent and on some...
August 23, 2012 at 9:57 am
SpringTownDBA (8/10/2012)
The difference in performance is due to either different plans, or blocking.Can you capture actual query plans from both the slow and fast executions?
I will second the two different...
August 10, 2012 at 11:57 am
ricklivesey (8/10/2012)
Thanks for your reply.
We stripped the SQL Job so that it only contained the disable and re-enable trigger SQL commands and the problem still remained and therefore we've...
August 10, 2012 at 6:34 am
If I ask myself when I would disable update trigger? The first thing comes to mind is when I have to do some heavy data changes or a thing like...
August 10, 2012 at 5:30 am
derek.colley (8/10/2012)
Usman Butt (8/10/2012)
I forgot that the same could be handled with DDL (LOGON) trigger as well 😉
Definitely not - the problem with FOR LOGON triggers is that if something...
August 10, 2012 at 3:42 am
I forgot that the same could be handled with DDL (LOGON) trigger as well 😉
August 10, 2012 at 1:49 am
derek.colley (8/10/2012)
-- this sets up the table
CREATE TABLE loginAudit ( login_name VARCHAR(MAX), last_login_date DATETIME )
INSERT...
August 10, 2012 at 1:48 am
rajawat.niranjan (8/9/2012)
I can Use IF/Else but there i'll have to use too many iterations,
Because @Country and @province may contain more that one value.
and each table City, Region, Country and Province...
August 10, 2012 at 1:24 am
Without some sort of auditing process it is not possible. SQLAudit is the best way to do it if you want to meet regulatory compliance requirements. Otherwise, you also have...
August 10, 2012 at 1:02 am
Beware that is a bit tricky policy. According to the business requirement you need to handle the case when a trigger is defined both for INSERT and UPDATE simultaneously.
August 9, 2012 at 6:18 am
Jeff Moden (8/7/2012)
Seriously, though. You did a really nice job. Thanks for joining this discussion.
The pleasure is always mine 😎 It is a great honor to receive such...
August 7, 2012 at 11:48 pm
Viewing 15 posts - 46 through 60 (of 151 total)