4,774 reputation
11239
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 1 month
seen 9 hours ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc


Mar
5
comment OLE DB Sybase Connection Failing
32 vs 64 bit an issue?
Mar
5
revised How can I get more information about which lookup failed in an SSIS lookup?
Moar approaches
Mar
5
comment SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Martin Smith's answer is a good one on this question stackoverflow.com/questions/2009694/…
Mar
5
comment SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
While I find the relevant question, it's a bad idea as the optimizer chooses really bad plans because it has to assume the worst when you might never go beyond 30 characters for a field
Mar
5
answered How can I get more information about which lookup failed in an SSIS lookup?
Mar
4
comment Ola Hallengren with database mirroring
Do you really think you're qualified to speak on this matter? ;)
Mar
3
comment Recommendations for a SQL Server 2014 Database Administrators Course
This question is nice for the research you've done but not a fit for this website as this information will be stale with the upcoming 2014 release of SQL Server.
Feb
26
comment Merge data using Integration Service
Table -> Olap You need to identify the rows in Table that don't exist in Olap. Are you only looking for rows that don't exist in Olap or do you need to factor in whether the value has changed in Table and that's not reflected in Olap. If someone changed a value in Olap, you have a conflict - now what? What about a deleted row from Table that exists in Olap, does the solution need to factor this into the equation? What version of SQL Server are your source and destination. What are the data volumes and expected delta volumes?
Feb
26
comment Deleting Rows is Increasing Index Size
-1, no biml provided
Feb
24
comment Choosing between single table and multiple table database scheme
For my own edification, what's aal mean?
Feb
19
comment How to select the first row of each group?
I bet their skin turned red
Feb
18
comment Override Dimension Column Value
I add a Type: sprocket. The fact indicates there were 100 of these. You then modify sprocket to become "Schprocket". There's still 100 things. Are you saying that it should report Sprocket to me, Schprocket to you? What about the third person, what value do they see? Would you ever see both Sprocket and Schprocket based on the effective date?
Feb
18
reviewed Approve suggested edit on Restore .Bak file to different Server
Feb
14
comment How can I search SQL Server for maintenance plans that execute specific tasks?
In 2012, if you use the maintenance plan wizard, that is created using the legacy package deployment model. However, one could create a maintenance plan using SSDT which, by default for 2012+, is to create a project using the new project deployment model. Package deployment model goes to msdb. Project deployment model goes to SSISDB.
Feb
13
comment How can I search SQL Server for maintenance plans that execute specific tasks?
2005 SSIS used tables called sysdtspackagefolders90 and sysdtspackages90. For 2012, they introduced a new deployment model known as the Project Deployment Model. Those packages won't be in the msdb and instead will reside in their own dedicated catalog, SSISDB. I have not confirmed but I believe they are stored in their deployment unit, the .ispac file, which is a glorified zip.
Feb
10
comment How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?
Mulitcast is synchronous. The quick sniff test for synch vs async is whether the lineageid (pre 2012) remains the same before and after a transformation. Let me look into 2012 and how that works now.
Feb
7
comment How can I use running total aggregates in a query to output financial accumulations?
I find in situations like this, it helps to describe the problem in English. It appears that you understand how to use the enhancements to the OVER clause to perform the running sum calculation. Your root problem then is that the logic you have for computing PaymentAllocated is incorrect?
Feb
6
awarded  Nice Answer
Feb
6
revised Logging Questions for SSIS 70-463
While amusing, Finding Nemo animated gif probably not appropriate for the site
Feb
6
answered Logging Questions for SSIS 70-463