Read our high-quality articles on SQL Server development. Learn how to efficiently develop data processes in the world’s biggest DBMS, that is SQL Server.
On September 19, 2009, I delivered a session with topic the Microsoft Sync Framework, during the Mysore SQL Server Community Series. The exact topic was: “Flexible data synchronization with Microsoft Sync Framework”. Further below I provide a short review for my session and I also provide the PowerPoint presentation along with the source code (C#) … Read more…
On September 2, 2009, I had the pleasure to deliver a session on ADO .NET Data Services, during that great SQL Server Marathon; 24 Hours of PASS! This great event was a series of 24 non-stop live, free webcasts dedicated to pure SQL Server knowledge. The exact topic of my session was: “Building Flexible Data … Read more…
Hi friends, in this article, we will be discussing about computed columns in SQL Server and see some relevant T-SQL examples. What are Computed and Persisted Columns in SQL Server? When it comes to database design in SQL Server, it is always recommended to create the database as flexible as possible. SQL Server provides … Read more…
This article, discusses the usage of the “GO” command in SQL Server. But before proceeding with explaining GO, it is first necessary to understand what a “Batch” is. What is a “Batch” in SQL Server? As described in MSDN BOL, a Batch is a group of one or more Transact-SQL statements sent at the … Read more…
Along with the new data types DATE, TIME and DATETIME2 in SQL Server 2008, new and enhanced functions are also included. New Date Functions Added in SQL Server 2008 and Later The new data functions originally added in SQL Server 2008 are : SYSDATETIME SYSUTCDATETIME SYSDATETIMEOFFSET SWITCHOFFSET TODATETIMEOFFSET A more thorough explanation follows: SYSDATETIME This … Read more…
Many people ask: “Where are temporary tables stored in SQL Server?” and that’s a very good question. There are many cases where we need to create temporary tables in SQL Server and for various reasons. Such reasons may include: Breaking the logic of a large and complex SQL Statement in smaller portions of code. Increase the … Read more…
In this article, we will be discussing about manipulating EXCEL 97-2003 worksheets with the OPENROWSET command. About the OPENROWSET Command SQL Server provides among other the neat feature of the OPENROWSET command. OPENROWSET allows establishing ad hoc connections using OLE DB. It actually allows one-time access to remote data from an OLE DB data source. If … Read more…
In this article, we will be discussing about the “Divide by zero error encountered” error message in SQL Server. About the “Divide by zero error encountered” error message Well, as the error message says, whenever we have a division within a SQL query and the denominator has the value of zero (0) we get this … Read more…
There are many times were we need to handle NULL and “empty” values in SQL Server. Note however, that there is a difference between a NULL and an “empty” value. In this example we will examine the above cases and ways of handling it, when developing data processes in SQL Server. Create a Sample … Read more…
There are many times where a query may result to the following error: String or binary data would be truncated. The statement has been terminated. We will go through a simple example for explaining this behavior. Reproducing the “String or binary data would be truncated” error Creating the Sample Table Consider the following table: CREATE TABLE … Read more…
In this article, we provide a list of commonly used string functions in SQL Server. By combining these functions, it is possible to easily manipulate strings. For each function, we provide useful examples, that can help you better understand these functions’ usage. REPLICATE This function given a string and an integer N, it repeats … Read more…
At some time today, I had to compare the indices of various database tables. To this end, I needed a fast way of getting index information for specific tables. In SQL Server, there is a system stored procedure (stored in the master database) called sp_helpindex. The syntax for using it is the following: EXEC sp_helpindex … Read more…
Hi friends, this article discusses the “Backup Compression” feature in SQL Server. About Backup Compression in SQL Server How many times have we backed up a database and then we have tried to minimize the size of the backup set by compressing it with an archiving utility? I am quite sure that such cases … Read more…
This article discusses about Grouping Sets in SQL Server 2008 and later. Read below to see how you can work without and how you can work with Grouping Sets in order to understand the benefits of this cool feature. Consider a database table containing sales data. The name of the table is dbo.[sales] Example without using … Read more…
In this article, we will talk about Row Constructors in SQL Server, which was originally shipped with SQL Server 2008. Inserting Records to a Table Prior to the Row Constructors Feature There are many cases were we just want to insert some data to a table. The traditional ways of doing that in SQL … Read more…