Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / database / SQL-Server / SQL-Server-2008

SQL-Server-2008

SQL-Server-2008

Great Reads

by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.
by Nikita D. Sinelnikov
HowTo: make the report background (elements) of Microsoft .NET Report (.rdlc) non-printable
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

by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.
by Nikita D. Sinelnikov
HowTo: make the report background (elements) of Microsoft .NET Report (.rdlc) non-printable
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

Sort by Score

SQL-Server-2008 

by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.
by Tejas Vaishnav
Auto incremented ID using VARCHAR data type
by Tharaka MTR
How to count consecutive dates using SQL
by Rohitmssqlfun
Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available!
by Vivek Johari
Basic information about the different ways of creating a table
by Rohitmssqlfun
This DMV allows you to discover a lot of very interesting and important performance information about your cached stored procedures.
by Martin Hinshelwood
From time to time your website structure may change. When this happens you do not want to have to start from scratch with your Google rankings, so you need to map all of your Old URLs to new ones.
by Sadeque Sharif
Easily trace all errors of Stored Procedures in MS SQL Server.
by Tharaka MTR
Generate insert statements from a specific table data using SQL Server
by Mayur V Lohite
Generic Repository Pattern MVC
by Vivek Johari
This article will try to show how to find duplicate values in a table.
by Tharaka MTR
This post will show you how to fix orphaned SQL users.
by rusanu
How to Multicast messages with SQL Server Service Broker
by Shahriar Iqbal Chowdhury/Galib
This post shows you how to solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017
by atverma
In this article I’ll discuss about unit testing SQL Server 2008 Database project using Visual Studio 2010.
by atverma
In this article I will explore the important features that can be configured to build comprehensive database unit tests.
by atverma
This is the last article of the series “How to unit test SQL Server 2008 database using Visual Studio 2010”.
by Vivek Johari
Introduction to SQL Server Views
by Manjuke Fernando
Briefly describing the features in SQL Server Data Tools.
by Debopam Pal
Using Microsoft.Office.Interop.Excel library, you can bring your data from your database against LINQ query and store them into an Excel Sheet.
by PratapReddyP
Many a times we came across situation to merge records between two tables.
by Bryan O'Connell
Review of the ebook: Brad's Sure Guide to SQL Server Maintenance Plans.
by Steve Maier
The same database and the same RIA Services can be used as a Web Service by using some simple additions to the setup of your project.
by Vivek Johari
Stored Procedure in SQL Server can be defined as the set of logically group of SQL statement which are grouped to perform a specific task. This article will describe the Stored Procedure in SQL Server and their benefits.
by aasim abdullah
SQL Server: A Query Slow in SSMS, Fast in Application, WHY?
by aasim abdullah
How to apply filter on sp_MSforeachDB
by aasim abdullah
How to control SQL Server Log Information
by aasim abdullah
Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.
by aasim abdullah
SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space
by aasim abdullah
Smarter Way of Query Load Testing at Testing Server
by Leland Richardson
Several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios
by Manjuke Fernando
How to use the new MERGE statement feature in SQL Server 2008
by Sky Sanders
A strategy for implementing maintaining separation of concerns and implementation hiding.