This example demonstrates how to perform a pivot using dynamic headers based on the row values of a table. The article also shows how to pass a temp table variable to a Dynamic SQL call.
2017-08-04 (first published: 2015-10-22)
13,026 reads
Knowing the various types of joins can greatly expand your T-SQL skills. Jambu Krishnamurthy brings us a refresher article on the various types of joins and how to write them.
2008-03-26 (first published: 2007-04-24)
19,098 reads
Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.
2008-03-25 (first published: 2007-04-12)
9,911 reads
SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server
2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.
2008-02-08 (first published: 2007-03-22)
17,607 reads
While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.
2007-12-14 (first published: 2006-12-19)
9,291 reads
Using data modeling tools should be something that all SQL Server DBAs involved in development use, but most of us cannot afford the tools or have the expertise to use them. Jambu Krishnamurthy brings us a new article that shows how you can use Erwin to work with your data model.
2007-12-06 (first published: 2006-12-12)
13,035 reads
New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.
2006-11-21
16,894 reads
Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting.
2006-10-30
11,311 reads
In this article I will try to justify why Table variables are superior to temporary tables.
2006-10-10
1,040 reads
A table Users contains a Create date column.A table AccessLog contains StartTime column.Both are date time fields.Users table contains one row per user and AccesLog contains as many rows as the number oftimes the user Logged into the system.The requirement is:to produce a single table that has two different COUNTs... one column will have the […]
2005-10-06 (first published: 2005-09-16)
1,554 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
No person would create the situation that a eye-catching video game of basketball was...
The Fresh Orleans Saints are shed the playoffs for the 3rd instantly time, which...
Ravens quarterback Lamar Jackson out for to start with preseason activity; Arthur Maulet out...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers