Bring Array Mapping Capabilities to SQL
Simplify your SQL tasks by giving your queries and stored procedures the ability to iterate over arrays of table names or values.
SQL Server 2008 New DATETIME DataTypes
SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.
Hipp, Hipp, Hooray
In an age where commercial interests seem to trump all, it's nice to see someone delivering content out there for free.
TinyInt, SmallInt, Int and BigInt
SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.
Toward Integrity - Part 2
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
Relational Databases 101
In this sample chapter, William R. Vaughn gives you a kick-start on designing relational databases that can perform better, be easier to maintain, and be more successful thanks to a combination of formal rules and informal suggestions to normalize your database.
TSQL Regular Expression Workbench
This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn't even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don't already use Regex with SQL Server.
All I Want For Christmas Is ...
What do IT workers want for Christmas? Let us know in this Friday's poll.
Performance Effects of NOCOUNT
Most SQL Server programmers know to use the SET NOCOUNT command to prevent the number of rows message from being returned to the client. But how does this affect performance? Does it make sense to qualify the owner on your objects? SQL Server guru David Poole brings us some performance analysis of how your stored procedures perform.
Best Practices for Credit-Card Software
Visa has developed Payment Applications Best Practices and will begin implementing mandates concerning them
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers