Viewing 15 posts - 391 through 405 (of 1,838 total)
Hey great find! I think this unfortunately highlights how ridiculous things in SSIS are, and how many hoops you have to go through to get what should be the most...
October 29, 2018 at 3:08 pm
October 25, 2018 at 3:06 pm
Wow, just wow, I just got a notice about Microsoft has finally improved the error "Binary or string data would be truncated"
This feature is shipped in SQLServer 2017...
October 25, 2018 at 10:03 am
Are you doing these steps during off hours when no one is in the system? If so that would be fine, if there's the possibility of data INSERTs/UPDATEs/DELETEs occurring during...
October 24, 2018 at 2:02 pm
The Sommarskog article is a very good article, if you're having problems with it, I'd say the first thing to check is that the sessions running the query have the same...
October 18, 2018 at 1:32 pm
October 11, 2018 at 3:24 pm
October 11, 2018 at 9:12 am
probably the worst SQL code pattern I've seen goes something like this...
scalar function to find "current" record:CREATE FUNCTION fun_GetCurrentStatus(@EntityID INT)
RETURNS INT AS
BEGIN
DECLARE @EntityStatusID...
October 10, 2018 at 2:45 pm
Integration Services is NOT cluster aware. Do you have it setup as a resource of the cluster? There is an article describing the pros and cons of this setup here:
October 10, 2018 at 8:55 am
October 3, 2018 at 3:04 pm
September 28, 2018 at 2:52 pm
September 13, 2018 at 2:49 pm
getting into Kimball vs Inmon vs etc. is probably too much for something that's going to be an hour presentation. I'd imagine you'd pick the one you're most familiar or...
September 10, 2018 at 3:24 pm
September 10, 2018 at 2:54 pm
Viewing 15 posts - 391 through 405 (of 1,838 total)