SQL Feeds - All your SQL feeds in one place.

Wednesday, April 21, 2010

Statement execution and why you should use stored procedures

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 4/21/2010 7:18:00 PM

OK, so, this is where we're at... When a client application makes a request to SQL Server there are a few ways in which they can do it: Submit an adhoc transact-SQL statement This statement can be parameterized and the parameterized statement can be deemed: Safe: These are statements where the optimizer has evaluated the plan and feels that changes to values will not affect the execution plan. And, there are quite a few rules that you must meet for ...

[ read more ]

Kilimanjaro Ships!

by Data & SQL Storage Performance Team via SQL Server Performance on 4/21/2010 7:42:34 AM

SQL Server 2008 R2 launches today! While the name “R2” sounds like an incremental update to SS2008 (or half of a Star Wars droid), in fact Kilimanjaro (the internal code name) is packed with big features. We’ve also got a lot to show for our work on performance and scalability. The four results at the top of the TPC-E performance chart are all on R2. This includes two results with more than 64 hardware threads, possible because of support added in Windows Server 2008 R2 and SQL Server 2008 R2 fo ...

[ read more ]

Subscribe

New Feed

Product Spotlight

Recently Updated Sources

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us