SQL Services Reporting Services - SSRS [Pros & Cons]

SQL Services Reporting Services - SSRS

• Pros
  • Flexibility in defining specific formatting and layout, specific item placement, multiple or composite report items, groups, headers, footers, subtotals
  • Report caching and snapshot for better performance especially if the source data query is complex and takes longer to execute
  • Creating report subscription for automatic report delivery via email or file share mode
  • Can combine multiple data sources (relational and OLAP data) into a single report
  • Additional charting options – map, area, range, scatter, polar, 3D, sparklines, data bars, etc
  • As similar as PPS dashboard, SSRS reports can also be deployed on a SharePoint site for collaboration
• Cons
  • Harder to create dashboards and therefore often done by IT people
  • No automatic drill-through and drill-across features

Attach mdf file without ldf file in Database

Please execute the following statement from sql server management studio

 CREATE DATABASE TestMyDb ON
(FILENAME =N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2EXPRESS\MSSQL\DATA\TestMyDb.mdf')
FOR ATTACH_REBUILD_LOG
GO

Please note:-
Where TestMyDb is the mdf file
And keep the file in the default location of the sql server.

SET LANGUAGE (Transact-SQL)

Syntax

---

          

SET LANGUAGE { [ N ] 'language' | @language_var } 
        

Arguments

---

[N]'language' | @language_var

Is the name of the language as stored in sys.syslanguages. This argument can be either Unicode or DBCS converted to Unicode. To specify a language in Unicode, use N'language'. If specified as a variable, the variable must be sysname.

Remarks

---

The setting of SET LANGUAGE is set at execute or run time and not at parse time.
SET LANGUAGE implicitly sets the setting of SET DATEFORMAT.

Permissions

---

Requires membership in the public role.

Examples

---

The following example sets the default language to Italian, displays the month name, and then switches back to us_english and displays the month name again.

DECLARE @Today DATETIME
SET @Today = '12/5/2007'

SET LANGUAGE Italian
SELECT DATENAME(month, @Today) AS 'Month Name'

SET LANGUAGE us_english
SELECT DATENAME(month, @Today) AS 'Month Name' 
GO

---

How to check db internal version

Execute the following command from sql server management studio Query window:-

select DATABASEPROPERTY((select DB_Name()),'Version')

------------------------------------------------------------------------------------------------------------

SELECT SERVERPROPERTY('productversion') as [Product version],

SERVERPROPERTY ('productlevel') as [Product level] ,

SERVERPROPERTY ('edition') as [Edition],

DATABASEPROPERTYEX((select DB_Name()),'Version') as [Internal Version Number]

,DATABASEPROPERTY((select DB_Name()),'Version') as [Internal Version Number--Deprecated]

,(select DB_Name()) as DBName,

(SELECT COMPATIBILITY_LEVEL FROM SYS.DATABASES WHERE NAME = (select DB_Name())) as compatibilityLevel

How to check sql server db version from backup file

Execute the following command from sql server management query window:-

restore

headeronly from disk='E:\Client\Sactech\RBK\Database\RBKPAYLITE_051212' 

 

Where  'E:\Client\Sactech\RBK\Database\RBKPAYLITE_051212'  is the backup file name with path.