Search results for 'app:weblogs' matching tags 'SQL Server 2008 R2', 'best practice', and 'sql server'

Cumulative Update #3 for SQL Server 2008 R2 RTM

Anonymous — Tue, 17 Aug 2010 05:00:00 GMT

If you are following the patching of your SQL Server instances with Cumulative Updates then here is another instalment available for testing & deployment. KBA2261464 refers the release of CU3 hotfixes for the SQL Server 2008 R2 issues that have been fixed since the release of SQL Server 2008 R2 RTM, also the KBA refers the list of bugs fixed within this CU release (see below table). VSTS bug number KB article number Description 458389 979212 (http://support.microsoft.com/kb/979212/ ) FIX: A DateTime...(read more)

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

Anonymous — Fri, 09 Jul 2010 05:00:00 GMT

How many times have you taken help from SQL Server DMVs? How many of them are useful for your day-to-day data platform management? Well, they are closely attached to my day-to-day work. I'm excited to get my hands on upcoming client's project about their SQL Server platform review on the aspects of providing roadmap for the data-tier form a performance & scalability aspects with an additional flavour of high availability. In such scenarios I always keep my DBA-toolkit (scripts & references)...(read more)