Recently I got an opportunity to present at the SQL Server day organized by www.SQLServerGeeks.com on SQL 2012 Indirect Checkpoints.In this post I would like to explain the same for the benefit of wider audience. The focus of SQL 2012 has always been to provide a reliable,robust and Highly Available Database Solution to give the…
Recently I had to create a script which will monitor free space of all the datafiles and send alert if the free space within a datafile falls below 10% of the Total file space. The following script should help to achieve the objective so sharing with the larger audience SET NOCOUNT ON DECLARE @Tbl Table…
Following are links to my blog post on SQLServerGeeks.com. Hope you find them useful Does Parallel Plan for rebuild index impact the fragmentation of index? http://sqlservergeeks.com/blogs/Parikshit/personal/427/does-parallel-plan-for-rebuild-index-impact-the-fragmentation-of-index Parikshit Savjani Premier Field Engineer
As SQL 2012 is in it’s RC0 phase, I was trying to configure AlwaysON on my 2-node WSFC with node and disk majority.Next I installed Default instance of SQL Server in parallel ( to save some time ) on both nodes of the WSFC.Next I enabled my instances for AlwaysON from SQL Configuration Manager for…
Many times it is annoying to receive email alert when there is no data in the report. Generally such cases happen when you have scheduled an email subscription for a report which fires at the specified schedule and delivers the report. However as an end user you might be interested to receive an email alert…
Following is the powershell script to script out all the Jobs in one go. param($sqlserver) [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.Smo”) | Out-Null $srv = New-Object “Microsoft.SqlServer.Management.Smo.Server” $sqlserver $srv.JobServer.Jobs | foreach {$_.Script()} You can copy the above code in a notepad and save it as .ps1 file in some location on server. Next from the Object Explorer in SQL Management…
In SQL Server, our Auto Update Statistics algorithm still relies on the default 20% modification on a given column to trigger update statistics. However different customers have different workloads and for some this threshold value triggers Update stats less frequently (e.g SAP databases) while for some workload the default 20% setting triggers Auto Update Stats…
As we all know, Report Server Execution Log plays a significant role and is the first place to look into in order to analyse & optimize the Performance of Reporting Services. Hence in each version of SQL Server, the ExecutionLog view in Report Server database is enhanced to gather more and more information. If you…
Real Quick Post on one of the issue I faced today while connecting to SQL Analysis Services on my own laptop. Today, when I tried connecting to named instance of SQL Analysis Services on my laptop using SQL Management Studio, I received following error TITLE: Connect to Server —————————— Cannot connect to *********sqlr2. —————————— ADDITIONAL…
Recently I was trying to apply a security update for one of my SQL instance and I encountered the following error in my summary log Note: For those who are not aware, summary.txt is located in C:Program FilesMicrosoft SQL Server100Setup BootstrapLog A failure was detected for a previous installation, patch, or repair during configuration for…