Click here to Skip to main content

Submit your article

SQL Server 2005

SQL-Server-2005

Great Reads

How to Set Default Value or Binding for BLOB DataTypes on SQL Server

by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

AJAX-enabled Name Selector User Control

by Steve Krile

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

Notification of Silverlight Applications about Database State Changes

by Max Paulousky

This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.

Latest Articles

SQL - Pivot with Grand Total Column and Row

by Narapareddy Shyamprasad

SQL Dynamic Pivots

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

Use RegEx in SQL with CLR Procs

by JasonShort

Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code? You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!

Code Review Checklist

by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

All Articles

SQL Server 2005

SQL Server: Applying Filter on sp_MSforeachDB

16 Sep 2012 by aasim abdullah

How to apply filter on sp_MSforeachDB

SQL-Server-2008

SQL-Server-2005

SQL Server: Controlling SQL Server Log Information

15 Sep 2012 by aasim abdullah

How to control SQL Server Log Information

SQL-Server-2008

SQL-Server-2012

SQL-Server-2005

SQL Server: Script to Generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space

17 Sep 2012 by aasim abdullah

SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space

SQL-Server-2008

SQL-Server-2005

SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem

17 Sep 2012 by aasim abdullah

Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.

SQL-Server-2008

SQL-Server-2005

SQL Server: Smarter Way of Query Load Testing at Testing Server

17 Sep 2012 by aasim abdullah

Smarter Way of Query Load Testing at Testing Server

SQL-Server-2008

SQL-Server-2005

SQL Server: Placing Alert for Compatibility Level Change in SQL 2005

22 Oct 2012 by aasim abdullah

In SQL Server 2005, there is no way to find out WHO AND WHEN someone changed the compatibility level of a database. Here is a trick for this functionality.

SQL-Server-2005

Adding Items in Comma-separated String into Separate Rows in SQL Server

2 May 2013 by Amogh Natu

This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.

SQL-Server-2005

Resource: Brad's Sure Guide to SQL Server Maintenance Plans

17 Aug 2012 by Bryan O'Connell

Review of the ebook: Brad's Sure Guide to SQL Server Maintenance Plans.

SQL-Server-2008

SQL-Server-2005

Query Plan Caching - My SQL Server Nightmare

30 Apr 2012 by Martin Thwaites

If you have an issue with a slow part of a site after a large dataload, that you can't replicate after a DB restore, it's likely you could be dealing with a similar issue.

SQL-Server-2005

Generic Repository Pattern MVC

29 Apr 2016 by Mayur V Lohite

Generic Repository Pattern MVC

SQL-Server-2005

SQL-server-2000

SQL Server 2005

23 Dec 2009 by puri keemti

SQL Server 2005

SQL-Server-2005

.NET 4.0 MemoryCache with SqlChangeMonitor

15 Jun 2012 by Rick Bassham

How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.

SQL-Server-2005

SQL-server-2000

How to Multicast messages with SQL Server Service Broker

22 Jul 2011 by rusanu

How to Multicast messages with SQL Server Service Broker

SQL-Server-2008

SQL-Server-2005

WCF: Loose coupling of WCF Service and Data Contracts

1 Feb 2010 by Sky Sanders

A strategy for implementing maintaining separation of concerns and implementation hiding.

SQL-Server-2005

Auto-incremented ID with NVARCHAR/VARCHAR datatype

19 Jul 2012 by Tejas Vaishnav

Auto incremented ID using VARCHAR data type

SQL-Server-2008

SQL-Server-2005

Counting Consecutive Dates Using SQL

17 Feb 2013 by Tharaka MTR

How to count consecutive dates using SQL

SQL-Server-2008

SQL-Server-2012

SQL-Server-2005

How to Fix Orphaned SQL Users

26 May 2013 by Tharaka MTR

This post will show you how to fix orphaned SQL users.

SQL-Server-2005

SQL-server-2000

Generate insert Statements from a Specific Table Data using SQL Server

27 May 2013 by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

SQL-Server-2008

SQL-Server-2005

Sql Server - How To Write a Stored Procedure in SQL Server

12 Nov 2010 by Vivek Johari

Stored Procedure in SQL Server can be defined as the set of logically group of SQL statement which are grouped to perform a specific task. This article will describe the Stored Procedure in SQL Server and their benefits.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

How to Find Duplicate Values in a Table

16 Nov 2010 by Vivek Johari

This article will try to show how to find duplicate values in a table.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Introduction to SQL Server Views

16 Nov 2010 by Vivek Johari

Introduction to SQL Server Views

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Different Ways to Create a Table and Insert Data into the Table

17 Nov 2010 by Vivek Johari

Basic information about the different ways of creating a table

SQL-Server-2005

SQL-Server-2008

SQL-server-2000