Viewing 15 posts - 3,226 through 3,240 (of 11,676 total)
I have also found contradicting information:
Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary...
April 24, 2014 at 12:05 am
Log into the SSIS service, go to the folder Maintenance Plans. Find the one you need, right-click and choose "Export Package".
Or don't export and reference it directly in the Agent...
April 22, 2014 at 7:46 am
CASE returns a single data type.
From BOL:
Returns the highest precedence type from the set of types in result_expressions and the optional else_result_expression.
Formatting is best done in the front tool, not...
April 22, 2014 at 4:33 am
The columnstore index only slows down your load (but it improves query performance afterwards of course).
Loading the dimensions should be quickly I guess (you haven't given us much information). Make...
April 22, 2014 at 2:15 am
mbj470 (4/21/2014)
I'm getting ready to take my MS 70-461 exam and was wondering if the questions they ask that contain SQL statements are well formatted (meaning easy to read)?
It has...
April 22, 2014 at 12:03 am
Can you post the exact error message?
Which version of SSIS are you using?
Be aware that SSIS in earlier versions is not cluster aware.
April 18, 2014 at 4:03 am
Carlo Romagnano (4/18/2014)
April 18, 2014 at 2:22 am
Carlo Romagnano (4/18/2014)
When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.
You can copy paste the...
April 18, 2014 at 1:59 am
Too easy 😀
Have a nice Easter weekend, and don't eat too much chocolate!
April 18, 2014 at 12:10 am
Is there a value in the MemberRole element that can give an overflow for a bigint?
April 17, 2014 at 2:49 pm
Oh yeah, no-one has ever died of giving columns readable names...
April 17, 2014 at 2:42 pm
Pretty easy with windowing functions (if you have SQL Server 2012).
The code is quite long but that's because I have a soft spot for CTEs. The queries itself are pretty...
April 17, 2014 at 2:42 pm
Viewing 15 posts - 3,226 through 3,240 (of 11,676 total)