meta user
network profile
| bio | website | |
|---|---|---|
| location | Arkansas | |
| age | 32 | |
| visits | member for | 1 year, 5 months |
| seen | May 16 at 15:54 | |
| stats | profile views | 21 |
Data Warehouse Specialist / Database Developer / Database Administrator
|
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 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? |
