Congratulations to all monthly
winners of November 2013
, they have won INR 3850 cash and 28495 worth gifts.
Welcome Guest !
Remember me next time
Tips & Tricks
HTML 5 Videos
> Sql Server
> Sql Server
Error and Resolution
Function Points (FPA)
News and Community
Pattern and Practices
Web Services, Remoting
An Interview Question
A Post in Forum
A Career Advice Question
A Product Catalog
An Interview Experience
A Coding Horror
Sql Server Articles - Page 1
Articles posted by registered members of DotNetFunda.com. You can also
post an article
win monthly prizes
as well as gain community
163 records found.
How to create and use the File and File Group in Sql Server 2008.
Last updated on: 05 Sep 2013 04:41:11 AM by
| Views: 1724 | Category:
This article will explain how to create and use the File and File Group in SQL Server 2008.
Understanding SQL Server User-Defined Functions (UDFs)
Last updated on: 26 Aug 2013 12:26:30 AM by
| Views: 1376 | Category:
In this Article we will learn about User-Defined Functions (UDFs) in Sql Server.
Missing Index Analysis and Creation.
Last updated on: 11 Aug 2013 03:39:34 PM by
| Views: 4536 | Category:
out of 5
We get little confused, when the word INDEX comes into the picture? We ask so many questions to our-self before creating a non cluster index, as far as the performance is concern.
A modified version of sp_helptext in SQL Server
Last updated on: 28 Jul 2013 04:23:03 PM by
| Views: 3685 | Category:
out of 5
One of the most favorite Microsoft shipped Stored Procedure is sp_helptext and it can be used very often in our daily development job. Here we are going to modify that sp's logic little bit to help us more efficiently.
Back Up and Restore a database using sql server
Last updated on: 25 Jul 2013 07:38:13 AM by
| Views: 973 | Category:
out of 5
This article will explain you how to restore the database and how to take an backup of our database file , different types of backup and how it will be used.
Let us learn ROLLUP function in SQL Server
Last updated on: 20 May 2013 11:18:13 PM by
| Views: 956 | Category:
In this article, we will understand the basic functionality of ROLLUP function.
Fundamentals of SQL Trace in SQL Server 2012
Last updated on: 02 May 2013 01:56:12 AM by
| Views: 1307 | Category:
out of 5
An SQL Server trace can be used to record events that you are interested in. You can create trace file and trace table workloads easily using SQL Server Profiler.
A Closer Look at the Restore and Recovery Process in SQL Server
Last updated on: 21 Mar 2013 12:07:25 AM by
| Views: 1343 | Category:
During the process of restoring SQL Server databases, data is copied from a backup and changes are then made to this data by applying logged transactions. Backups comprise transaction log records that can be used to roll forward any active transactions or roll back any uncommitted transactions to maintain transactional consistency in the database.
XML and XQuery in SQL Server
Last updated on: 03 Jan 2013 03:46:58 AM by
| Views: 1527 | Category:
XML Data type one of the important data types available in SQL Server, offers to declare variable and table columns to store data in the XML format, comes up with 5 main methods to use with the XQuery in SQL Server.
Global Variables in SQL Server - Part3
Last updated on: 08 Dec 2012 03:56:06 AM by
| Views: 1473 | Category:
Let's learn Global Variables in SQL Server.In my last articles we have already learned about Global Variables and we also learned first 20 global variables. This article is in continuation to the Global Variables in Sql Server Part-2
A handy SPROC for all DBA and developers
Last updated on: 02 Dec 2012 02:11:35 PM by
| Views: 1164 | Category:
out of 5
In an aim to save time and key strokes while writing codes.
Let us spend some time with sys.dm_fts_parser
Last updated on: 26 Nov 2012 10:37:27 PM by
| Views: 1862 | Category:
In this article we will learn about sys.dm_fts_parser dynamic management function
The culprit behind a TRANSACTION statement in SQL
Last updated on: 25 Nov 2012 05:32:06 PM by
| Views: 1563 | Category:
out of 5
Don't look at the title of this Article.. Really didn't get anything good to match up with the scenario so named something funny 'Culprit' :) We are going to look at the effects of using Transaction control in a DML statement(INSERT). I am gonna explain the topic with a real-time scenario.
How to set Primary Key and Foreign Key in SQL Server 2008
Last updated on: 18 Nov 2012 11:35:20 PM by
| Views: 2282 | Category:
This article will be useful for beginners of T-SQL to create Primary Key and Foreign Key in SQL Server 2008.
Let's learn Last_Value Function in Sql Server 2012
Last updated on: 12 Nov 2012 10:28:03 PM by
| Views: 1107 | Category:
In this article we will learn Last_Value function of Sql Server 2012 (Denali).
WPF Interviews .PDF
Download FREE WPF Interview Questions & Answers .pdf
Keep visiting for more ....
Winners & Prizes
Like us on Facebook
Top Articles Author
Thu, 12-Dec-2013 Authors
All Time Authors
(Statistics delayed by 5 minutes)
Write for us
If you find plagiarised (copied) content on this page, please
let us know
original source along with your correct email id (to communicate) for action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 12/12/2013 8:17:07 AM