SQL Server Mirroring Concept: Key Features: Limitations: Always On Availability Groups Concept: Key Features: Advantages: Use Cases: Summary For new implementations, Microsoft recommends using Always On Availability Groups due to… Read more »
Transfer sql server login from one source server to target server sp_help_serverlogin is a stored procedure which helps to transfer logins and passwords from one instance of a server to… Read more »
Find out who are the owners of the SQL Server agent jobs with the help of below script. SELECT J.name AS [Job Name] ,L.name AS [Job Owner] FROM msdb.dbo.sysjobs_view J… Read more »
How to select size of all sql server Databases Below script will select the size of all your SQL Server databases in MB and GB as well. SELECT d.NAME ,ROUND(SUM(CAST(mf.size… Read more »
Check Index Fragmentation on ALL Indexes in a Database I use to make note for my self so that I can recall it quickly! when I am using a development… Read more »
Displaying Report Generating the Date time and user name without Domain or System name: 1- Go to Design mode and Create footer in SSRS report 2- From The toolbox add… Read more »
COMPUT Clause is not allowed in Database Compatibility 110 Issue Details- Impact- The COMPUTE clause generates totals that appear as additional summary columns at the end of the result set…. Read more »