Here I would like to help for common question that every DBA has when it comes to SQL Server Licensing. Refer http://www.microsoft.com/en-in/server-cloud/products/sql-server/buy.aspx for different licenses available.…
Below script helps restore several databases on to a SQL Server instance in one go. We just have to place all the .bak files in…
This stored procedure helps automatically create new partition on a new file group to an already partitioned table. I have tested the script in my…
We have heard enough of the new feature in SQL Server 2012 that replaces our conventional Database Mirroring notion. It is the Always-on Availability groups…
There are several ways to configure and start monitoring page splits on SQL Server. But now in 2012, we could make use of extended events…
Below article on replication was written by my colleague Nideesh K Vasudevan. I would like to thank him for his easy to understand input on this…
What are differences between a latch and a lock? What are the different states of an spid in SQL Server? Explain each state. What are…
Problem A few months back, I had shared a script to automate index rebuild/reorg in a database with fragmentation analysis inplace at https://www.sherbaz.com/2013/06/resumable-auto-index-rebuild-and-reorganize-script/. But that…
Problem In all SQL server failover clusters in our environment, It came to our notice that the SQL Server Agent is spamming the Application eventlogs…
We could easily grant execute permission to a user on all stored procedures on a database as below. USE GO GRANT EXECUTE TO GO But…