Log in | Register

Prince Rastogi, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Prince Rastogi, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

PrinceRastogi

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

Prince Rastogi

About Prince Rastogi

Prince Rastogi is working as Principle Database Administrator at Admiral Technologies. Prince started his career working on SQL Server since Yukon. Prince is having almost 7 years of experience and worked in ERP Domain, Wealth Management Domain. Currently he is working in Insurance domain. In the starting of his career he was working on SQL Server, Internet Information Server and Visual Source Safe. He is post graduate in Computer Science. Prince is ITIL certified professional. Prince likes to explore technical things for Database World and Writing Blogs. He is Technical Editor at SQLServerGeeks.com.

SQL Sever 2017 – Resumable Online Index Rebuild Parameters

Hello Friends,

In my previous blog post, we have learned about the importance and use of Resumable Online Index Rebuild Operation. In today post we will learn about the various parameters those we can use or we should consider while using this feature. First let me show you the syntax for Alter Index Rebuild operation […]

By |September 2nd, 2017|Categories: Database Administration, Database Maintenance, Indexes & Statistics|Tags: , |Comments Off on SQL Sever 2017 – Resumable Online Index Rebuild Parameters

SQL Sever 2017 – Resumable Online Index Rebuild

Hello Friends,

As a Database Administrator for big size databases, we generally face the issue of small maintenance window for performing index maintenance operations. We keep trying to our business management for allowing us more maintenance window time but sometimes Business/management does not allow us for a longer maintenance window. Finally somehow, we do the […]

By |August 26th, 2017|Categories: Database Administration, Database Maintenance, Indexes & Statistics|Tags: , |Comments Off on SQL Sever 2017 – Resumable Online Index Rebuild

SQL Sever 2017 – Smart Transaction Log Backup

Hello Friends,

SQL Server 2017 CTP 2.1 has been announced with some new features, one of them is Smart transaction log Backup i.e. exposing the log in mb since last log backup. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post […]

SQL Server – ROW_NUMBER versus TOP N

Hello Friends,

This blog post is the result of question asked by some professionals working on databases. While writing T-SQL code they generally use TOP N in the code to get the top n number of rows in the result set. They knew the another way to achieve the same result by using ROW_NUMBER. Now the […]

By |May 7th, 2017|Categories: Database Development, Performance, SQL Server, Transact-SQL|Tags: , |Comments Off on SQL Server – ROW_NUMBER versus TOP N

SQL Server 2017 – Smart Differential Backup

Hello Friends,

SQL Server 2017 CTP announced with lots of new features to help database professionals. One of that feature is Smart Differential Backup i.e. exposing the modified extent page counts. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post we […]

By |May 6th, 2017|Categories: Backup, Restore and Recovery, Database Administration, SQL Server|Tags: , |Comments Off on SQL Server 2017 – Smart Differential Backup

SQL Server 2017 – SELECT INTO on FileGroup

Microsoft has announced SQL Server 2017 CTP version with lots of new features and improvements as compare to previous version i.e. SQL Server 2016. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post we will learn about the new feature […]

By |May 5th, 2017|Categories: Database Development, Programming, SQL Server, Transact-SQL|Tags: , |Comments Off on SQL Server 2017 – SELECT INTO on FileGroup

SQL Server 2016 – USE HINT without having SA permission

Hello Friends,

Trace Flags are really important considerations in SQL Server where we wants to change some default behavior at instance level or query level. If we want to enable the trace flag globally then we can enable it for the instance level. We can also use the trace flags at specific query level as […]

By |April 17th, 2017|Categories: Security and Encryption, SQL Server|Tags: , |Comments Off on SQL Server 2016 – USE HINT without having SA permission

SQL Server 2016 – sys.dm_db_incremental_stats_properties for Incremental Stats

Hello Friends,

During various troubleshooting scenarios, we generally check the statistics information on the objects. These statistics information helps us a lot to detect the root cause. There is a DMF that we use to check the statistics information i.e. sys.dm_db_stats_properties. This DMF requires the object id and stats id to return the details.

SQL Server […]

By |April 7th, 2017|Categories: Database Administration, Database Development, Indexes & Statistics|Tags: , |Comments Off on SQL Server 2016 – sys.dm_db_incremental_stats_properties for Incremental Stats

SQL Server 2016 – Two things developers should know

Hello Friends,

There are lots of new features and improvement launched by Microsoft in SQL Server 2016. There are two small but really interesting things for the T-SQL Developers, DBA Developers who are involve in writing T-SQL code.

Situation: Let’s think about a situation where we are creating a new object (for example –  Stored Procedure) […]

By |April 3rd, 2017|Categories: SQL Server, Transact-SQL|Tags: , |Comments Off on SQL Server 2016 – Two things developers should know

SQL Server Trace Flags Information in Execution Plans

Hello Friends,

SQL Server trace flags are important consideration for a query plan compilation and execution. Trace flag can impact the execution of a query and might hit the performance badly if not used appropriately. Sometimes during performance troubleshooting by using execution plan is not easier because we don’t have the information about the trace […]

By |March 14th, 2017|Categories: Performance Tuning|Tags: , |Comments Off on SQL Server Trace Flags Information in Execution Plans
Newsletter_Footer