Tags » SQL Server

SQL SERVER - List the Name of the Months Between Date Ranges - Correction

Earlier I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? 190 more words

SQL Authority

Why you should not use remote SQL Server with ConfigMgr 2012

 

As a senior consultant, long time administrator of SMS/ConfigMgr and former SQL Server MVP, I have some strong opinions on this subject. These opinions are based on years of actually designing, implementing and using the product. 317 more words

ConfigMgr

SQLAuthority News - Presented on Database Worst Practices at SQLPASS 2014 in Seattle - November 5, 2014

Earlier last month, I had the opportunity to present at SQLPASS 2014. The event was held in Seattle in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 5, 2014. 260 more words

SQL Authority

SQL Server: T-SQL script to get list of tables in database with size and row count

The following T-SQL script  will gives list of tables in database with row count, full size, data site and index size for each table

USE AdventureWorks2008R2
GO
SELECT TableName = Object_name(p.object_id), 
       'RowCount' = Sum(CASE 
                      WHEN ( p.index_id < 2 ) 
                        AND ( a.type = 1 ) THEN p.rows 
                      ELSE 0 
                    END), 
       'Size (Mo)' = Ltrim(Str(Sum(a.total_pages) * 8192 / 1024., 15, 0)) / 1024 , 
       'Data (Mo)'= Ltrim(Str(Sum(CASE 
                                   WHEN a.type <> 1 THEN a.used_pages 
                                   WHEN p.index_id < 2 THEN a.data_pages 
                                   ELSE 0 
                                  END) * 8192 / 1024., 15, 0)) / 1024, 
       'Index (Mo)' = Ltrim(Str(( Sum(a.used_pages) - Sum(CASE 
                                  WHEN a.type <> 1 THEN a.used_pages 
                                  WHEN p.index_id < 2 THEN a.data_pages 
                                  ELSE 0 
                                                          END) ) * 8192 / 1024., 
                           15, 0) 
                     ) / 1024 
FROM sys.partitions p, 
     sys.allocation_units a, 
     sys.sysobjects s 
WHERE p.partition_id = a.container_id 
      AND p.object_id = s.id 
      AND s.type = 'U' 
GROUP BY p.object_id 
ORDER BY 'Size (Mo)' DESC
SQL Server

SQL Server Error in the Installation of System Center Operations Manager

I have already received several times questions of professionals about the error below the installed SCOM in all its versions.

Actually the error is pretty generic and who typically asked me not requirements pages consulted found the problem. 250 more words

System Center

SHANU C# & You

Welcome to my SHANU C# Blog.

I strongly believe in ” Thoughts of yours ,Works of Ours makes the Best “.  

Welcome to my C# World Blog. 134 more words

ASP.NET

SQL SERVER - Reverse String Word By Word - Part 4

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara and Yuri Petrov contributed to the blog post with their excellent script which I have blogged earlier. 162 more words

SQL Authority