Showing posts with label SQL Server 2008. Show all posts
Showing posts with label SQL Server 2008. Show all posts
Thursday, April 21, 2011

Does Referential Integrity improve performance?

›
I believe that everybody knows that Referential Integrity is for maintaining the relationship between two entities; Parent and Child. It mak...
1 comment:
Friday, January 14, 2011

MCTS: SQL Server Database Administrator – Maintaining a MS SQL Server Database 2008 – 6231A Course

›
Course 6231A: Maintaining a SQL Server 2008 Database – This is my first class for 2011. Class will be started on Sunday, 23rd January 2011. ...
Monday, October 25, 2010

Plan Caching in SQL Server 2008

›
I got many questions on the post I published “ Do we need to recompile Stored Procedures when an index is added or parameter value is vary g...
Thursday, October 21, 2010

Do we need to recompile Stored Procedures when an index is added or parameter value is vary greatly?

›
While Preethi was presenting his presentation on Query Plans at the SQL Server Sri Lanka User Group meeting, he showed a situation where que...
5 comments:
Wednesday, September 29, 2010

SQL Server 2008 Service Pack 2 is available for downloading

›
SQL Server 2008 SP 2 is available for downloading now. Enhancements includes; 15K partitioning Improvement Reporting S...

Table variable slower than Temporary table???

›
I used to use table variables when the resultset is smaller and want to hold it temporarily. The main reason for this selection is, data man...
Friday, September 10, 2010

SQL Server data compression: PAGE

›
Although the storage cost is going down, we still think about storage optimization because once optimized, it is not only about the cost, it...
Tuesday, July 27, 2010

SQL Server Sleeping Status and Connection Pooling

›
Are you seeing many “sleeping” status connections in your SQL Server? If so, have you ever thought to find out the reason for it? Is it norm...
7 comments: