Just Misc

–clear wait stat DBCC SQLPERF(“sys.dm_os_wait_stats”,CLEAR) –To setup the template –You will have to change your username XCopy “\\serverName\e$\SQL_Template\*.*” “C:\Users\loginname\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\Templates\Sql\” /E /Y –root block SELECT p.sid ,convert(char(12), d.name) db_name , program_name , convert(char(12), l.name) login_name , convert(char(20), hostname)

SQL Server 2012 Diagnostic Information Queries — Glenn Berry (copied)

— Copied from http://sqlskills.com/blogs/glenn/ — SQL Server 2012 Diagnostic Information Queries — Glenn Berry — June 2016 — Last Modified: June 8, 2016 — http://sqlserverperformance.wordpress.com/ — http://sqlskills.com/blogs/glenn/ — Twitter: GlennAlanBerry — Please listen to my Pluralsight courses — http://www.pluralsight.com/author/glenn-berry —

A View: New In-Memory database system Technology

With the current trends and competition between database vendors, major database vendors like Oracle and SQL Server are moving towards in-memory database services, although in-memory database server already have long history since 1993. Most of us already heard and learnt

Challange in implementation of Transparent Data Encryption (TDE) in your corporation

Many corporation and business required to encrypt their databases for compliance and security. Database vendor providing different tools and addon in their product as their business needs. One of the encryption technique vendor incorporate in their product is Transparent Data

Tagged with: , , , , ,

Find index fragmentation in table

As a DBA, you often get question from developers and users- what is indexing and fragmentation? Well, in simple words indexing is the process of creating index in the table to enhance the performance of queries. Index is created as the subset

SQL Server Reporting Service report size limitation

SQL Server Reporting Service report size limitation When you create report in SSRS and if the size of report is higher than 4MBs size, you will get error while exporting those reports. You usually doesnot see any specific error while