732 reputation
25
bio website
location Arkansas
age 33
visits member for 2 years, 4 months
seen Apr 17 at 18:43

Data Warehouse Specialist / Database Developer / Database Administrator


Jul
17
comment Poor performance after changing SQL Server 2008 R2 database
I agree with the Hash hint Aaron. This query is so complicated that it could be risky to start messing with adding indexes. In general, looking at the estimated verses actual numbers on both plans, it seems that there could be some missing stats... Stats are very cheap and can really help the optimizer generate better plans.
Jun
30
answered SSIS Lookup Component Irregularities
Jun
30
comment What is different between SQL SERVER 2008R2 and SQL SERVER 2012
LOL, you left out licensing costs
Jun
26
answered How to log error details when using using try/catch for dynamic SQL backup commands
Jun
18
awarded  Commentator
May
6
comment Is it OK to create hundreds of databases in SQL Azure versus one big one and run the risk of deadlocking
+1 Great answer Darin.
May
2
comment Fast SQL query with * but extremely slow with specific columns?
When was the last time that stats were updated? A Hash join usually means that either 1 table is MUCH BIGGER than the other or that stats are severely out of date (one or more tables has an estimated row count much lower than the actual row count). Also, what does the index structure look like on these tables? Listing the actual execution plan would save you from answering many questions.
Apr
28
comment Why are periodic restarts required to keep my instance performing well?
+1 For memory leak. I doubt the page life expectancy is very long on this server, but it shouldn't make the pagefile grow rapidly. FYI, almost the same issue here (it was AV that was the issue): social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/…
Dec
30
comment In which folder / directory does SQL 2008 store files?
+1 for method 2 in the link.
Dec
30
comment Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
One thing to note, the scheduler likes things to be even. For example, if you schedule a job to run hourly, the job will get called every hour on the hour (even though you scheduled it at 12:15 and said it should start today).
Dec
21
revised Will Entity Framework and/or Linq-To-SQL queries show up as “Adhoc Queries” in SSMS' “Server Dashboard” Report?
added 95 characters in body
Dec
21
answered Will Entity Framework and/or Linq-To-SQL queries show up as “Adhoc Queries” in SSMS' “Server Dashboard” Report?
Dec
19
comment Sql Server Enterprise 2008 R2 Partition Switch with Xml Index
+1 Good find. I'd say disable the index, switch partitions, then rebuild the index. Or drop index, switch partitions, recreate index. Either should work.
Dec
14
awarded  Teacher
Dec
14
awarded  Editor
Dec
14
revised How does SQL Server determine the order it takes locks in while selecting a table?
added 143 characters in body
Dec
14
answered How does SQL Server determine the order it takes locks in while selecting a table?
Dec
2
comment SQL Server Optimization/Configuration for Inflexible Application
+1 Great answer Mark!
Dec
2
comment Any security related reasons to prefer Windows Authentication over Sql Server Authentication?
+1 Cut and dry. Additionally, kerberos delegation is only possible with windows authentication. I've seen enough linked servers set up to use the sa account that I appreciate the security added with kerberos delegation.
Dec
2
answered Loading a FACT table per day