-
It is very important to keep revisiting one’s code – especially, when the underlying platform changes or when teams start using newer features within legacy code. Until SQL Server 2005, the typical understanding of the keyword “DECLARE” was that it had only one meaning – it was used to define an object...
-
Often, students and colleagues come up to me and enquire how do they get started learning about some of the newest technologies. They generally do not seem to have issues with getting the study materials (most common study materials are the many blogs on the Internet and MSDN documentation). The one...
-
Today my friend asked me that ISNUMERIC function is not working properly. I checked, the issue was with some special char, might be MSSQL will improve this functionality in coming versions. For now, if we change the way of calling, it will show you the correct result. These conditions shows wrong result...
-
In the previous part of this tutorial , I demonstrated the procedure to create & customize the SqlDiag.xml for use with the SQLDiag utility. I began by going through the manual editing process, followed by the graphical utility - SQLDiag Configuration Tool – from CodePlex . Today, in the final part...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
03-14-2012
Filed under:
Filed under: Development, Administration, Performance Tuning, Tips, SQL Server, #SQLServer, Best Practices, Guidance, DBA, Tools and Utilities, Series, Debugging
-
In one of the earlier parts of this tutorial series ( Part 06 ), I had demonstrated how to correlate the SQL Profiler trace with the Windows Performance Logs. I had used two utilities for the demonstration – the SQL Server Profiler and the Windows Reliability & Performance Monitor. In Part 07 and...
-
Today one of my friend ask me, can we use Order by clause dynamically ? I said yes, but there are few limitations while using case in order by clause see the below example. This script will return Error: DECLARE @TOP INT = 10, @FLD VARCHAR(20)='AGENT_ID' SELECT TOP(@TOP) * FROM ( SELECT 1 AS...
-
In my previous post in this tutorial ( here ), I introduced the system stored procedures that would allow us to create a SQL Trace, define events and data columns to capture and start the trace using nothing but pure T-SQL code. Today, we will see the following: How to use the graphical Profiler to generate...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
03-07-2012
Filed under:
Filed under: Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series
-
For those who have been following my posts, you would recollect that I had run a 6-part series on SQL Profiler tutorials some time ago. Based on the feedback received, I am now presenting a 4-part extension to the series. In this part, I will describe how the capturing of a SQL Trace can be done in an...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
03-04-2012
Filed under:
Filed under: Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Series
-
Recently, I was working with a developer colleague of mine to troubleshoot an issue he had with one of his queries. A stored procedure he wrote was consuming data from another procedure and was not functioning as expected. I suspected the issue to be a missing change in the related stored procedure....
-
I recently had the opportunity to view some of the newest courses from Pluralsight , an organization that offers online training courses for developers. One of the courses that I viewed was the SQL Server Questions & Answers ( http://www.pluralsight-training.net/microsoft/Courses/TableOfContents...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-22-2012
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Myths
-
As you know, I recently completed a 10-part tutorial series on the SQL Server Management Studio (SSMS). As I finished writing the tutorial, I remembered that one of the issues most SQL Server developers encounter are the slow load times of the SSMS. Sometimes, SSMS is just not fast enough for a quick...
-
All systems are susceptible to failure. No software is perfect, and therefore it is natural that SSMS too will fail. Today, I have put together some of the most common failures that I have experienced with SSMS and their known workarounds. The reason I have kept this part of the tutorial as a L200 is...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-15-2012
Filed under:
Filed under: Development, Administration, Tips, SQL Server, #SQLServer, Guidance, SSMS, Tools and Utilities, Community, Series, VTD
-
As mentioned in Part 01 of this tutorial series, one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise Manager – the interface that is used to manage & maintain the SQL Server instance configuration. In addition to the tools and utilities available within the...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-12-2012
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series, Debugging
-
One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. In Part 01 of this tutorial series, I had mentioned that one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-08-2012
Filed under:
Filed under: Development, Administration, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series
-
The SQL Server Management studio contains many pop-up utilities and tools that help in improving the productivity of our day-to-day database administration and maintenance tasks. While most of these would be implemented using T-SQL code in production, these tools & utilities are a great way to get...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-05-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series