Request More Information

We are hiring!

Xtivia, Inc.
2012 North America Liferay Partner of the Year

Join our top-notch team of Enterprise Java and Liferay Portal professionals in our Austin, TX office or work remotely! Please check out our current Dice listings.

Recent Bloggers

Brian Fairchild
Posts: 19
Stars: 0
Date: 5/16/13
Luke Smith
Posts: 8
Stars: 0
Date: 5/13/13
Mangesh Mharolkar
Posts: 10
Stars: 0
Date: 5/7/13
Barrie Shaw
Posts: 4
Stars: 0
Date: 4/17/13
Andrew Dalby
Posts: 2
Stars: 0
Date: 4/5/13
Tina Xing
Posts: 1
Stars: 0
Date: 3/29/13
Kaushik Nagaraj
Posts: 7
Stars: 0
Date: 3/27/13
Asier Del Pozo
Posts: 3
Stars: 0
Date: 3/27/13
Chris Shaw
Posts: 1
Stars: 0
Date: 2/26/13
Bin Zhu
Posts: 4
Stars: 0
Date: 2/24/13

Tags


Entries with tag execution plan .

The Value of Expertise

3/22/12 1:55 PM
  As a DBMS SQL Server is a powerful, cost-effective, and simple-to-use DBMS able to service the needs of most small-to-medium size businesses right out-of-the-box without professional management by a DBA.  In fact, a recent survey reported that 45% of IT personnel responsible for managing their company’s SQL Server instances are not trained database administrators instead...
Read More About The Value of Expertise »
By Ron Johnson
940 Views, 0 Comments
xtivia administration sql server performance tuning replication migration enterprise environment mean time to recovery sql replication data replication database high availability database failure backup strategy health check sql server performance execution plan poor performance microsoft sql server sql server 2000 ssis sql dedicated administration connection micosoft query tuning io performance loading data indexes

Sordid Sniffing

12/8/11 3:22 AM
  While recently conducting a performance analysis for a client I, again, came across an interesting phenomenon relating to plan caching and the potentially sordid effects of parameter sniffing on performance. Parameter sniffing allows SQL Server to create an execution plan for reuse by analyzing the parameter values passed during the first execution of a SPROC.  The...
Read More About Sordid Sniffing »
By Ron Johnson
1723 Views, 0 Comments
Blog Topics: Databases sql server execution plan performance implications poor performance
Showing 2 results.

Request More Information