Viewing 15 posts - 5,566 through 5,580 (of 13,877 total)
i am using execute sql task to zip my files to .gz extension.
but getting error...
June 7, 2017 at 2:14 pm
It seems that many others have experienced similar issues. One method which appears to have worked for some is using an ODBC connection rather than ADO.NET. Is this a possibility...
June 7, 2017 at 1:10 pm
Anyone in the mood for talking about RAM requirements while remaining tight-lipped about the use of NOLOCK? Here you go.
May 22, 2017 at 6:00 pm
It does sound as if locale might be the issue (DMY vs MDY).
Just to be clear, please confirm the following:
a) The source is a spreadsheet with a date...
May 22, 2017 at 1:42 pm
May 22, 2017 at 6:59 am
Might be useful to know what version of SSDT/BIDS you are both using.
May 22, 2017 at 5:27 am
So we are a 24/7 operation so for my new/first DW I have a...
May 21, 2017 at 6:57 am
May 19, 2017 at 8:57 am
May 19, 2017 at 6:53 am
The temp table is created within the scope of the execution of the dynamic SQL and is not available to the outer process, because it's out of scope.
May 18, 2017 at 12:29 pm
Again, I appreciated all the help, its awesome!
Phil, I'm glad you asked as I was...
May 18, 2017 at 5:47 am
Both old functions and new functions are iTVFs (new functions use CTE). I...
May 17, 2017 at 2:41 pm
Bravo. Just one thing; doesn't SELECT COUNT(*)/750000 AS FileCount
FROM dbo.MyTable
Give you one less than FileCount?
Eg, if Count(*) = 500000, FileCount would be calculated as zero.
May 17, 2017 at 11:34 am
Viewing 15 posts - 5,566 through 5,580 (of 13,877 total)