777 reputation
26
bio website
location Arkansas
age 34
visits member for 2 years, 11 months
seen 2 days ago

Data Warehouse Specialist / Database Developer / Database Administrator


Aug
25
answered Is it possible to get SQL Server 2008 to download a file from a URL
Aug
24
comment How do you roll up header-level values on a fact table with line-item granularity?
+1 This will work. You can even get rid of the Shipping Amount column.
Aug
21
comment SQL Server data partitioning
+1 Denny.The Update is certainly the easiest to implement. The top clause will maximize concurrency and minimize the chance of filling the log (putting the db in recovery). It may run for hours/days though. If the record count is fairly low and you have a decent maintenance window, it may actually be the best option. However (you're the IO guru so correct me here), if the entire partition is affected and the record count is high millions/billions, would partition switching, mixed in with a few other minimally logged executions, not be significantly faster and require less IOPS than the Update?
Aug
19
comment In trying to setup back up device, net use command throws operating system error 53 when passing in a unc
+1 Shawn. There's no reason to use xp_cmdshell for this. Honestly, with all the tools available (CLRs, SSIS, the ability to invoke the command shell via the agent, Powershell...), there's really no legitimate reason to use xp_cmdshell. xp_cmdshell was a good "pre SQL 2005" tool that, for security reasons, most experts now recommend disabling.
Aug
19
comment Optimizations for new SQL Server 2000 database that will act as email queue AND API database
Why do new development on SQL 2000? Put some pressure on leadership to get up to date.
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 versions 2008R2 and 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