Welcome Guest, Login | Register
Home | Medical | City Info | Image Gallery | Babies Name | Utilities | Poetry | Recipe | Joke/SMS | Articles | Hostel | Trade Events| MPDarshan
 
:: Article Categories ::
Business (11)
Careers (4)
Cars & Bikes (1)
Computer Games (1)
Computers (27)
Current Affairs (11)
Database - MSSQL (4)
Education (7)
Electronics & Gadgets (37)
Environment (4)
Finance & Economics (14)
Food & Agriculture (1)
Government & Politics (7)
Health & Healthcare (46)
Indian Culture (6)
International (10)
Management (2)
Media & Entertainment (3)
Others (1)
Programming - ASP.Net (15)
Programming - JavaScript (2)
Science & Technology (5)
Sports (6)
Travels & Holidays (5)
दादीमाँ के नुस्खे (16)

:: Database - MSSQL ::
 
Few important tips to improve SQL Server database design and performance
Best performance is the main concern to develop a successful application. Like a coin database is the tail side (back-end) of an application. A good database design provides best performance during data manipulation which results into the best performance of an application.

During database designing and data manipul..   Read
posted by Shankar Das @ 10:37PM on date 23-08-2013
Views (276)
0 comments
COPY_ONLY Backups with SQL Server
Problem
One issue with creating backups is that the LSNs (log sequence numbers) get stored in the backup files and these LSNs are referenced when you do a restore of your database. The reason the LSNs are stored with the backup file is to verify that the backup files are being restored in the proper sequence wh..   Read
posted by Shankar Das @ 8:31AM on date 18-06-2013
Views (280)
0 comments
Improve SQL Server Performance with Covering Index Enhancements
Clustered Index
------------------------------
--Only 1 allowed per table
--Physically rearranges the data in the table to conform to the index constraints
--For use on columns that are frequently searched for ranges of data
--For use on columns with low selectivity

Non-Clustered Index
------------------------..   Read
posted by Shankar Das @ 1:41PM on date 16-05-2013
Views (366)
0 comments
SQL SERVER – CURSOR – A SIMPLE EXAMPLE
What is a cursor?
Cursor is a variable in SQL Server Database which is used for row-by row operations. The cursor is so named because it indicates the current position in the resultset.

Let us look this example.
Here I am just taking 2 columns from a table and passing through the cursor and printing them. ..   Read
posted by Shankar Das @ 10:33PM on date 04-01-2013
Views (323)
0 comments
:: Most Popular ::
 
Improve SQL Server Performance with Covering Index Enhancements
Clustered Index
------------------------------
--Only 1 allowed per table
--P..   Read
Views (366)
0 comments
posted by Shankar Das on date 16-05-2013
SQL SERVER – CURSOR – A SIMPLE EXAMPLE
What is a cursor?
Cursor is a variable in SQL Server Database which is u..   Read
Views (323)
0 comments
posted by Shankar Das on date 04-01-2013
COPY_ONLY Backups with SQL Server
Problem
One issue with creating backups is that the LSNs (log sequence n..   Read
Views (280)
0 comments
posted by Shankar Das on date 18-06-2013
Few important tips to improve SQL Server database design and performance
Best performance is the main concern to develop a successful application. Like a..   Read
Views (276)
0 comments
posted by Shankar Das on date 23-08-2013
Valid XHTML 1.0 Transitional   Valid CSS!
esagar.com © 2009-2011 All rights reserved | Powered by Das Consultancy Services