Monthly Archives: August 2014

TSQL to Rollup multiple rows into single row and column

In my team, we mange multiple Applications and Servers. As part of Application migrations, Server consolidations, failovers application Server mapping will always be changing. I always depend on Application Server mapping during analysis but my major challenge was with multiple … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment

Access to run SQL Profiler/Trace – Minimum access

If you need to provide access to someone only to run SQL Profiler SQL Trace you need to Grant ALTER TRACE permission. This feature is introduced in SQL Server 2005… – Permissions to run SQL Trace Reference: http://msdn.microsoft.com/en-IN/library/ms187611.aspx -Vijred

Posted in Productivity, Referene, Script, SQL, SQL Query | Tagged , , , , , , | Leave a comment

Identify and delete duplicate records in a table – SQL

One of the best option is to use CTE, ROW_NUMBER() to identify and delete duplicate records Sample Code/Demo: Note: If one of the column is of type NText, will not be able to sort based on the column and it … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , | 1 Comment

Interesting facts about SQL Server 2014 Memory optimized tables and Natively compiled stored procedures

  Stored Procedures that reference only memory-optimized tables can be natively compiled into machine code for additional performance improvements Only one MEMORY_OPTIMIZED_DATA Filegroup can be created on each database In Memory OLTL is Lock and Latch Free In-Memory OLTP is … Continue reading

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , | Leave a comment

Find SQL Server version

@@Version can be used to find SQL Server version. You can also use few system variables to find additional information as follows  

Posted in Script, SQL, SQL Query | Tagged , , , | Leave a comment

Extend Laptop display to Monitor but on different direction

I know most of you have been using this this feature but had to do more research for simple customization. In my work location I had to arrange my additional Monitor on left side. By default, My Windows-7 Laptop assumes … Continue reading

Posted in Network, Productivity, Referene, Useful Link | Tagged , , , | Leave a comment

Insert Stored Procedure results into a table

Basically we have 2 options to push Stored Procedure results. 1. If you do not know the schema and you may need to generate the schema during run time. NOTE: You may not be able to use above solution in … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , | 1 Comment