SQL Server
Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

RECENT POSTS

  • Venkatesan Jayakantham

    Truncate Log file in SQL Server

    Truncate Log file in SQL Server
  • Venkatesan Jayakantham

    Check log files - free space in SQL Server

    Check log files - free space in SQL Server
  • Venkatesan Jayakantham

    Compatibility Level in SQL Server 2008

    Compatibility Level in SQL Server 2008
  • Venkatesan Jayakantham

    SQL Server 2008 SSMS enhancements - Reporting in SQL Server

    SQL Server 2008 SSMS enhancements - Reporting in SQL Server
  • Venkatesan Jayakantham

    Unable to start SQL Server instance

    Unable to start SQL Server instance
  • Venkatesan Jayakantham

    Copy Billions of data from One database table to another database table

    Copy Billions of data from One database table to another database table
  • Venkatesan Jayakantham

    SQL Server Technology Thirst

    SQL Server Technology Thirst
  • Rahul Saxena

    Handling SqlServer Error

    How to handle SqlServer Error in SqlServer2005 or higher version..?
    Rahul Saxena Jun 02, 2010
  • Kirtan Patel

    Enumerate the ALL SQL Server Instances in Network

    In this article I will teach you how to get names and all other information of sql server instances that are in network.
    Kirtan Patel Jun 01, 2010
  • Keyur Chauhan

    Improving Stored Procedure performance - Checklist

    Improving Stored Procedure performance - Checklist gives you simple tips to improve your stored procedure performance. Very helpful for entry level programmers or DB developers.
    Keyur Chauhan May 06, 2010
  • Amit Choudhary

    What is SMO?

    SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server.
    Amit Choudhary May 03, 2010
  • Rajshree Mittal

    Database Snapshot in Sql Server 2005

    A database snapshot is a read-only, static view of a database (called the source database). Each database snapshot is transactionally consistent with the source database at the moment of the snap...
    Rajshree Mittal Apr 26, 2010
  • Rajshree Mittal

    XML DATATYPE (series 1)

    New to SQL Server 2005, is The XML data type, which lets you store XML documents and fragments in a SQL Server database. An XML fragment is an XML instance that is missing a single top-level eleme...
    Rajshree Mittal Apr 26, 2010
  • Rajshree Mittal

    Paging Records Using SQL Server 2005 Database - ROW_NUMBER Function

    SQL Server 2005 has a ROW_NUMBER Function that can help with paging records for you database applications. ROW_NUMBER returns a sequential number, starting at 1, for each row returned in a result...
    Rajshree Mittal Apr 26, 2010
  • rohit bharel

    How to optimize a stored procedure

    Different Steps to optimize a stored procedure.
    rohit bharel Apr 26, 2010
  • rohit bharel

    SQL SERVER Interview Questions

    SQL SERVER Interview Questions contains 1 General Questions of SQL SERVER...…………………… 2 Common Questions Asked……………………………………… 3 Questions of SQL SERVER 2008……………………………
    rohit bharel Apr 26, 2010
  • Kapil Soni

    Sql Injection Prevention

    To protect your application from SQL injection, perform the following steps: * Step 1. Constrain input. * Step 2. Use parameters with stored procedures. * Step 3. Use parameters wi...
    Kapil Soni Apr 24, 2010
  • Kapil Soni

    Gumblar Attack

    Gumblar appears to be a combination of exploit scripts and malware. The scripts are embedded in .html, .js and .php files using obfuscated Javascript. They load malware content from Third Party sit...
    Kapil Soni Apr 20, 2010
  • Sateesh Arveti

    Look at Date and Time data types in SQL Server 2008

    SQL Server 2008 provides new datatypes to work with date and time values easily.
    Sateesh Arveti Apr 16, 2010
  • Sateesh Arveti

    Look at IDENTITY_INSERT in SQL Server

    We can use IDENTITY_INSERT for inserting values explicitly into a identity column.
    Sateesh Arveti Apr 13, 2010
  • John Charles Olamendy

    Creating Stored Procedures with Managed Code

    This article is intended to illustrate how to implement a stored procedure with managed code.
  • Sateesh Arveti

    Look at Table-valued functions in SQL Server 2005

    Table-valued functions are used to return TABLE datatype.
    Sateesh Arveti Apr 05, 2010
  • Nikhil Kumar

    Country list

    This blog show the SQL query ready to be inserted in a table and contains Countries list.
    Nikhil Kumar Feb 05, 2010
  • Sumit Kumar

    Expolore c#

    Welcome to the EXPLORATION OF C #
    Sumit Kumar Feb 01, 2010
  • Karthika Palaniswamy

    deleting the duplicate records from SQL Server table

    To delete the duplicate records(same records in one more time) from SQL Server Data base table,use this query.