Viewing 15 posts - 54,661 through 54,675 (of 59,067 total)
Sorry... that just doesn't help me... all of your examples show only one date... would you please do as I ask so I can help? Please change the following...
October 9, 2007 at 9:02 am
To add to that... are there Primary Keys on these tables? Is there a clustered index? Are the tables in a constant state of flux do to inserts,...
October 9, 2007 at 8:28 am
If it's the "Estimated" Execution Plan... pay those percentages no mind... it "lies" because it will frequently miss things. For example, only the first pass of a triangular join...
October 9, 2007 at 8:16 am
Heh... thanks for the "apple" 😛
October 9, 2007 at 7:42 am
Dunno about your first question but I'm pretty sure that the answer to your second question of can you "view images in SQL Server" is an emphatic "NO".
October 9, 2007 at 7:39 am
Heh... flies haven't found it, yet... :hehe:
October 9, 2007 at 7:33 am
Thanks, but doesn't quite tell me what you want... not trying to be difficult here, either but "one picture is worth a thousand words"....;)
You listed this as an "input"...
Insert Into...
October 9, 2007 at 7:30 am
Yep... I agree with all of that... if it's for GUI code...
For batches, the proc will probably recompile anyway just because the data will have changed enough to need a...
October 9, 2007 at 7:24 am
A big key here is that David DIDN'T even use a function (although you could if it's for RBAR GUI code)... it splits a whole table's worth of information in...
October 9, 2007 at 7:16 am
Heh... I cheat like hell... load up one staging table with everything... delete the dupes with the "earliest" information... flip the pass-through-view to look at the new table... drink beer...
October 8, 2007 at 8:56 pm
Ramesh Lende (10/8/2007)
October 8, 2007 at 8:47 pm
Backups... if for nothing else, to clear log files that are getting big and growing.
October 8, 2007 at 8:44 pm
Most people recommend against it for many reasons... most of them are good, some are not... but you could put a view in the Master database and that would draw...
October 8, 2007 at 8:34 pm
nba (10/4/2007)
The problem now is not the trigger but why it was there and not documented.
Simple... database is not correctly locked down for changes. No one but DBA's should...
October 8, 2007 at 8:21 pm
Works fine for what you have... no primary key.
To help, I need to know what you expect the output of your first post to be...
October 8, 2007 at 7:58 pm
Viewing 15 posts - 54,661 through 54,675 (of 59,067 total)