Viewing 15 posts - 5,566 through 5,580 (of 13,874 total)
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
Permissions -- I can't see the test or prod server from the dev server that...
May 16, 2017 at 1:33 pm
Have you tried deploying directly from VS? I see no benefit in copying ispacs around, nor is there any need to run the wizard.
May 16, 2017 at 12:52 pm
Feeling really stupid now.
I've done this before. Back in 2005 or 2006. This fact...
May 16, 2017 at 11:20 am
I was looking for an option to load tables(100+) from a busy OLTP instance...
May 16, 2017 at 11:18 am
Viewing 15 posts - 5,566 through 5,580 (of 13,874 total)