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….
6. Try to avoid insert.. exec (for 2005 onwords):
Thanx..
Vinay
Advertisements
This entry was posted in Computers and Internet, Experts and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s