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

.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

C#4.0

.NET4

.NET

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

A Simple Example of Microsoft SQL Server Pad String

18 Dec 2015 by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

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

A Unique Feature of SQL SERVER Loop with Go Statement

10 Nov 2013 by Rajat-Indiandotnet

A unique feature of SQL SERVER Loop with Go statement

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…”

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.

Auto Generate Code (CRUD) for 3 Layered architecture

12 Dec 2016 by Suresh Dasari's

Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.

BackUp and Restore with SMO of SQL Server 2008

26 Oct 2015 by Hernán Hegykozi

This tip will show how to perform a backup and restore database from an application in VB.NET 2010.

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

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

Check Digit Vertical and Horizontal

6 May 2013 by Hernán Hegykozi

This tip explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by SQL Server.

CLR-addon for DATE and Split-String

3 Jan 2013 by Levente Kupás

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

Common Table Expression to find all related nodes

12 Nov 2013 by Jobless Creature

CTE To find all the related nodes in a hierarcy

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.

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

25 Feb 2012 by Sanjay K. Gupta

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[^]

Copy/Synchronize Table Data between databases

16 Mar 2012 by Anurag Gandhi

A Query to copy an individual table data between databases

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

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

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

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.

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

Dequeue workitems using MERGE

25 Feb 2014 by Darek Danielewski

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

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

Dynamic ORDER BY with multiple criteria in T-SQL

28 May 2013 by Bob Crowley

How to use a CASE statement in ORDER BY to avoid dynamic SQL

Encrypt all Stored Procedures with PowerShell

7 Aug 2012 by kennysun

encrypt all stored procedures in SQL server with powershell

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.

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

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

Fast way to deal with foreign keys

18 Jun 2010 by Alexander Konstantinov

Two stored procedures helping developers do less things when they create tables and indeces

SQL

SQL-Server-2008

SQL-Server

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

Find Missing Date Ranges in SQL Server

10 Feb 2012 by Ramanujam Shankar

Find missing date periods 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.

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

Forgot Password With Check Email From Database

22 Oct 2013 by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Generate XML Using FOR XML

29 May 2012 by Harsh Gandhi

Generate XML Using FOR XML ; Difference between different modes (AUTO, RAW, PATH, EXPLICIT) of FOR XML to generate XML in SQL Server

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.

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

Get accurate age by date

20 Feb 2010 by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

Get Better Performance in Dotnetnuke Framework

2 Oct 2014 by Trung Nguyen Son

How to analyse and tune your dotnetnuke site to get best performance.

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

Get Tables List With Its Dependent Tables Names

15 Jan 2012 by Dhol Gaurav

Get Tables List With Its Dependent Tables Names

Get Top X rows from a table

23 Feb 2012 by Mahmud Hasan

How to use variable in SELECT TOP SQL command

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

Grouping dynamically on different columns in single query

4 Jan 2013 by RahulAJoshi

Grouping dynamically on different columns in single query

Grouping Records with SQL Server 2008

18 Jul 2012 by Omar Frometa

Grouping Sets is the new SQL Server 2008 Operator

SQL-Server-2008

SQL-Server

How to Find a Text in SQL Server Stored Procedure

30 Jun 2012 by Ameet Parse

This article describes How to find a Text in Stored Procedure (Checked on SQL Server 2008)

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

How to get the details of Open Transaction in SQL Server

2 Sep 2010 by tarun_j200

How to Partition Table in SQL Server

31 Jul 2014 by Kale Yogesh

How to Partition Table in SQL

SQL-Server-2008

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 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

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

How to search between two dates and get all records

27 Mar 2012 by SA - Hibbert

Return all records between two dates that include time in SQL.

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.

How to setup database versioning tool RoundhousE

2 Sep 2014 by Rohan Kishor Garud

RoundhousE (RH) is a database migrations engine that uses plain old SQL Scripts to transition a database from one version to another.

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.

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

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.

How to Write a Single Stored Procedure for Delete/Retrieve all Table of Records

14 Jun 2013 by Bojjaiah

Single Stored Procedure for delete/retrieve all table of records

Identifying and Deleting Duplicate Records from SQL Server Table

1 Jun 2016 by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

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.

Index and Sort Order

20 Jul 2012 by Mr. Joydeep Das

What the effects of Ordering in Index

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.

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

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

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

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

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

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

Microsoft SQL System View Version Map

13 Dec 2012 by Paw Jershauge

MS SQL system views, mapped over version.

MS SQL Scripts Runner

4 Apr 2012 by sluaghtered

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

MyMDb your local IMDB store

22 Jul 2013 by Paw Jershauge

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

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.

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

22 Sep 2017 by #realJSOP

It doesn't always happen the way you expect.

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.

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.

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.

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.

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.

Return Comma Separated String using SQL

30 Jan 2013 by Yogesh Gulve

Return Comma Separated String using SQL

Rowversion: Version Stamping A Row

19 Oct 2013 by SonuKSingh

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

Run All Subscription Reports At Once in SSRS Manually

5 Sep 2013 by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

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

Select Statement to HTML Table

2 Feb 2018 by Luca Astolfi

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

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.

ShoppingCart using Gridview in ASP.NET

13 Jun 2012 by headshot9x

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

Shortest Path in SQL Server using hierarchyid

29 Nov 2013 by Mehdy Moini

Implementing a map as a tree, and finding the shortest path, between the streets, is what you will see.

Simple Technique to Exclude Column from SELECT * FROM TABLENAME

22 Mar 2012 by SERokon

Exclude Column from SELECT * statement

SMO 101 - Getting all DB's

17 Aug 2011 by bmckuhen

How to get a quick list of all DBs using SMO

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:

Split function

5 Jun 2010 by db_developer

Split User Defined Function, MS SQL Server 2008

SQL

SQL-Server-2008

SQL-Server

SQL - Converting a varchar parameter to a table

3 Dec 2012 by Glagace_7763

Create a table from a Varchar list value

SQL Atomic Operation on UPDATE and DELETE

13 Jan 2012 by Robby Tendean

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

SQL Change Data Capture (CDC) table not working after adding new columns to the source table and Using CDC with a frequently changing schema

13 Mar 2015 by Rajesh Manjarekar

When CDC is turned ON against a table and the underlying table schema changes, such as adding/removing a column, changing datatype etc

SQL script for creating an ASP.NET Identity Database

4 Nov 2013 by Mr.Thursday

SQL script for creating ASP.Net Identity Database

SQL Server - BLOB Import and Export

24 Apr 2012 by mkader

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

SQL Server 2008 - Loop through/split a delimited string

15 Mar 2012 by Ganu Sharma

Loop through/split a delimited string.

SQL

SQL-Server-2008

Dev