SQL Server Education (by the geeks, for the geeks)
Moving logins between instances is one of the critical migration activities. Let’s see how it can be done in powershell with the help of SMO.When transferring logins, two things need to …
SQL Server Using Powershell to Move Logins between Instances Read MoreRecently I was involved in a project where in non-clustered indexes were to be moved to a different file group for the sake of performance benefit. It has to be done …
SQL Server Using Powershell to Move Indexes to New File group Read MoreThis blog is part of the series The TSQL Classes: Stored Procedure. In this class I’ll talk about SQL Server TSQL nested procedures, recursion and plan caching. Let’s begin with creating …
SQL Server TSQL – The TSQL Classes Stored Procedures: Nested proc, Recursion And Plan Caching Read MoreThis blog is part of series The TSQL Classes: Stored Procedures. Introduction: To put simply, a SQL Server stored procedures is set of queries put together primarily to reuse a complex/iterative …
SQL Server Stored Procedures – The TSQL Classes Stored Procedures: A Primer Read MoreCyclic deadlock occurs when a process say P1 is waiting on a process say P2 to release a lock and process P2 is waiting on P1 to release a lock. The …
SQL Server: Cyclic Deadlocks Read MoreI had a scenario where in I had to automate index maintenance in a mirroring environment. Database mirroring requires a database to be in full recovery mode and thus index rebuild …
SQL Server – Automate Index Maintenance in Mirroring environment Read MoreToday, I came across a surprising situation when running sp_spaceused on one of my dummy table “Tblemployee”. The SQL Server sp_spaceused told me that it has over 200,000 records, however it …
SQL Server sp_spaceused returns wrong count Read MoreRecently a developer came to me seeking my help in generate list dates between date range for a report. Being a .Net developer he said that one solution he had is …
Generate List Dates between Date Range Read MoreThis post compares the performance of adding an identity column to a table using Identity property versus by using sequence objects. The below code creates a table and fills it with …
SQL Server 2012 : Identity VS Sequence: A performance Comparison Read MoreWhen posting my last blog on sequence I realized that sequences can also be used to generate dummy data for test tables. On further analysis I found that it’s faster than …
SQL Server 2012: Generating Dummy Data using Sequence Objects Read More