Viewing 15 posts - 56,491 through 56,505 (of 59,072 total)
Wait a minute! If you have a default on the column and you don't insert anything into it, then the column will have the default after an insert... why would...
May 1, 2007 at 3:35 pm
Like I said, that takes care of existing data... whatcha gonna do for new data that enters into the table?
May 1, 2007 at 3:31 pm
Evan,
You mentioned "PL/SQL"... as you know, the SQL extensions between Oracle and SQL Server are quite different. Are you looking for an Oracle (PL/SQL) solution or an SQL Server (T-SQL)...
May 1, 2007 at 7:14 am
What is the default value? That's what you have to put in the function. It can be a column name, another variable of the same or implicitly convertable type, or...
May 1, 2007 at 7:05 am
Peter's method is absolutely a great way to take care of existing data. The problem is, wadaya gonna do with new data?
If you really need to do such a thing,...
May 1, 2007 at 6:54 am
Lynn,
Too bad about that person. We've still got one like that, too. Dunno why they keep him around.
Say, that 3rd party app wouldn't happen to be a product called "Cost...
May 1, 2007 at 6:46 am
Spot-on on all points, Matt. And, thanks for the reminder... I forgot that such tools just short office politics right straight to ground.
May 1, 2007 at 5:49 am
2) Microsoft gave use the ability to force an index precicely because sometimes (granted VERY infrequently) it is... |
April 30, 2007 at 11:26 pm
Lynn,
Sorry, got a bit distracted... I think your co-worker is spending way too much time monitoring performance. HOWEVER, I've not had to walk in his/her shoes... it may be that...
April 30, 2007 at 9:56 pm
Pet peeve... maybe a rant... (please forgive the forthcoming soapbox)... consider this carefully... no matter which "performance monitoring" tool you use, what good does it do you if you find a...
April 30, 2007 at 9:46 pm
I am unable to duplicate the failure you say you are experiencing... that's not to say it's not happening... I just can't duplicate it because I don't have your data.
My...
April 30, 2007 at 7:53 pm
Yes... it works fine... if you are only updating one row at a time... try updating more than one row at a time and see what happens... BOOOMM!
I'm looking at...
April 30, 2007 at 7:20 pm
Nope... you made an unqualified statement with no conditions. And no one would force such an index as you have because everyone knows the bookmarks will kill any hope of...
April 30, 2007 at 7:07 pm
Dunno about others but I only use DTS for one off, ad hoc copies of data. If it goes into production, I use either BCP or Bulk Insert. I don't...
April 30, 2007 at 6:20 pm
You are missing joins between the PK of the INSERTed and DELETEd tables in all such SELECT's in the code you posted...
Recommend you change them all similar to the following...
April 30, 2007 at 6:09 pm
Viewing 15 posts - 56,491 through 56,505 (of 59,072 total)