Viewing 15 posts - 4,606 through 4,620 (of 7,429 total)
FOr this situation it is faster to compare on the secound simply because as the data moves into the buffer from the external query it checks that value by running...
October 18, 2002 at 3:12 pm
Tables dastetime stamp for creation is not updated in anyway. ANd there is no modified datetime which I have put into MS for request in future version.
"Don't roll your eyes...
October 18, 2002 at 3:03 pm
Note from SQLBOL
quote:
NO_LOG | TRUNCATE_ONLYRemoves the inactive part of the log without making a backup copy of it and truncates the...
October 18, 2002 at 3:00 pm
Actually the limit is now 4gb for the zip 2.0 standard which is what WinZip 8 is based on. I have been curious how SQLZip gets around that (especially since...
October 18, 2002 at 2:49 pm
What effect did it have on your performance?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 18, 2002 at 2:36 pm
Check the column width that DTS in generating for the column on the destination tab. DTS only reference the first few records or so and may not realize the actual...
October 18, 2002 at 5:31 am
If the Tuesday full did not cause the log file to delete any of the internal data then Mondays backup will work with Tuesdays and Wednesdays TL backups, if the...
October 18, 2002 at 5:20 am
This is considered the best script around to use. I have used it since I first started using SQL 7. The author Andrew Zanevsky had a great article on it...
October 18, 2002 at 5:18 am
Check alias in Cient Network Utility also.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 18, 2002 at 5:09 am
It should not, from my understanding under the hood everything is stored physically as an interger value that is the value of the number of seconds since Jan 1 1970,...
October 18, 2002 at 5:07 am
You apparently misread. The bug was that it can cause an access violation instead of just the error message you see.
Take a look at the KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q308759
It does not...
October 18, 2002 at 4:53 am
Actually on the Source tab of the transformation task you can code a query, just code to look at the modified date on the Oracle side so that you get...
October 18, 2002 at 4:48 am
The only limits on a table you may run into is if you use an Identity column and it is limited to the max number that can be generated by...
October 18, 2002 at 4:45 am
By creating a DTS package or a JOB using active script to do it.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 18, 2002 at 4:32 am
To the best of my knowledge unless undocumented there is no such function or feature already built into the table rows themselves.
"Don't roll your eyes at me. I will tape...
October 18, 2002 at 4:30 am
Viewing 15 posts - 4,606 through 4,620 (of 7,429 total)