Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Things to consider...

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
 
3. Directly Opening a Solution in SQL Server Management Studio
edit 10262009
4. another cool stuff on SSMS my engine team:
Caution:
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.
 
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….
 
 
 
Thanx..
 
Vinay

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.