Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Query hints

Author  Topic 

abacusdotcom
Posting Yak Master

133 Posts

Posted - 2010-09-23 : 05:01:36
Morning Good people,

I am a core SQL server developer and some times have been having some performance issues with my code.

Until recent, I find me working on Telco data on oracle, you understand what I mean, working on CDRs, billings, etc. You know how voluminous data can look here, I was introduced how to use hints on oracle i.e */+ hint */, parallel, index, hash etc. I want to replicate same in SQL server. I have actually done some research on it, but want to hear from individuals that had used hints SQL servers.

Many thanks

I sign for fame not for shame but all the same, I sign my name.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-09-23 : 12:27:02
http://www.sql-server-performance.com/tips/hints_main.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -