Browse by Tags
All Tags »
T-SQL (RSS)
Sorry, but there are no more tags available to filter with.
After a bit of delay I'm back with the last installment of SQL Basics. I planned to write this blog several times over the last few days but to be honest I had other interests. My daughter said her first words this week, which just happened to be "dada",
Read More...
We are in part two of our four part series around basic operations in TSQL. Today we will be finding tables based on certain criteria. Here are a couple I will show: Finding table names matching a string Finding tables containing a certain
Read More...
I have decided to step away from the SQL 2008 CTP for a bit and post a couple items that keep coming up. I have been spending more time in the MSDN Transact SQL forums and have noticed a consistent stream of questions around some basic operations
Read More...
I'm going to spend the next few posts discussing how you can implement partitioning in SQL Server 2005 to improve the performance and maintenance time of very large tables. In previous versions of SQL Server it was possible to partition data by physically
Read More...
I've seen this question or something similar in many places recently in regards to the XML data type that was introduced in SQL Server 2005. I've been using XML with SQL Server for a while, going back to SQL Server 2000, and was very pleased with
Read More...
Transact-SQL (T-SQL from here on) has many unheralded functions that can make your life easier if you only know of their existence. Today I'm talking about the NULLIF, QUOTENAME, and PARSENAME functions. These functions are great for string
Read More...