Reputation
6,160
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 18 46
Newest
 Yearling
Impact
~367k people reached

Jun
23
comment Predicate not resulting in expected scan
In the second query, it's not directly using the ImageDate value, is it? The outer where clause is going to operate on CONVERT(VARCHAR(10),im.[ImageDate],101) AS ImageDate instead of the native date/datetime/datetime2 data type.
Jun
23
revised Predicate not resulting in expected scan
pair = 2; pare = remove. And that's, one to grow on. Go Joe!
Jun
22
comment SSIS - The value could not be converted because of a potential loss of data, runs fine in BIDS, not on the server
Same CSV loaded to the same table in the same database using the same SSIS package and it works from BIDS but not SQL Agent? Sounds ... unusual. My triage would look like 1) Run the package on my machine outside of bids (dtexec /file MyPackage.dtsx) 2) Run the package from my machine against the server copy (dtexec /ser MyServer /sql MyPackage`). 3) Log on to server and re-run #2 from command line. If all of those work, then I'd look at the second line of output from both and see whether there is a patch level difference between your box and the server.
Jun
15
awarded  Yearling
Jun
1
comment Avoiding “Row by row” fetch method when dealing with source LOB columns
When you explicitly cast them in the source system to a non-max sized, was that in an existing data flow or did you create a new one, or at least a new source component for it? When you provide the a query with the same column names and just skinnier types, some times that doesn't register as a change so the editor doesn't fire off a metadata collection process (which can be expensive). Also, a varchar(max) is going to be treated as a LOB for an SSIS data flow and that can hurt agilebi.com/jwelch/2010/05/11/…
May
28
comment System.OutOfMemoryException SQL Server 2012 and 2008R2
Or Excel with PowerPivot, Excel with External Data Sources. SSMS Results to File, BCP, PowerShell, sqlcmd etc
May
25
revised How to select the first row of each group?
Props to those who who know Oracle
May
25
awarded  Good Answer
May
24
comment How to archive a whole database?
No, do not go route #2. Take a backup and after taking the backup, verify it. When you detach, you don't know whether the database was corrupt at that point in time. If it was, you may be toast attempting to re-attach it
May
11
comment SSIS Package Security
Help me understand then, what would secure development look like as opposed to secure execution
May
10
answered SSIS Package Security
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
There may be error messages posted before this with more information on why the AcquireConnection method call failed <- were there additional messages? SELECT * FROM ssisdb.catalog.operation_messages AS OM WHERE OM.message_type = 120 AND OM.operation_id = @MyLastRun;
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
FWIW, the openquery syntax generally gives better performance with filtered queries because it pushes the filter to the source system. The 4 part query can result in all the data being pulled back to SQL Server and then the filter is applied. Syntax for openquery may be a little wonky but I'll take that over the performance drag. Never mucked about with pushing updates though
May
5
revised Calculating values from three related tables, without using join or union
receved
May
5
answered Calculating values from three related tables, without using join or union
May
5
comment Calculating values from three related tables, without using join or union
Someone has placed an unreasonable constraint upon you and your solution. Instead of using the correct tool for the job, a relational query, you must extract the data into some external tool, like Excel, or craft a specific program, C#/PowerShell/etc, to extract all the data from the tables and perform the "join" logic in there which is silly and inefficient
May
5
comment Calculating values from three related tables, without using join or union
You have a relationship between 3 tables. You cannot simply sum the quantities per table and add them together as that would merely reflect the total quantity available. What you are likely asking for is the quantity available by item
Apr
29
comment Tracking row level status of SSIS ETL process
Yes. This can be done. However, your question needs details to be answerable. SSIS 2012/2014 in project deployment model? If not, have you enabled logging within your SSIS packages? Do you have a framework built out for tracking execution of your packages? etc, etc etc
Apr
29
answered How to format SSIS Expression for weekend
Apr
28
comment SSDT Schema Compare doesn't work while a BULK INSERT is in progress
As with everything in development, there are trade offs. If you want to shove the maximum amount of data into a table, you need to ensure no one sticks a finger in there and it gets chopped off due to moving parts. That's what the locks are trying to do and that's a good thing. Unless I have a reason not to, I always lock my tables for loads. I then make sure my data flow is well tuned so that I don't have a table locked for hours on end. Locks can escalate to table locks once a documented threshold has been passed.