Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1657
Home > Articles > Sql Server

Sql Server Articles (246) - Page 16

Articles posted by registered members of DotNetFunda.com. You can also post an article and win monthly prizes as well as gain community credit points.

246 records found.
 
Post
Syedshakeer
TRIGGERS 
Last updated on: 26 May 2010 01:38:57 AM by Syedshakeer | Views: 6842 | Category: Sql Server |
Votes: 1 | Rating: 3 out of 5
In this Article you can learn how to create and use DML TRIGGERS .
Vuyiswamb
How to Rebuilt all indexes in all Databases in SQL 2000/2005 
Last updated on: 23 Jun 2009 11:11:49 PM by Vuyiswamb | Views: 9480 | Category: Sql Server |
This Article will Show you , how to rebuild all the indexes in table in all the Databases in SQL 2005/200
Syedshakeer
How to store a Default Value in a table using sqlserver ? 
Last updated on: 21 Jun 2009 04:07:31 AM by Syedshakeer | Views: 6816 | Category: Sql Server |
storing a Default Value in a Table
Sbanerjee
Retrieving Column Names of a table 
Last updated on: 07 Apr 2009 01:43:23 AM by Sbanerjee | Views: 7165 | Category: Sql Server |
Retrieving Column Names of a table from database using SQL
Syedshakeer
Difference Between drop and truncate in sql 
Last updated on: 07 Sep 2011 02:38:02 AM by Syedshakeer | Views: 7615 | Category: Sql Server |
DROP and TRUNCATE
Syedshakeer
DataBase Transaction 
Last updated on: 18 Feb 2009 08:02:55 PM by Syedshakeer | Views: 5585 | Category: Sql Server |
DataBase Transaction
Questpond
SQL Server Interview Questions 
Last updated on: 14 Feb 2009 06:07:25 AM by Questpond | Views: 73857 | Category: Sql Server |
Votes: 4 | Rating: 5 out of 5
In this article we will go through the most basic and frequently asked interview questions on SQL Server. Please do not think that I am writing this article to show shortcuts to candidates who are searching for jobs on SQL Server. But I think no matter how much experience you have, an interview is a different ball game. A good project executioner can get knocked off on simple SQL Server questions.
    • Patidar.shekhar
    Transaction in SQL Server 
    Last updated on: 13 Nov 2008 09:13:13 AM by Patidar.shekhar | Views: 30254 | Category: Sql Server |
    A Database is a software system that defines a collection of predefined operations. Mainly it includes following operations 1.Efficient management of large amount of persistent data in a persistent storage (database) 2.Transaction Management which includes Concurrency Control, Atomicity and backup recovery procedure 3.A DataModel which gives a separate level of abstraction
    Deysomnath
    A Guide to SQL Server Indexes 
    Last updated on: 10 Nov 2008 06:51:00 AM by Deysomnath | Views: 28881 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    Creating the proper index can drastically increase the performance of an application. In this article we will learn how to create indexes in SQL Server database.
    Manisky2000
    SQL Joins 
    Last updated on: 08 Nov 2008 05:30:33 AM by Manisky2000 | Views: 6810 | Category: Sql Server |
    This artical describes the very basics of joins.
    Guru
    To make SQL Queries Case Sensitive 
    Last updated on: 07 Oct 2008 06:32:31 AM by Guru | Views: 11652 | Category: Sql Server |
    To make SQL Queries Case Sensitive using Collation. You can make SQL Queries Case sensitive at the column level or Table level or DataBase level
    Deeraj
    Generating XML from relational database tables 
    Last updated on: 07 Aug 2008 07:44:53 AM by Deeraj | Views: 10322 | Category: Sql Server |
    This article describes how to generate XML string from relational database tables.
    Hardcoder
    Getting all stored procedures from a database 
    Last updated on: 04 Jul 2008 12:12:12 AM by Hardcoder | Views: 6720 | Category: Sql Server |
    Hi all, Here how you can get all the stored procedure from a database. Hey not only the name but the stored procedures definitions also.
    SheoNarayan
    Implementing Custom Paging in ASP.NET with SQL Server 
    Last updated on: 25 Jun 2008 08:00:45 PM by SheoNarayan | Views: 18191 | Category: Sql Server |
    Many a times we need to present bulk data to the user in our day to day application development. Loading all data at one shot is okay when we have few hundreads data but when it comes to thousands of thousands records, it hardly work. In scenario like this we need to go for custom paging in our application.
    Chinnu21
    Difference between TOP clause in SQL 2000 and SQL 2005 
    Last updated on: 23 Apr 2008 06:51:45 AM by Chinnu21 | Views: 22057 | Category: Sql Server |
    Generally TOP clause is used to perform SELECT on top n results. This feature of TOP is extended in SQL 2005 so that we can also use expression apart from int, bigint and percent to perform query and also extended to be used in UPDATE and DELETE statements.