Author Archives: mohammedu

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!

Posted in Uncategorized | 1 Comment

Microsoft SQL Server 2008 Service Pack 2

Microsoft finally release Microsoft SQL Server 2008 Service Pack 2 after long CTP testing…   Key improvements in Microsoft SQL Server 2008 Service Pack 2 are:   Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for … Continue reading

Posted in SQL Server 2008 | Leave a comment

SQL Server 2008 R2 RTM

SQL Server 2008 R2 is available today (May 3rd 2010) to TechNet and MSDN subscribers…. and available for download worldwide on May 13 as per the following blog… http://msdnrss.thecoderblogs.com/2010/04/25/sql-server-2008-r2-rtm/  http://blogs.technet.com/microsoft_blog/archive/2010/04/21/SQL-Server-2008-R2-Helping-Customers-Get-More-Value-Out-of-Their-Data.aspx    

Posted in SQL Server 2008 | 11 Comments

Best Practices Analyzer (BPA)

As per the CSS blog entry SQL Server 2008 R2 BPA is based on the new Microsoft Baseline Configuration Analyzer (MBCA) v2.0 is coming soon…   http://blogs.msdn.com/psssql/archive/2010/04/22/europe-pass-a-volcano-live-meeting-and-sql-2008-r2-bpa.aspx      

Posted in SQL Server 2008 | Leave a comment

Parameter Sniffing trace flag 4136

Microsoft has released Cumulative Update Package 7 for SQL2008 SP1 (KB797065). In this update there is a new feature (trace flag 4136) that let us control the Query Optimizer should do parameter sniffing (KB980653) or NOT.   Improve Performance on … Continue reading

Posted in SQL server | 11 Comments

SQL Server 2008 R2 Update for Developers Training Kit

SQL Server 2008 R2 Update for Developers Training Kit is available as a free download from the Microsoft Download center… http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d Overview SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced … Continue reading

Posted in SQL Server 2008 | 46 Comments

Table size in all DBs

create Procedure Mu_TableSizeas if object_id(‘TableStorage’) is  null  –drop table TableStorageCREATE TABLE  TableStorage( [ServerName] [nvarchar](128) NOT NULL, [DatabaseName] [nvarchar](128) NOT NULL, [TableName] [nvarchar](128) NOT NULL, [RowCount] [bigint] NULL, [TotalSpace] [bigint] NULL, [DataSpace] [bigint] NULL, [IndexSpace] [bigint] NULL, [UnusedSpace] [bigint] NULL, [DateInfoCollected] [datetime] NULL) declare @command1 varchar(500), @command2 varchar(500), @command3 varchar(500), @replacechar … Continue reading

Posted in SQL Server 2005 Scripts | 100 Comments