Monthly Archives: June 2014

Incremental statistics – New feature in SQL Server 2014

Incremental Statistics is one of the new feature added in SQL Server 2014, let us have a quick look to understand this feature! Statistics is one of the important criteria to be validated during performance analysis as improper statistics directly … Continue reading

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

Data Profiling Task / Data Profiling Viewer

Data Profiling is one of the options for data analysis, this also helps to identify few data specific problems. This is one of the interesting option to explore while analyzing the data… an XML can be generated only using SSIS … Continue reading

Posted in SQL, SSIS | Tagged , | Leave a comment

Knowledge Share 2014-06

• Can I change SQL Server Name/ Instance Name: o Yes, you can change SQL Server name. Especially when you rename your server name, it is good option to change your SQL Server name. o http://msdn.microsoft.com/en-us/library/ms143799.aspx is the article which … Continue reading

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

A required privilege is not held by the client. The step failed. – SQL Job Fails with error – Solution

I was aware of the best practice to use SQL Server Configuration Manager instead of using MMC Console but faced this error for not following the best practice. Well, I had to change the Logon account of my SQL Server … Continue reading

Posted in SQL, SQL Error, Windows Server | Tagged , , , | Leave a comment

How Statistics impact the performance of SQL Query

In this article I will run through a simple demo which explains how STATISTICS impact the performance. During this Demo, I will use the Number of Logical Reads as performance indicator (More Logical Reads indicates Performance Degrade) Created a new … Continue reading

Posted in Performance, Script, SQL | Tagged , , , , , , | 1 Comment

Kill windows process only if it is running – using tasklist, taskkill together – DOS Command

During maintenance activities at times we need to kill a process/task only if it is running. it is a little complex to identify when the process/task is running. Following simple script helps to do so in command prompt or batch … Continue reading

Posted in commands, Productivity, Script, Windows Server | Tagged , , , , | 1 Comment

SET STATISTICS IO ON; SET STATISTICS TIME ON – performance tuning

SET STATISTICS IO ON and SET STATISTICS TIME ON are beautiful ways which can be used while performance tuning individual queries. SET STATISTICS IO ON Enabling STATISTICS IO is very informative as it displays Scan count, logical reads, physical reads, … Continue reading

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