Nitin Rana

Nitin is a Microsoft Certified Professional and currently has over 12 years of IT experience under his umbrella. He is currently working as SQL Architect at Wachovia Securities in New York City. Nitin has an extensive knowledge in maintaining VLDB (more than 3-4 TB) and is very proficient in SQL server core components such as Indexing, Performance Tuning, Partitioning and so on. He has worked at various pristine clients in the continental United States helping the clients to reach a stable stage in their database platform. Nitin also has extensive experience in ASP, Power Builder, SSAS, SSRS to name a few.

Articles: 2

Views

Granting View Definition Permission to a User or Role in SQL Server

In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function. Sometimes this is helpful to allow developers or other non-adm

Nitin Rana
December 31, 2024

Partitioning

Manage Multiple Partitions in Multiple Filegroups in SQL Server

SQL Server Books Online (BOL) suggests that in order to clean up old partitions from a partition table, you should either issue a DELETE or SWITCH command. BOL also suggests that while SWITCHING partitions, you should set up a NON PARTITIONED TABLE in the

Nitin Rana
May 10, 2026