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

Select Statement to HTML Table

2 Feb 2018 by Luca Astolfi

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

SQL

HTML

T-SQL

XML

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

22 Sep 2017 by #realJSOP

It doesn't always happen the way you expect.

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

The Best Table Finder (The BestCube Problem)

20 Dec 2016 by BharatRamV

Finds the Best Table for a given set of columns

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.

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

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.

Identifying and Deleting Duplicate Records from SQL Server Table

1 Jun 2016 by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

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

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

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.

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

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

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.

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.

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

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

Use SQL to generate large data sequence

19 Feb 2015 by DrABELL

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

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

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.

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.

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.

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

How to Partition Table in SQL Server

31 Jul 2014 by Kale Yogesh

How to Partition Table in SQL

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

Dequeue workitems using MERGE

25 Feb 2014 by Darek Danielewski

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

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.

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

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.

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.

Common Table Expression to find all related nodes

12 Nov 2013 by Jobless Creature

CTE To find all the related nodes in a hierarcy

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

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

SQL script for creating an ASP.NET Identity Database

4 Nov 2013 by Mr.Thursday

SQL script for creating ASP.Net Identity Database

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.

Forgot Password With Check Email From Database

22 Oct 2013 by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Rowversion: Version Stamping A Row

19 Oct 2013 by SonuKSingh

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

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

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.

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

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

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

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

MyMDb your local IMDB store

22 Jul 2013 by Paw Jershauge

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

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

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

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.

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

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.

SQL Server StringPadding (String function)

24 Apr 2013 by Surender Singh (CodeToastDev)

Custom StringPadding functions for 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: 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: Automatic Query Execution at Every Instance Startup

19 Apr 2013 by aasim abdullah

Automatic query execution at every instance startup.

To Replicate/Clone/Duplicate, selected data in SQL Server 2012, 2008

2 Mar 2013 by Syed Moula Ali

Replicate/Clone/Duplicate selected data in a Table using merge statment

Triki Game Using SQL Triggers

25 Feb 2013 by salchichurria

Triki game created in SQL Server with triggers.

Return Comma Separated String using SQL

30 Jan 2013 by Yogesh Gulve

Return Comma Separated String using SQL

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?

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.

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.

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.

Grouping dynamically on different columns in single query

4 Jan 2013 by RahulAJoshi

Grouping dynamically on different columns in single query

CLR-addon for DATE and Split-String

3 Jan 2013 by Levente Kupás

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

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

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

Microsoft SQL System View Version Map

13 Dec 2012 by Paw Jershauge

MS SQL system views, mapped over version.

SQL - Converting a varchar parameter to a table

3 Dec 2012 by Glagace_7763

Create a table from a Varchar list value

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.

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

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 : 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: 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 Refresh Intellisense Cache

20 Oct 2012 by aasim abdullah

How to Refresh Intellisense Cache in SQL Server

SQL-Server-2008

SQL-Server

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

Encrypt all Stored Procedures with PowerShell

7 Aug 2012 by kennysun

encrypt all stored procedures in SQL server with powershell

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

Index and Sort Order

20 Jul 2012 by Mr. Joydeep Das

What the effects of Ordering in Index

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)

ShoppingCart using Gridview in ASP.NET

13 Jun 2012 by headshot9x

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

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

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

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.

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

2 May 2012 by Chamila Nishantha

Simple query to get table column name as rows

SQL

SQL-Server-2008

SQL-Server

SQL Server - BLOB Import and Export

24 Apr 2012 by mkader

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

MS SQL Scripts Runner

4 Apr 2012 by sluaghtered

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

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.

Simple Technique to Exclude Column from SELECT * FROM TABLENAME

22 Mar 2012 by SERokon

Exclude Column from SELECT * statement

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

Copy/Synchronize Table Data between databases

16 Mar 2012 by Anurag Gandhi

A Query to copy an individual table data between databases

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