Viewing 15 posts - 1,441 through 1,455 (of 9,399 total)
I had to look it up as well. My stuff doesn't come close. They sure have designed it to be bigger than I need (now anyways), which is nice.
June 6, 2017 at 6:16 am
Thanks for an easy one. I must admit I was looking for the trick. 😉
June 6, 2017 at 6:12 am
Performance of operations on DATETIME2 is 20...100 times (depending on the operation)...
June 6, 2017 at 5:51 am
I can give you the SQL to translate your filenames into dates. You may be able to use this in SSIS, but I'm not sure.
You have different formats...
June 5, 2017 at 5:38 pm
krishnabudampati - Monday, June 5, 2017 1:37 PMNo, I am rebuilding indexes before deleting data.
After deleting We are inserting data through SSIS.
So,...
June 5, 2017 at 2:55 pm
With no DDL, I'll take a guess at it, but this is only a general approach. Like J Livingston said, we'll need DDL to help with anything specific.
Take...
June 5, 2017 at 2:43 pm
June 5, 2017 at 2:38 pm
June 4, 2017 at 8:41 am
I'll pile on and say that I don't use datetime2 either. You can do direct math with datetime; it's that simple. The datetime2 returns an "operand clash" error.
Microsoft...
June 4, 2017 at 8:32 am
June 3, 2017 at 9:41 pm
Heh - a new post to a years-old thread, but it's an interesting one.
Solomon, I never knew SID_BINARY was undocumented. I just did some searching and you're right,...
June 3, 2017 at 6:54 pm
Viewing 15 posts - 1,441 through 1,455 (of 9,399 total)