SQL-Server-2008

Great Reads

Auto Generate Code (CRUD) for 3 Layered architecture

by Suresh Dasari's

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

.NET 4.0 MemoryCache with SqlChangeMonitor

by Rick Bassham

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

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

by Nikita D. Sinelnikov

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

A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET

by Gurdeep Singh Toor

A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.

Latest Articles

Auto Generate Code (CRUD) for 3 Layered architecture

by Suresh Dasari's

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

.NET 4.0 MemoryCache with SqlChangeMonitor

by Rick Bassham

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

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

by Nikita D. Sinelnikov

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

A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET

by Gurdeep Singh Toor

A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.

All Articles

top

SQL-Server-2008

Auto Generate Code (CRUD) for 3 Layered architecture

by Suresh Dasari's

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

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

by Nikita D. Sinelnikov

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

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

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

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

A simple method to measure execution time in SQL Server

by Chris Maunder

Timing SQL calls with millisecond accuracy

A Unique Feature of SQL SERVER Loop with Go Statement

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

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

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.

BackUp and Restore with SMO of SQL Server 2008

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

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

Building hierarchy using Recursive CTE

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.

Check Digit Vertical and Horizontal

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

by Levente Kupás

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

Common Table Expression to find all related nodes

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

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

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

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

by PIEBALDconsult

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

Copy/Synchronize Table Data between databases

by Anurag Gandhi

A Query to copy an individual table data between databases

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

Create CSV File in Microsoft SQL

by Rajesh_K_Sharma

How to create CSV file in SQL

Create Insert SQL Statement from the Records in an Existing Table

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

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

by Diluka Wittahachchige

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

Dequeue workitems using MERGE

by Darek Danielewski

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

Dynamic DropDownList Binding in ASP.NET MVC With Database

by Member 10872251

Cascading DropDownList in ASP.NET MVC

Dynamic ORDER BY with multiple criteria in T-SQL

by Bob Crowley

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

Encrypt all Stored Procedures with PowerShell

by kennysun

encrypt all stored procedures in SQL server with powershell

Entity Model to Excel using LINQ in C#

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

by IkhwanKrisnadi

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

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

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

Fast way to deal with foreign keys

by Alexander Konstantinov

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

Find All the Days Between Two Dates

by S.P.Tiwari

Find all the days between two dates using SQL Server

Find Missing Date Ranges in SQL Server

by Ramanujam Shankar

Find missing date periods from a table.

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

by Nelson Kosta Souto

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

Finding available free space in the disks of SQL Server

by Saral S Stalin

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

Forgot Password With Check Email From Database

by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Generate XML Using FOR XML

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

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

by Purushotham Agaraharam

Creating a parameterised report using SSRS.

Get accurate age by date

by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

Get Better Performance in Dotnetnuke Framework

by Trung Nguyen Son

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

Get my database server with current database.

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

Get Tables List With Its Dependent Tables Names

by Dhol Gaurav

Get Tables List With Its Dependent Tables Names

Get Top X rows from a table

by Mahmud Hasan

How to use variable in SELECT TOP SQL command

Getting the Current Time from Any Time Zone

by vikram.mahapatra

How to get the current time from any time zone

Grouping dynamically on different columns in single query

by RahulAJoshi

Grouping dynamically on different columns in single query

Grouping Records with SQL Server 2008

by Omar Frometa

Grouping Sets is the new SQL Server 2008 Operator

How to Find a Text in SQL Server Stored Procedure

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?

by Rajat-Indiandotnet

Find column or Text in entire stored procedure

How to get the details of Open Transaction in SQL Server

by tarun_j200

How to Partition Table in SQL Server

by Kale Yogesh

How to Partition Table in SQL

How to prevent SQL Injection in Stored Procedures

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

by Wendelius

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

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

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

How to search between two dates and get all records

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

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

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

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

by Kumar Pankaj Verma

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

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

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

by Bojjaiah

Single Stored Procedure for delete/retrieve all table of records

Identifying and Deleting Duplicate Records from SQL Server Table

by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

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

by Arvind Singh Baghel

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

Index and Sort Order

by Mr. Joydeep Das

What the effects of Ordering in Index

Inno Setup Script to Install SQL Server 2008 R2 with Tools

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

by Mubin M. Shaikh

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

List blocking processes in SQL server

by Chris Maunder

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

List blocking processes in SQL server

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

List SQL Server table column name as rows

by Chamila Nishantha

Simple query to get table column name as rows

List SQL Server table column name as rows

by PIEBALDconsult

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

List SQL Server Table Column Name as Rows

by Wendelius

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

Microsoft SQL System View Version Map

by Paw Jershauge

MS SQL system views, mapped over version.

MS SQL Scripts Runner

by sluaghtered

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

MyMDb your local IMDB store

by Paw Jershauge

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

Passing Object Collections to ASP.NET Web API

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

by #realJSOP

It doesn't always happen the way you expect.

Pivoting on SQL Server Varchar Data Types

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

by Subha.N

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

Random Date/Time Test Data Generation

by Gene R. Browning

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

Read a file using transact-sql.

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

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

by Yogesh Gulve

Return Comma Separated String using SQL

Rowversion: Version Stamping A Row

by SonuKSingh

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

Run All Subscription Reports At Once in SSRS Manually

by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

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

by IkhwanKrisnadi

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

Select Statement to HTML Table

by Luca Astolfi

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

Setting deadlock priority in SQL Server

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

by headshot9x

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

Shortest Path in SQL Server using hierarchyid

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

by SERokon

Exclude Column from SELECT * statement

SMO 101 - Getting all DB's

by bmckuhen

How to get a quick list of all DBs using SMO

Sort AlphaNumeric Data in Sql

by Anurag Gandhi

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

Split function

by db_developer

Split User Defined Function, MS SQL Server 2008

SQL - Converting a varchar parameter to a table

by Glagace_7763

Create a table from a Varchar list value

SQL Atomic Operation on UPDATE and DELETE

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

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

by Mr.Thursday

SQL script for creating ASP.Net Identity Database

SQL Server - BLOB Import and Export

by mkader

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

SQL Server : How to Keep Database Restore History

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 2008 - Loop through/split a delimited string

by Ganu Sharma

Loop through/split a delimited string.

SQL Server Database Backup Status Report

by Dathuraj Pasarge

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

SQL Server Health Check Script with Powershell

by Atul_Kapoor

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

SQL Server Logon Triggers Trouble

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 Management Studio: Basic Startup Options

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 Scripts: Get All Nested Stored Procedures List (Procedures with Dependent Procedures)

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 StringPadding (String function)

by Surender Singh (CodeToastDev)

Custom StringPadding functions for SQL Server

SQL Server: Automatic Query Execution at Every Instance Startup

by aasim abdullah

Automatic query execution at every instance startup.

SQL Server: Bookmark Lookups, a Query Performance Killer

by aasim abdullah

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

SQL Server: Changed data capture without using Triggers

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

by aasim abdullah

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

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

by aasim abdullah

Get all indexes list in detail, with their involved columns

SQL Server: How to Refresh Intellisense Cache

by aasim abdullah

How to Refresh Intellisense Cache in SQL Server

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

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

by aasim abdullah

Restore failure from Enterprise to Standard edition in SQL Server.

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

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.

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

by Rajesh Manjarekar

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

SSIS: Load Data in Dimension Table by Merge Join

by mparvez

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

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

by Jesus Carroll

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

String splitting/tokenizing using T-SQL User Defined Function

by smirson

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

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

by Irfan Baig

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

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

The Best Table Finder (The BestCube Problem)

by BharatRamV

Finds the Best Table for a given set of columns

TIP: Managing SqlGeography class from C#

by Jaime Olivares

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

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

by Syed Moula Ali

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

Trailing spaces are ignored in SQL Server 2008

by zvin

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

Triki Game Using SQL Triggers

by salchichurria

Triki game created in SQL Server with triggers.

T-SQL Function: Add a space between all characters

by Paul M Simpson

Expanding a string by inserting alternating single spaces between characters

Uniqueidentifier Field Problem

by hussain.attiya

Uploading an Image and Displaying It on the UI Page

by Mannava Siva Aditya

Uploading an image and displaying it on the UI page

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

by John Gathogo

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

Use SQL to generate large data sequence

by DrABELL

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

Using Common Table Expressions and Recursion in SQL Server 2008

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

Writeback and writethrough using C#

by rakesh1503

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