preloader

khansqlserver@gmail.com

Archives: Portfolios

description

Case Study 1

Case Study 1

Case Study 1 Inserting bulk data from text files into SQL Server and creating database objects such as tables and its data, dynamically. All the folders in text files are looped and represented in the form of tables. Use of Command Shell and Format Files in SQL Creating UDFs for.

Case Study 2

Case Study 2

Case Study 2 Creating Employee-Manager Hierarchy. Creating recursive stored procedure. Usage of NESTLEVEL() System Function. Building indexes for query optimization and performance tuning

Case Study 3

Case Study 3

Case Study 3 Creating an Archive table dynamically and segregating old data from the current base table data through lookup tables. Synchronous manipulation and transactions of data in Archive and Base table. Scripting T-SQL code for data validations and data integrity.