SQL-Server-2008R2

Great Reads

ASP.NET C# Tutorial - Development with Nido Framework for Dummies

by Nirosh

This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.

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

AngularJS MVC Repository Dispose

by Mahsa Hassankashi

This is the simplest tutorial on AngularJS and Repository Pattern for developing professional MVC applications. It includes a source code about practical permission management project.

Latest Articles

ASP.NET C# Tutorial - Development with Nido Framework for Dummies

by Nirosh

This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.

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

AngularJS MVC Repository Dispose

by Mahsa Hassankashi

This is the simplest tutorial on AngularJS and Repository Pattern for developing professional MVC applications. It includes a source code about practical permission management project.

All Articles

top

SQL-Server-2008R2

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

Another Way to Get Identity from SQL Server

by nithyananthams

Different options to get Identity from SQL Server and how OUTPUT clause helped me to get the accurate Identity value compare with other options.

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.

Auto Backup Of Database in SQL Server 2008 & Above

by Harsh Aggarwal - India

It's about making back up of database in SQL server 2008 and above you can get rid of making bak file manually.

Basic Troubleshooting for Microsoft SQL Table Lock

by NaibedyaKar

How to check the query locking the table and to unlock it

Bind Crystal Reports with Dataset or Datatable

by saurav ray

Article determines how to bind a crystal report with a virtual database

Building DynamicTVP

by hlonihloksDJ

Building DynamicTVP

C# - Google Maps in WinForm with WebBrowser and Google Maps API v3

by SMPS LLC

With this tip, you can show a map in your WinForm application with the Google Maps API v3.

Changing the Crystal Report Database credential and Logon values at runtime

by SREENATH GANGA

How to change the DBservername ,DBName ,password,Userid etc of a crystal report at runtime

Connect Visio 2007 to any SQL Server Version after SQL Server 2005

by Anusheel Kamle

How to connect Visio 2007 to SQL Server 2008 R2 for reverse engineering

Convert CellSet to HTML Table, and From HTML to Json, Array

by Sibeesh KV

Convert CellSet to HTML table

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 Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

by Prakash Lekhak

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#

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

Creating a SSRS Report With Microsoft Dynamics CRM On-line

by coded007

Designing reports with Dynamics CRM

CRUD in ASP.NET MVC 4 with KnockOut.JS

by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 4 with scripting language as KnockOut and Database as MS SQL 2008R2.

CRUD in ASP.NET MVC 5 using WebAPI 2 with AngularJS

by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 5 using WebAPI 2 with scripting language as AngularJS and Database as MS SQL 2008R2.

CURSOR in T-SQL

by Prakash Lekhak

Dynamic SQL to get the list Table names

Cursors Vs. Sets

by Sums Mohs Eds

A brief discussion of when to use cursors and when to use sets.

Dapper.NET and DapperExtensions to Run Stored Procedures

by Vijaykumar Vadnal

We will discuss about how we can combine Dapper.NET and DapperExtensions to configure DAL to execute normal queries as well as Stored Procedures.

Debug ASP.NET MVC Application with Glimpse

by Muhammad Hassan Tariq

Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications

Demonstration Application using MVC SignalR and Entity Framework: Part I

by Shashank S Chandel

Demonstration application using MVC SignalR and Entity framework - Part I

Dynamic DropDownList Binding in ASP.NET MVC With Database

by Member 10872251

Cascading DropDownList in ASP.NET MVC

Dynamic Pivot Query in SQL Server

by Chetan Naithani

Transforming dynamic row-level data into columns

Dynamic Restore SQL Server

by Member 10262330

Dynamic restore SQL Server

Easy Database Table Change History

by Johnny L Washington

Capture data changes in history table

Entity Framework Code First Migrations Alternative

by DiponRoy

How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first

Experimenting with Date and Time data types in SQL SERVER 2008

by John C Rayan

An insight into date and time types in SQL SERVER -

Extracting the filename from a full path in SQL Server

by OriginalGriff

Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it in SQL?

Fast and Simple IDataReader Implementation to Read CSV Files

by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Fastest way to find row count of all tables in SQL

by Mihir.D.Shah

Simple Queries to find row count of all tables in a MS-SQL Database

Fill factor in SQL server.

by Jitendra Ku. Sahoo

In this article we will discuss about fill factor and its effect on query performance.

Find the Size of Database mdf and ldf File in sql server

by Arvind Singh Baghel

I show a SQL query which finds the size of database mdf and ldf file in SQL Server.

Get accurate age by date

by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

Handle errors in WCF with and without FaultContract attributes.

by Bimaln

Handle errors in WCF.

How to fix "LocalDB - Requested Login failed"

by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

How to get output parameter values from stored procedure using Entity Framework.

by SRS(The Coder)

This tip gives an explanation with example on how to get output parameter value from stored procedure using Entity Framework in ASP.Net

How to Get SQL Column Values as Comma Separated String using XML Path Method

by banitabisht

Tip to get comma separated string for a column in SQL query using XML path method

How to Get Words Separated in a String Concatenated by Delimiter

by Ankur .K. Vishwakarma

This tip shows you a T/SQL function to split a string concatenated by a delimiter.

How to Improve Performance of Query

by Arora_Ankit

This tip will provide you with an idea about basic things that you can use to get better performance from query.

How to Resolve: "The Data Source value in the connection string specifies an instance of SQL Server that is not installed" or "LocalDB instance...

by yash soman

The error occurs when we try to create a new Microsoft SQL Server Database File (SqlClient) using Visual Studio IDE

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.

Identifying and Deleting Duplicate Records from SQL Server Table

by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

Implement Split A/B pages in your ASP NET project

by TheCardProject.co.uk

Quickly set up the ability to serve up several pages and record which was served in SQL Server

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.

Insert Data Using Stored Procedure in ASP.NET

by Rajendra D. Patel

How to insert data using stored procedure in ASP.NET

Microsoft SQL: Increase Existing Value In Row Or Add New Row If None Exists

by furytrader

Yes, Virginia, You Can Do This All With One Simple SQL Statement

Money Precision Issues

by Bohdan Stupak

This tip shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

MSSQL to MySQL Export

by madagaga

Converting MSSQL database to MySQL

MVC Load Stocks Data on Runtime in a Grid View

by Wajahat Aftab

How to load data from live market stock feed in a grid view

Pass Parameters from Web Page to Telerik Report

by Thinira

In this tip, we discuss how to pass report parameters from web page to Telerik report programmatically.

Performance Tuning of Insert Query

by Member 8826598

Performance Tuning of DML Operation Insert in different scenario

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.

Post rowversion or timestamp of MsSQL using jquery

by DiponRoy

How to post rowversion or timestamp of MsSQL using jquery

Powershell script to monitor windows servers and populate it into a sharepoint list

by LalithGallage

This powershell script is you to monitor windows servers’ free hard disk and populate it to sharepoint custom list.

Progress Bar

by kunal r somani

Regarding progress bar

Query that returns list of all Stored Procedures in an MS SQL database

by Sandeep Khairha

Query that returns list of all Stored Procedures

Random Date/Time Test Data Generation

by Gene R. Browning

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

RDLC Report Grouping with Page Break, Table Header Repeat, Group Totals and Sub Grouping

by Pavith Goonathilake

RDLC Report Grouping with Page Break for each Group Type, Table Header repeat for each page and Report Totals

Read & Insert Data Using Stored Procedures in C#

by gayani dassa

Read & Insert Data Using Stored Procedures

Read Data from the Next Row

by george bolovan

Read data from the next row

Recursive CTE in SQL Server Simplified

by Gaurav_Chaudhary

This tip is a brief introduction to Recursive CTE in SQL Server and how to implement it.

Relational Database Design with an Auto Insurance Database Sample

by Prakash Lekhak

Create an ER diagram for complex database

Rename file using MS sql server(xp_cmdshell), GetAllFileDetails in MS SqlServer (xp_getfiledetails)

by Avinash Narnaware

Rename file using MS sql server using xp_cmdshell rename, while file name contain space. Get All file Details in MS Sqlserver 2008 using xp_getfiledetails.

Request for the Permission of Type System.Web.AspNetHostingPermission

by Bimaln

Solved the Permission issue when I hosted my ASP.NET application on IIS7

Restart a SQL Server Scheduled Job If Hanged

by anki.mathur

Restart hanged SQL Server scheduled job

Running the SQL Script File By Using The System.Diagnostics.Process Class

by madhusudhanReddy

Running the SQL Script File

Save your Data from LDAP Injection Attack

by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

Select Statement to HTML Table

by Luca Astolfi

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

SOAP message in WCF services.

by Bimaln

Describe about the SOAP message in WCF with example.

Some Common Mistakes When Querying SQL Database

by Bohdan Stupak

This tip will cover several interesting issues of SQL

SQL Server 2008 Error: Saving changes is not permitted

by Prasad CM

How to fix this error.

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 Procedure to Report Duplicates

by PIEBALDconsult

A stored procedure I use to find duplicate records in tables and views.

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

SQL Server: Find Table Order/Generation And Relation Details

by DiponRoy

A utility query to find table generations in SQL Server relational database

SQL Server: Query to Get the Date of First Monday of September

by Mohamad Cheaito

SQL Server: Query to get the date of first Monday of September

SSIS - Import Text File

by Math08avan

SQL Server Integration Services - How to read a text file

SSRS Report Integration With Web Api

by santosh poojari

The idea is to source SSRS report datasource with web api output. The datasource can take XML input datasource hence we can allow web api to give us desired XML output dataset in defined format or schema. Once we have that it is easy to sourced or housed it into SSRS reports -RDL or Client RDLC in .

Storing Large Binary Data in a SQLSERVER Database

by Schrödter

How to write data to SQLSERVER varbinary(MAX) columns in C++ using ADO

Table Valued Parameters in SQL 2008

by DotNetForAll

The tip describes how the Table Valued Parameters(TVP) are used in SQl server and how they can be utilized using C# code.

Template to Handle Error in SQL Server

by Jitendra Ku. Sahoo

Below is one template to handle error in SQL server.

Test and copy files from source to destination in MS-SQL

by XyedBilal

Copying files from source to destination using master..xp_fileexist and master..xp_cmdshell

TFS Backward Migration from (2012SP1\SQL 2012 ENT) to (2010 SP1\SQL 2008 R2 STD)

by Sushil Pandit

Process for backward migration of code from TFS 2012 to TFS 2010

To Search Data in Multiple Columns using 'IN' Clause

by King Fisher

To search data in multiple columns using 'IN' clause

Tricky SQL Questions

by sukeshchand

Unexpected SQL Interview Questions

T-SQL Function: Add a space between all characters

by Paul M Simpson

Expanding a string by inserting alternating single spaces between characters

Two Way Binding using JavaScript in ASP.NET MVC With Database

by Member 10872251

Two way binding using JavaScript

UniDAC - database's direct connection

by Thiago Gaidzinski

UniDAC allows you to connect your cross-platform application directly with many database's types.

Unlimited Category List Table

by Pedram_Niloufari

How to create an unlimited category list table in database and how to read category list

Update Database using Stored Procedure and DataAdapter

by Naresh Patidar

Insert, update and delete operations using stored procedure and DataAdapter in C#

Useful SQL Snippets & Own Functions for SQL Server, SQL Server CE, MySQL, SQLite, PostgreSQL

by IAndreev93

Standard functions usage, and my own functions... Allowing you simpler process tables... Date and time... Strings...

Using NLog.net in SOA with ILogReceiverServer

by grantliu

Utilize NLog.net in a Service-oriented architecture

Using only TCP/IP for connecting to SQL Server 2008 and Changing the SQL Server 2008's default TCP/IP port

by Aqeeel

Implementing security in SQL Server by only allowing TCP/IP Network Protocol and changing default TCP port

Using SMO to script all SQL jobs for an instance using C#.Net

by Colm Hoban

A command line utility to script out all jobs from an instance to be used to transfer jobs to another server/environment or to be deposited in source control.

WCF Restful Service Form Authentication

by sandeep12jain

WCF Restful Service Authentication without SSL Certificate

WPF and MVVM pattern

by Oussama_Kahoul

Introduction to WPF technology and the MVVM design pattern

Writeback and writethrough using C#

by rakesh1503

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