Viewing 15 posts - 301 through 315 (of 4,272 total)
Like the other posters it sure doesn't hurt to look, or you could take it as a learning opportunity. If you want to stick with the MS side and...
May 11, 2012 at 12:41 pm
I'm not surprised its possible.. But I absolutely wouldn't do it and wouldn't let any of my developers do it.
CEWII
May 11, 2012 at 12:36 pm
Honestly I'm not sure this is possible.
Even if it were I have to say I don't think its a good idea. Just create a table in the tempdb and...
May 11, 2012 at 11:20 am
I would not be surprised..
I had a case where in relation to auditing of some accounting type software what level of auditing they wanted. Management said, "everything". We...
May 10, 2012 at 4:29 pm
As far as what I meant was what they were actually doing. some peope do DRI in triggers as opposed to the DB.
Have they been doing re-indexes? Is...
May 10, 2012 at 3:34 pm
It could be. How many tables? What are the triggers used for?
50GB isn't big, but size of the DB is more than disk space.
CEWII
May 10, 2012 at 3:01 pm
If you are moving from 2008 to 2008 on a 32-bit to 64-bit server I have to say that unless you use custom SQLCLR, sp_OA, or extended stored procedures...
May 10, 2012 at 2:55 pm
I have never had this cause a failover, not saying it couldn't but never had it happen..
CEWII
May 10, 2012 at 1:48 pm
DTC will exist on all nodes, it CAN be clustered and then the DTC will be a resource withing the resource group that SQL exists in.
However, I have several A/A...
May 10, 2012 at 1:32 pm
Eric M Russell (5/10/2012)
Elliott Whitlow (5/10/2012)
Lynn Pettis (5/10/2012)
Anyone tuning the query by not looking at IO and Time statistics and query plan would immediately fail.
Guess I'd fail here. First...
May 10, 2012 at 1:28 pm
Lynn Pettis (5/10/2012)
Anyone tuning the query by not looking at IO and Time statistics and query plan would immediately fail.
Guess I'd fail here. First things I look at are...
May 10, 2012 at 12:06 pm
Lowell is correct that not all fields will be filled in even if they are included.
CEWII
May 10, 2012 at 9:21 am
Reading through your code you have picked and chosen what columns for each event you want to trace. I noticed that some of the fields you wanted were not...
May 10, 2012 at 8:55 am
To see what is being generated I would probably save the package out and then open it in bids and see what it is generating and see if it differs...
May 9, 2012 at 2:58 pm
Thomas Stringer (5/8/2012)
May 8, 2012 at 3:32 pm
Viewing 15 posts - 301 through 315 (of 4,272 total)