Reputation
1,301
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 23
Impact
~80k people reached

1d
comment LDF files vs. TRN files vs. Tempdb.MDF+LDF files.:
I think we could probably get the just of this without your IP address.
1d
comment Trace Flag 4199 - Enable globally?
Are you currently experiencing cardinality estimate issues or something?
2d
revised What is the fastest way to insert large numbers of rows?
deleted 1 character in body
May
6
comment How to optimize a query so that it seeks on one index first, and then another index after that
What does your query plan look like if you remove those hints?
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
Wait are you trying to use a linked server query in SSIS?
May
4
revised Convert date in date list condition to list of date ranges
Added a proper DB tag.
May
4
suggested approved edit on Convert date in date list condition to list of date ranges
Mar
27
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 or insert data if no match
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.