Viewing 15 posts - 18,481 through 18,495 (of 49,552 total)
On the point of hash partitioning, correct. If you just want to spread a table over multiple drives, create multiple files in the filegroup and SQL will do it's proportional...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2012 at 11:58 am
Tune your queries, it's likely to be as simple as that.
I have 2 articles at Simple Talk on finding the cause of poor performance in SQL, don;t have the links...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2012 at 4:58 am
You are highly unlikely to achieve anything other than adding complexity and wasting time. Partitioning is not a performance optimisation (mostly), it's for ease of maintenance, loading and deleting rows....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2012 at 4:57 am
Evil Kraig F (5/18/2012)
I think I'll go re-read your blog a few times until it gets better stuck in my head. 🙂
That's not on my blog. It's stuff I've learned...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 4:12 pm
Evil Kraig F (5/18/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 3:41 pm
Gullimeel (5/18/2012)
However, the people who queries dm_exec_query_stats to find the costly queries misses this sort cost.
No they don't (well, not unless they only look at logical IO). The sort...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 8:25 am
Gullimeel (5/18/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 7:19 am
Personally I find that i learn more and better if I write the code myself and check against his if something breaks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 6:46 am
There's no single package with them all and there are no hard and fast plans to release them, they'll probably appear over time.
(Paul is sitting 3m behind me)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 6:31 am
No, not at all, that's more likely to degrade performance as it flushes the plan and data cache and will require them to be repopulated entirely. That restore will result...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 6:27 am
The upgrade will require you to have the ITP certification, not just the TS.
If you want the SQL 2008 certs, if you with SQL 2008 and see value, write the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 6:25 am
Yes, it's not a failover server. It's a standalone instance that happens to be the witness for a mirroring config.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 3:23 am
Install SQL Express (free) and use that for the witness.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 3:10 am
michael vessey (5/18/2012)
please feel free to post a link to that article,
It's the kb article you just referenced.
From that kb:
IMPORTANT: You must run DBCC SHRINKFILE command while no other...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 2:51 am
dan-572483 (5/17/2012)
When you want to archive old data to archive tables, how is this a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 17, 2012 at 3:07 pm
Viewing 15 posts - 18,481 through 18,495 (of 49,552 total)