Viewing 15 posts - 7,321 through 7,335 (of 13,469 total)
can you create a job today, pull from that view, and log the changes for 6 months or something?
at least you'd be able to answer better with some time...
June 24, 2011 at 1:26 pm
james.massey (6/24/2011)[hrCorrect me if I'm wrong (occurs entirely often), but that only tracks changes and does not pay attention to selects.
it has the last tiem an index had a SEEK...
June 24, 2011 at 1:14 pm
running profiler has a huge impact, but a server side trace has minimal impact;
I have a DML/Login trace, kind of like the default trace, keeping track of the last...
June 24, 2011 at 1:11 pm
james.massey (6/24/2011)
June 24, 2011 at 1:07 pm
if you do not have a trace already in place, you cannot identify who did it;
you can read the log with some third party tools, but the log only has...
June 24, 2011 at 1:01 pm
run this and see if it gets you the info you are looking for...
if a table has not been acccessed at all, it's not on the list; read the article...
June 24, 2011 at 12:55 pm
Garadin (6/24/2011)
I think he 'cheats' by having a big repository of all these code snippets right at hand!Yes I'm jealous =).
guilty as charged i've got an aweful lot of snippets...
June 24, 2011 at 12:38 pm
Sean Lange (6/24/2011)
Excellent. Thanks Lowell. Of course now I have no excuse not to work this afternoon. 😛
there's always work to do in the salt mines...i'm sure. I wanted you...
June 24, 2011 at 12:23 pm
fleshing out a rough example from Sean and Garadin:
--proof of concept:
--unlike your developers, do not do this work on production:
USE tempdb;
CREATE TABLE [dbo].[PERSON1](
...
June 24, 2011 at 12:17 pm
sure you can, but you have to tackle the test just a little differently;
also,you'll have to switch to dynamic SQL to do the ALTEr + UPDATE part.
how about this?:
DECLARE @tableName...
June 24, 2011 at 11:47 am
Ive definitely seen that error when my files were -slash-r terminiated and my script expected -slash-n;
especially since your error said it happened on line1 /column 18 of what we think...
June 24, 2011 at 9:55 am
your table has to exactly match the file you bulk insert...it cannot have more or less columns than the file you import;
i mentioned i had to add two columns, and...
June 24, 2011 at 9:22 am
Sean Lange (6/24/2011)
that is an odd requirement but you can achieve this with nested replace statements easily enough.
and nested replaces are really fast too;
here's an example, spread out for readability/unserstand-ability,...
June 24, 2011 at 9:07 am
bopeavy (6/24/2011)
Unfortunately I am under the constrant to give access from management to production(stupid) not a copy and the view thing won't work in this case.
wow....that's kind of what i...
June 24, 2011 at 8:31 am
only what i mentioned before...for example, rename [SFEDID] to [SFEDID_ORIG]
and then create a view named [SFEDID] that selects from the table, that masks that specific column.
you...
June 24, 2011 at 8:25 am
Viewing 15 posts - 7,321 through 7,335 (of 13,469 total)