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

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

22 Sep 2017 by #realJSOP

It doesn't always happen the way you expect.

T-SQL

Windows

SQL-Server-2008

SQL-Server

Dev

DBA

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.

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

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: Restore Failure from Enterprise to Standard Edition

19 Apr 2013 by aasim abdullah

Restore failure from Enterprise to Standard edition in SQL Server.

SQL-Server

SQL-Server-2008

SQL-Server-2005

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: Get All Databases Size

2 Oct 2012 by aasim abdullah

A simple query to get all databases size on a given instance.

SQL Server: Automatic Query Execution at Every Instance Startup

19 Apr 2013 by aasim abdullah

Automatic query execution at every instance startup.

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

SQL Server: TOP…WITH TIES - A Beauty of TSQL

19 Apr 2013 by aasim abdullah

The TOP clause is commonly used to get the top required rows from a result set. The beauty of this clause is that it can be used with the WITH TIES clause to retrieve all similar rows to a base result set.

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.

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

SQL Server: Bookmark Lookups, a Query Performance Killer

1 Nov 2012 by aasim abdullah

You have place indexes but still queries are slow... are you facing bookmark lookup problem ???

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

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)

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:

Copy/Synchronize Table Data between databases

16 Mar 2012 by Anurag Gandhi

A Query to copy an individual table data between databases

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.

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

The Best Table Finder (The BestCube Problem)

20 Dec 2016 by BharatRamV

Finds the Best Table for a given set of columns

SMO 101 - Getting all DB's

17 Aug 2011 by bmckuhen

How to get a quick list of all DBs using SMO

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

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

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

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

Dequeue workitems using MERGE

25 Feb 2014 by Darek Danielewski

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

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

Split function

5 Jun 2010 by db_developer

Split User Defined Function, MS SQL Server 2008

SQL

SQL-Server-2008

SQL-Server

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.

Get Tables List With Its Dependent Tables Names

15 Jan 2012 by Dhol Gaurav

Get Tables List With Its Dependent Tables Names

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

SQL Server Logon Triggers Trouble

18 May 2010 by Dimitri Witkowski

Recently I had a problem: I was developing a logon trigger for SQL Server, and there was a bug in it. After deploying the trigger to the server he didn't allow me to login anymore. I was in panic and thought I would have to reinstall SQL Server.Fortunately, I've found a solution how to...

SQL-Server-2008

SQL-Server

Use SQL to generate large data sequence

19 Feb 2015 by DrABELL

Generate large data series by using Cartesian Product and small data 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.

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

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.

SQL - Converting a varchar parameter to a table

3 Dec 2012 by Glagace_7763

Create a table from a Varchar list value

Using Common Table Expressions and Recursion in SQL Server 2008

28 Apr 2010 by Gordon Kushner

By using recursion (and CROSS JOINS), you can generate data without looping or hard-coding INSERT statements into a temporary table.In the example below, you can use recursion to generate a week of scheduling data for three employees. -- Count variable, set to 7 for a week's worth of...

SQL-Server-2008

SQL-Server

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

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

ShoppingCart using Gridview in ASP.NET

13 Jun 2012 by headshot9x

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

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

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.

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.

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

Uniqueidentifier Field Problem

2 Oct 2010 by hussain.attiya

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

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

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

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

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

Common Table Expression to find all related nodes

12 Nov 2013 by Jobless Creature

CTE To find all the related nodes in a hierarcy

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

How to Partition Table in SQL Server

31 Jul 2014 by Kale Yogesh

How to Partition Table in SQL

SQL-Server-2008

SQL-Server

Encrypt all Stored Procedures with PowerShell

7 Aug 2012 by kennysun

encrypt all stored procedures in SQL server with powershell

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

CLR-addon for DATE and Split-String

3 Jan 2013 by Levente Kupás

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

Select Statement to HTML Table

2 Feb 2018 by Luca Astolfi

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

Get Top X rows from a table

23 Feb 2012 by Mahmud Hasan

How to use variable in SELECT TOP SQL command

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

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

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.

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

Get accurate age by date

20 Feb 2010 by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

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

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.

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 Example of Microsoft SQL Server Pad String

18 Dec 2015 by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

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

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.

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

SQL Server - BLOB Import and Export

24 Apr 2012 by mkader

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

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.

Index and Sort Order

20 Jul 2012 by Mr. Joydeep Das

What the effects of Ordering in Index

SQL script for creating an ASP.NET Identity Database

4 Nov 2013 by Mr.Thursday

SQL script for creating ASP.Net Identity Database

Run All Subscription Reports At Once in SSRS Manually

5 Sep 2013 by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

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

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

Forgot Password With Check Email From Database

22 Oct 2013 by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

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.

.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

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

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

Microsoft SQL System View Version Map

13 Dec 2012 by Paw Jershauge

MS SQL system views, mapped over version.

MyMDb your local IMDB store

22 Jul 2013 by Paw Jershauge

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

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

3 May 2012 by PIEBALDconsult

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

SQL

SQL-Server-2008

SQL-Server

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

Grouping dynamically on different columns in single query

4 Jan 2013 by RahulAJoshi

Grouping dynamically on different columns in single query

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

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

SSIS: Archive or Copy Files using dynamically specifying FileSpec file types for File Enumerator in Foreach loop

24 Jan 2013 by Rajesh Manjarekar

How do I set FileSpec dynamically for looping files in a foreach loop container?

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

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

Writeback and writethrough using C#

18 Dec 2012 by rakesh1503

Writeback and writethrough using C# with SQL Server 2008 SSAS.

.NET

SQL-Server-2008

artificial-intelligence

SQL-Server-2008R2

SQL-Server

Dev

Find Missing Date Ranges in SQL Server

10 Feb 2012 by Ramanujam Shankar

Find missing date periods from a table.