-
The basic testing results of TSQL Challenge 79 - Finding the Islands is published and you can find it here .
-
The basic testing results of TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals is published and you can find it here .
-
I was playing with entity framework in recent days and I was searching something that how we can execute TSQL statement in entity framework. And I have found one great way to do that with entity framework ‘ExecuteStoreQuery’ method. It’s executes a TSQL statement against data source given enity framework...
-
The basic testing results of TSQL Challenge 78 - Parse single field into multiple fields is published and you can find it here .
-
Just published a sandbox for the basic testing of TSQL Challenge 78 - Parse single field into multiple fields . http://beyondrelational.com/puzzles/tsql/challenges/78/basic-testing-sandbox.aspx
-
It's time for a change. This website, BeyondRelational.com , is rolling out a new Blogs module with improved features, feedback and social opportunities. All 146 of my posts have been moved to the new location: http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx?tab=default . All future...
-
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...
-
In an XML structure, the multiplicity of a node defines how many times that node can appear. In the following example the data from 4 columns in one row in a table will be exported in a XML node with multiplicity of 4. Two methods of export will be shown, both use FOR XML clause and the second will use...
-
Few days before i have a requirement to find out the table name which are having a specific column with a specific value throughout the database. for that i build a query which takes <COLUMN NAME> and <VALUE> as parameter For example : A column <Col1> occurs in multiple tables in a...
-
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
-
In November 2011, I wrote a post titled SQL Server – Performance – Best Practice – Create Index Before or After a data insert? . The post dealt with answering the question - which method was better – whether to create an index before or after a bulk-insert? The post was essentially targeted to code that...
-
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 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