Hi....

I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....

 

Cool Stuff:
1.SSMS: now you can take output copy into excel with heading. SSMS Tips and Tricks
http://blogs.msdn.com/billramo/archive/2009/05/15/dat315-session-review-for-ssms-tips-tricks-session.aspx

2.SSMS: Code Collapse and Expand Feature in SQL Server Management Studio 2008
http://blogs.msdn.com/buckwoody/archive/2009/07/30/code-collapse-and-expand-feature-in-sql-server-management-studio-2008.aspx

 

3. Directly Opening a Solution in SQL Server Management Studio

edit 10262009

4. another cool stuff on SSMS my engine team:

1.Query Hints can failed due to:

 

Maximum Row size.

reason:hash join is not order preserving and sort requires a work table (so work table size should not be 8060)

hash joins (and merge joins) require at least one equijoin predicate.  Thus, the query with the HASH JOIN hint fails.

http://blogs.msdn.com/craigfr/

 

2.SELECT (NOLOCK) block INSERTs

 

3. Performance impact: Linked server security configuration and how it can hurt you
if have DBCC SHOW_STATISTICS access:"User must own the table, or be a member of the sysadmin fixed server role, the db_owner fixed database role, or the db_ddladmin fixed database role." will run fast (check the stats and retrieve the data accordingly)

update(09222009)

If you use linked server queries, you need to read this….

 

4.Using DateDiff can query performance problems in SQL 2005 and 2008
http://blogs.msdn.com/psssql/archive/2009/07/17/using-datediff-can-query-performance-problems-in-sql-2005-and-2008.aspx

 

5.Donot shrink log file.
http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/27/oh-the-horror-please-stop-telling-people-they-should-shrink-their-log-files.aspx

 

Thanx..

 

Vinay