<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Guest Columnist: Roy Ernest DBA
SQLServerCentral.com profile
Items 1 to 3 of 3
Row Level Versioning
Row Level Version is one of the most coolest features introduced by SQL 2005.
Read more...
By
Roy Ernest DBA
2008/04/07
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
9,686 reads
Why Object Qualification is important.
You have all read about why object qualification is important. You also must have heard of why stored Proc should not have sp_ as prefix to the name. Now let us proove if this is all true.
Read more...
By
Roy Ernest DBA
2008/03/10
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
7,044 reads
Importance of UPSERT
A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.
Read more...
By
Roy Ernest DBA
2008/01/29
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
6,188 reads
Items 1 to 3 of 3
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
