-
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
-
The SQL Server Management Studio (SSMS) continues to fascinate me with it’s immense wealth of features geared towards developer & administrator usability. What’s more amazing is that some features perform multiple useful functions depending upon the context. Today, we will have a look at one such...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-01-2012
Filed under:
Filed under: Development, Administration, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Series
-
The SQL Server Management Studio is truly an Integrated Development Environment. There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels. The graphical designers are a set of utilities, which allow one to perform basic SQL Server development...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-29-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Guidance, DBA, SSMS, Tools and Utilities, Community, Series
-
As a DBA we often need to get information on various Queries, One of them is how expensive it is. A query can be judged as expensive on various criteria’s like Long Running, Memory Utilization, CPU utilization etc. I came up with this Stored Procedure which gives you Expensive Queries based on criteria...
-
Purging your MSDB Job History is sometime very important which helps you read the Jos history in GUI very easily and keeps which only required number of days. You can add this in your Maintenance Plan or using a SSIS Package. I found one of the way a Stored Procedure to do the same. This Procedure accepts...
-
More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. Even SQL Server 2000 provided basic debugging ability. Starting Microsoft SQL Server 2005, the product now comes with it’s own Management Studio...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-22-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Series, Debugging
-
Per Books-On-Line, The Microsoft SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. The SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-15-2012
Filed under:
Filed under: Development, Administration, Tips, SQL Server, #SQLServer, #TSQL, Guidance, SSMS, Tools and Utilities, Community, Series
-
The properties and behaviour of each session to a SQL Server instance can be handled individually via use of various SET options . As we multi-task during the day, we tend to forget the exact SET options that we choose for a particular user session. The focus of the day is how to retrieve this information...
-
Performance tuning & analysis during new development has it’s own unique challenge – on one hand as database developers, we need a clean procedure cache and on the other hand, we do not want to impact the performance of other databases on the same instance. To start from a cold procedure cache, we...
-
Recently at the office, we ended up discussing the BIT data type ( http://msdn.microsoft.com/en-us/library/ms177603.aspx ). While we all understand that BIT is supposed to represents a Boolean value, we were not quite convinced. Boolean values are two-state – they can only be TRUE or FALSE (or 1 and...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-04-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, Tools and Utilities, Debugging
-
The below scripts will help us to determine the list of columns present in a table , their datatype and size along with whether it is identity/computed or not Solution 1 Select [Table Name] = so.name ,[Column Names] = sc.name ,[Data Type] = st.name ,[Size] = sc.length ,[Is Identity] = Case When sc.status...
-
This post is really inspired by Nakul's wonderful post: http://beyondrelational.com/blogs/nakul/archive/2011/12/29/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx However, Whenever I faced a situation to concatenate the values in a table there was always a requirement...
-
The basic testing results of TSQL Challenge 71 - Play mangled words game in TSQL is published and you can find it here .
-
It is often a requirement to split a set of contiguous string into individual characters/letters. The below code will help us to do so Declare @str Varchar(50) = 'abcde' Select Data = Substring(@str,Number,1) From master.dbo.spt_values where Number Between 1 And Len(@str) And Type='P'...
-
I work with academia frequently, and therefore, get a chance to interact with students and experience the issues they face first hand. I recently had a very interesting experience during one of these visits. I will try to present the experience as a story. The Problem One of the students had developed...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-01-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, Community