1,269 reputation
723
bio website
location Minneapolis, MN
age 28
visits member for 2 years, 8 months
seen 2 days ago

I'm a database architect/administrator specializing in Business Intelligence out of MSP.


2d
comment Viewing execution plans for queries with parameters
Note to self do not use Microsoft Dynamics AX 2012. In all seriousness though you probably don't need to see the execution plan to determine what's wrong with this query. Replace your cross joins and that will alleviate the majority of your problems.
Mar
17
comment Automatic database restore fails as cannot find file
You could even have the ELSE make the process wait a few minutes and then try the restore again.
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Well for starters Windows and Linux are both spelled and pronounced differently.
Mar
10
comment Keep Execution Plan in Cache - SQL Server 2012
It's probably not the execution plan that's making it go faster. It's the data. After you run a query SQL Server may keep the data in Cache. Therefore it doesn't have to read the disc to get the information instead it can pull it from RAM which is much faster. While your execution plan may also be stored in the plan cache I highly doubt compiling an execution plan is increasing your query cost 7 fold.
Feb
18
comment SSIS Import Data and insert data
Essentially you just need to set your lookups to on no match Redirect row and then move to flow accordingly.
Feb
12
comment Process staging table by getting unique rows only (incremential)
You're not actually creating the final table every time are you?
Feb
6
answered Sql server 2014: backup log to 2 destinations
Feb
6
comment Sql server 2014: backup log to 2 destinations
I don't know that it would take 10 days to write a PowerShell Script for this...
Feb
5
comment Error message when importing data into SQL (Import & Export Data Wizard)
I repeat "if you import it as string and then try to cast that column as float does that work?"
Feb
5
answered Automatically restore SQL Server database from file from another server
Feb
5
comment Error message when importing data into SQL (Import & Export Data Wizard)
What's the structure of the table you are inserting into? Also is there any point at which the data isn't a numeric value? Like if you import it as string and then try to cast that column as float does that work?
Jan
30
comment Need to query records based on Date only (Sample Query given)
@AaronBertrand as a dedicated Tricyclist I am offended.
Jan
20
comment SSIS Multicast performance question
Very good work sir.
Jan
8
comment SQL Server Index Update Deadlock
There's a NOLOCK joke to be made here but I'm afraid somebody will mistake it for advice.
Dec
19
comment SSIS Condition that include two connections/data bases
The lookup function should do exactly what you need if I'm parsing your question correctly.
Nov
5
comment SSIS package error, can't find pre-compiled script
If you open the script and then choose build does it give you any errors?
Oct
29
comment Why is Excel File Opened Exclusively By Another?
@Fastidious what does the package look like? Do you have multiple connections to that file within the package?
Oct
29
comment Why is Excel File Opened Exclusively By Another?
To completely rule out the idea that someone else has the file open. Try making a copy of the file. Then connecting to that copy and see if it works.
Oct
29
comment Char in select why
I'd prefer if you gave an example that didn't use pre Ansi-92 join syntax.
Oct
28
awarded  Notable Question