SQL Server 2008

SQL-Server-2008

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.

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

Zip Rendering Extension for SQL Server Reporting Services 2005/2008/2012

by Harmen Brouwer

How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.

Rename a Database and its MDF and LDF files in SQL Server

by Tecfield

This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Latest Articles

Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!

by Mubin M. Shaikh

Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format

SQL Browser

by Alaa Ben Fatma

Explore your MMSQL server tables in a professional way

Security on the Web by Advanced Encryption Standard (AES) and Security Assertion Markup Language (SAML)

by Mahsa Hassankashi

Best approach for having more secure channel to transfer user information throughout the web

Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation

by Mahsa Hassankashi

This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.

All Articles

top

SQL Server 2008

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

15 Jan 2013 by Wonde Tadesse

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

SQL-Server-2005

SQL-Server

SQL-Server-2008

SQL-server-2000

Create & Populate Time Dimension with 24 Hour+ Values

5 Sep 2013 by Mubin M. Shaikh

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

Rename a Database and its MDF and LDF files in SQL Server

13 Mar 2012 by Tecfield

This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Copy/Synchronize Table Data between databases

16 Mar 2012 by Anurag Gandhi

A Query to copy an individual table data between databases

Read a file using transact-sql.

8 Jul 2010 by Md. Marufuzzaman

How easy to read a file without using of the seven extended stored procedures.

Passing Object Collections to ASP.NET Web API

16 Jan 2014 by Tom Glick Philadelphia, US

POC to demonstrate passing of collections of complex objects to ASP.NET Web API Controllers.

MyMDb your local IMDB store

22 Jul 2013 by Paw Jershauge

Want your own movie database??? Download IMDB in 20 minutes.

Get Top X rows from a table

23 Feb 2012 by Mahmud Hasan

How to use variable in SELECT TOP SQL command

Steps to install Microsoft SQL Server 2008 Express Edition (Standard or with Advanced Services)

9 Aug 2011 by Jesus Carroll

This brief article show how to install quickly Microsoft SQL Server 2008 Express Edition Standard or with Advanced Services

SSIS: Load Data in Dimension Table by Merge Join

13 Jan 2013 by mparvez

How to load data from an Excel file to load in a dimension table in an incremental way.

Entity Model to Excel using LINQ in C#

31 Oct 2013 by Debopam Pal

How to bring data from Entity model to Excel file using LINQ.

SQL Server: How to Get All Indexes List With Involved Columns Name

17 Sep 2012 by aasim abdullah

Get all indexes list in detail, with their involved columns

How to Split Microsoft SQL Server Table Row Data

18 Dec 2015 by Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

A simple method to measure execution time in SQL Server

31 Oct 2016 by Chris Maunder

Timing SQL calls with millisecond accuracy

SQL-Server-2008

SQL-Server

Use of columns belonging to tables referenced on main query in a subquery

17 Feb 2011 by John Gathogo

Catastrophic results associated with unqualified use of columns belonging to tables referenced on main query in a subquery

List blocking processes in SQL server

11 Oct 2011 by Chris Maunder

A quick script to enable you to find the processes that are blocking in SQL server

SQL

SQL-Server-2008

SQL-Server

MS SQL Scripts Runner

4 Apr 2012 by sluaghtered

Script Runner that can run multiple SQL script files on MS-SQL.

How to update a row with another row if column values are null in SQL

17 Aug 2012 by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

SQL Server: How to Refresh Intellisense Cache

20 Oct 2012 by aasim abdullah

How to Refresh Intellisense Cache in SQL Server

SQL-Server-2008

SQL-Server

Microsoft SQL System View Version Map

13 Dec 2012 by Paw Jershauge

MS SQL system views, mapped over version.

TIP: Managing SqlGeography class from C#

4 Sep 2010 by Jaime Olivares

How to Insert or Update an SqlGeography object in SQL Server 2008 from a C# application

SQL-Server-2008

SQL-Server

SQL Server: Changed data capture without using Triggers

23 Oct 2012 by aasim abdullah

How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.

SQL Server : How to Keep Database Restore History

24 Oct 2012 by aasim abdullah

Backup and then restore of a database is a normal job for developers and DBAs. This script will be helpfull to findout, from which path, and which backup file a database was restored.

Run All Subscription Reports At Once in SSRS Manually

5 Sep 2013 by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

Introduction to Named Query in Sql Server Analysis Services

29 Sep 2013 by Mubin M. Shaikh

Create Named Query in Data Source View While Designing OLAP Cube in SSAS

Create CSV File in Microsoft SQL

27 Jan 2017 by Rajesh_K_Sharma

How to create CSV file in SQL

SQL

SQL-Server-2008

SQL-Server

Dequeue workitems using MERGE

25 Feb 2014 by Darek Danielewski

This article demonstrates how to safely dequeue items from a shared table

Pay Attention to What "Script...To" Generates

22 Sep 2017 by #realJSOP

It doesn't always happen the way you expect.

Use SQL to generate large data sequence

19 Feb 2015 by DrABELL

Generate large data series by using Cartesian Product and small data table

Trailing spaces are ignored in SQL Server 2008

23 Jun 2011 by zvin

When comparing data stored in databases, you don't need to use RTRIM()

SQL-Server-2008

SQL-Server

SMO 101 - Getting all DB's

17 Aug 2011 by bmckuhen

How to get a quick list of all DBs using SMO

Execute SQL Query / SQL Command on SQL Server Using the Command Prompt

25 Jan 2012 by IkhwanKrisnadi

How to execute SQL Query / SQL Command on SQL Server using command prompt.

SQL-Server-2008

SQL-Server

List SQL Server table column name as rows

2 May 2012 by Chamila Nishantha

Simple query to get table column name as rows

SQL

SQL-Server-2008

SQL-Server

Create job to export Stored Procedure daily

27 Nov 2012 by Aadhar Joshi

Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.

Inno Setup Script to Install SQL Server 2008 R2 with Tools

1 Dec 2013 by RickZeeland

Inno Setup script to install SQL Server 2008 R2 with Tools, creating an instance with special rights and displaying the log.

Pivoting on SQL Server Varchar Data Types

22 Feb 2016 by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

Beware of empty Table-valued Parameters

5 Mar 2010 by Heino Zunzer

The possibility to build stored procedures with table-valued parameters is a great new feature in SQL Server 2008, especially if utilized with the also newly implemented MERGE-command. Alas, there are some restrictions (TVPs have to be bound to a User-defined Table Type, have to be passed as...

SQL-Server-2008

SQL-Server

Split function

5 Jun 2010 by db_developer

Split User Defined Function, MS SQL Server 2008

SQL

SQL-Server-2008

SQL-Server

String splitting/tokenizing using T-SQL user defined function.

8 Feb 2011 by Irfan Baig

String splitting/tokenizing using T-SQL user defined function.

SQL-Server

SQL-Server-2008

SQL-Server-2005

List blocking processes in SQL server

15 Oct 2011 by Chris Maunder

Here's an alternate version that doesn't use sp_who yet provides a little more information. It also provides the option to kill the blocking processes themself.IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ListBlocking]') AND type in (N'P', N'PC'))EXEC...

SQL

SQL-Server-2008

SQL-Server

Find Missing Date Ranges in SQL Server

10 Feb 2012 by Ramanujam Shankar

Find missing date periods from a table.

Concatenate many rows into a single text string using SQL Server 2008

25 Feb 2012 by e-Lopes

How to concatenate many rows into a single text string using SQL Server 2008.

Concatenate many rows into a single text string using SQL Server 2008

23 Feb 2012 by PIEBALDconsult

See also Stupid CTE tricks -- string concatenation[^]

List SQL Server Table Column Name as Rows

6 May 2012 by Wendelius

This is an alternative for "List SQL Server table column name as rows".

SQL

SQL-Server-2008

SQL-Server

SQL Server: Keeping Log/Alert for Job Disable/Enable Status

1 Oct 2012 by aasim abdullah

How do you know, if someone disabled your job at production database server. Who is the calprit. How to send a mail alert for this change ??

SQL Server: Automatic Query Execution at Every Instance Startup

19 Apr 2013 by aasim abdullah

Automatic query execution at every instance startup.

Generating and Splitting a Delimited String Column

17 Jan 2013 by Tharaka MTR

This article describes the easiest way to create and process delimited row using SQL XQuery.

SQL Server StringPadding (String function)

24 Apr 2013 by Surender Singh (CodeToastDev)

Custom StringPadding functions for SQL Server

Setting deadlock priority in SQL Server

19 Sep 2013 by Saral S Stalin

Explains how to run a script with higher priority to avoid it getting terminated in a deadlock situation.

Auditing Failed Logins in SQL Server: Looking Beyond Post-event Analysis

23 Sep 2014 by SatyLepide

By analyzing log-in attempts on SQL server, admins can build the complete picture out of the sequence of events that led to compliance failure or unauthorized access.

String splitting/tokenizing using T-SQL User Defined Function

21 Jan 2016 by smirson

This is an alternative for "String splitting/tokenizing using T-SQL user defined function."

SQL-Server

SQL-Server-2008

SQL-Server-2005

Uniqueidentifier Field Problem

2 Oct 2010 by hussain.attiya

String splitting/tokenizing using T-SQL user defined function.

14 Feb 2011 by Hajo Messner

There is a little inconsistence in this function, because the @Tokens Elements and the @Delimiter parameter are of data type NVARCHAR (=Unicode) while the @String parameter is of data type VARCHAR (=ANSI). If the @String parameter can be Unicode, it must be declared as NVARCHAR. If the @String...

SQL-Server

SQL-Server-2008

SQL-Server-2005

How to remove duplicate rows in SQL Server 2008 when no key is present

2 Sep 2011 by Ron sikander

Find out the number of duplicates in the table:select count(*), VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC from TR00.NV_STARTER_INDEXgroup by VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC having count(*)>1--- Delele them using following statementDELETEFROM TR00.NV_STARTER_INDEXWHERE...

SQL

SQL-Server-2008

SQL-Server

SQL Atomic Operation on UPDATE and DELETE

13 Jan 2012 by Robby Tendean

How to do SQL atomic operations on UPDATE and DELETE syntax.

Execute SQL Query / SQL Command on SQL Server Using the Command Prompt

3 Feb 2012 by manish76235

SQLCMD can be used to login to the Sql Server as well. One can only provide Server address, User Name and Password at the command prompt and press enter.The command prompt will change to 1>. Now any sql query can typed and by pressing enter in the next prompt a GO command and pressing enter...

SQL-Server-2008

SQL-Server

Concatenate many rows into a single text string using SQL Server 2008

25 Feb 2012 by Sanjay K. Gupta

How to concatenate many rows into a single text string using SQL Server 2008

Finding available free space in the disks of SQL Server

19 Mar 2012 by Saral S Stalin

Simple query to find the available hard disk space in the server

SQL-Server-2008

SQL-Server

List SQL Server table column name as rows

3 May 2012 by PIEBALDconsult

This is an alternative for "List SQL Server table column name as rows"

SQL

SQL-Server-2008

SQL-Server

Index and Sort Order

20 Jul 2012 by Mr. Joydeep Das

What the effects of Ordering in Index

SQL Server Management Studio: Basic Startup Options

2 Oct 2012 by aasim abdullah

Using SQL Server Management Studio, have you ever come a cross following questions: Why every time, a new query window is open with MASTER database.? On opening SQL Server Management Studio, I need a new query window automatically ?

SQL-Server-2008

SQL-Server

SQL Server Scripts: Get All Nested Stored Procedures List (Procedures with Dependent Procedures)

1 Nov 2012 by aasim abdullah

A stored procedure can be called from another stored procedure as nested stored procedure. How to get a list of these stored procedures with their nested one

SQL-Server

SQL-Server-2008

SQL-Server-2005

Another reason for getting the error “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” in MS SQL Server 2008

14 Nov 2012 by Sadeque Sharif

Another way to solve the issue of “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”

SQL - Converting a varchar parameter to a table

3 Dec 2012 by Glagace_7763

Create a table from a Varchar list value

CLR-addon for DATE and Split-String

3 Jan 2013 by Levente Kupás

CLR-addon for T-SQL DATE transformation and Split-String

Grouping dynamically on different columns in single query

4 Jan 2013 by RahulAJoshi

Grouping dynamically on different columns in single query

Generation of Dynamic Parameterised Report with DropDown List using SSRS

7 Jun 2013 by Purushotham Agaraharam

Creating a parameterised report using SSRS.

SQL

SQL-Server-2008

SQL-Server

Concatenate many rows into a single text string using SQL Server 2008

8 Mar 2012 by Ramanujam Shankar

Using COALESCE function - concatenate many rows into a single text string output in SQL Server.

Sort AlphaNumeric Data in Sql

23 Aug 2011 by Anurag Gandhi

I have gone through a lot of examples to sort alpha numeric data in sql. Here is my way:

How to remove duplicate rows in SQL Server 2008 when no key is present

20 Feb 2011 by Wendelius

This tip describes how to delete duplicate rows from a table that doesn't have a key.

SQL

SQL-Server-2008

SQL-Server

Saving Changes Is Not Permitted On SQL Server 2008 Management Studio. How To Solve?

1 Sep 2013 by IkhwanKrisnadi

How to solve when saving changes is not permitted on SQL Server 2008 Management Studio

SQL-Server-2008

SQL-Server

Import CSV or txt File Into SQL Server Using Bulk Insert.

21 May 2014 by Arvind Singh Baghel

Import CSV or txt File Into SQL Server Using Bulk Insert.

.NET WinForms ReportViewer: Non-printable Report Background (Elements)

14 Mar 2014 by Nikita D. Sinelnikov

HowTo: make the report background (elements) of Microsoft .NET Report (.rdlc) non-printable

How to find column or text in entire stored procedure of a database?

11 Nov 2013 by Rajat-Indiandotnet

Find column or Text in entire stored procedure

Uploading an Image and Displaying It on the UI Page

17 Dec 2012 by Mannava Siva Aditya

Uploading an image and displaying it on the UI page

SQL-Server

SQL-Server-2008

ASP.NET

Creating a SQL Server Database Project Use in Visual Studio 2012 and Use TFS for Version Control

8 Jun 2015 by Diluka Wittahachchige

Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS

Common Table Expression to find all related nodes

12 Nov 2013 by Jobless Creature

CTE To find all the related nodes in a hierarcy

Random Date/Time Test Data Generation

25 Aug 2016 by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

SQL Server Health Check Script with Powershell

3 Dec 2014 by Atul_Kapoor

Perform SQL Server Instance health check simultaneously on more than one server using Powershell

SQL Server - BLOB Import and Export

24 Apr 2012 by mkader

SQL scripts to insert File to BLOB field and export BLOB to File

Get accurate age by date

20 Feb 2010 by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

How to prevent SQL Injection in Stored Procedures

12 Apr 2016 by Shao Voon Wong

How to prevent SQL injection attacks when using dynamic SQL in stored procedures

How to truncate log file in SQL Server 2008

24 Jul 2013 by Kumar Pankaj Verma

Truncating log file in SQL Server using T-SQL when log file is too large and database becomes unresponsive.

SQL

SQL-Server-2008

SQL-Server

Quickest Way to Create a .NET Database Application

4 May 2012 by Subha.N

Tip to create a database application using C# .NET in the shortest time possible.

Get my database server with current database.

24 Feb 2010 by Md. Marufuzzaman

This is a very simple use of SQL Server global variables. Microsoft SQL Server provides a massive number of global variables, which are very effective to use in our regular Transact-SQL. Global variables represent a special type of variable. The server always maintain the values of these...

SQL-Server

SQL-Server-2008

SQL-Server-2005

How to get the details of Open Transaction in SQL Server

2 Sep 2010 by tarun_j200

Getting the Current Time from Any Time Zone

18 Dec 2013 by vikram.mahapatra

How to get the current time from any time zone

SQL-Server-2008

SQL-Server

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

23 Dec 2015 by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

Find text in Stored Procedures, View, Trigger, and Function

6 Jun 2013 by Nelson Kosta Souto

Find text in Stored Procedures, View, Trigger, and Function.

Find All the Days Between Two Dates

19 Aug 2013 by S.P.Tiwari

Find all the days between two dates using SQL Server

SQL

SQL-Server-2008

SQL-Server

T-SQL Function: Add a space between all characters

23 Jul 2012 by Paul M Simpson

Expanding a string by inserting alternating single spaces between characters

SQL Server Database Backup Status Report

5 Jun 2015 by Dathuraj Pasarge

Know whether your databases are backed up successfully in the last 24 hours or not !!!

Create Insert SQL Statement from the Records in an Existing Table

8 Mar 2016 by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

Rowversion: Version Stamping A Row

19 Oct 2013 by SonuKSingh

rowversion datatype in SQL Server: Track which row has been modified

ShoppingCart using Gridview in ASP.NET

13 Jun 2012 by headshot9x

How to create ShoppingCart using Gridview in asp.net with code VB

Building hierarchy using Recursive CTE

5 Jan 2011 by Hiren solanki

Building hirarchy in the sense of hirarchy of manager, employee though both are an employee of an enterprise but both are related or depend on hierarchical level.

SQL-Server

SQL-Server-2008

SQL-Server-2005

Get Tables List With Its Dependent Tables Names

15 Jan 2012 by Dhol Gaurav

Get Tables List With Its Dependent Tables Names

A Unique Feature of SQL SERVER Loop with Go Statement

10 Nov 2013 by Rajat-Indiandotnet