SQL Feeds - All your SQL feeds in one place.

Wednesday, June 09, 2010

Sponsor

Identifying query compile/runtime parameter values using XML SHOWPLAN output.

by Peter Scharlock via Microsoft SQL Server Development Customer Advisory Team on 6/9/2010 6:50:51 PM

I recently returned from Convergence 2010; the annual North American Microsoft Dynamics User Conference in Atlanta. It was a really great conference with many Customer, Partner, and Microsoft presentations and success stories. It was inspiring to see what Microsoft Dynamics products are being used for in the real world. I presented a number of sessions focused on Dynamics/SQL performance, and it became very apparent to me that XML SHOWPLAN, a highly useful feature of SQL Server, is not well unde ...

[ read more ]

Friday, May 28, 2010

SQL Azure Customer Best Practices

by Michael Thomassy via Microsoft SQL Server Development Customer Advisory Team on 5/28/2010 4:46:00 AM

The SQLCAT team and the SQL Azure team have been working closely together with a number of customers even before we launched our CTP (Community Technology Preview) in November, 2009 at the PDC (Professional Developers Conference).  After our production release in January, 2010, we’ve continued working with some interesting customers and have captured a number of great learnings in these best practice documents.  We’ve posted 6 best practice documents to the SQL Azure d ...

[ read more ]

Friday, May 21, 2010

Just added - NEW SQL Immersion Event in Bellevue, WA - in August

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

It's official! We're doing another 5-day SQL Immersion Event (our ever-popular 5-day Deep Dive into Internals, Performance and Maintenance) this year in the US! We decided to have a class near Seattle because Washington is *fabulous* in August! The class will cover our best content in these areas: On-disk structures: how the data is stored Index internals: how the data is organized Logging and recovery: how the data is protected Choosing the RIGHT Data Ty ...

[ read more ]

Thursday, May 20, 2010

Full-text query in local languages

by Kun Cheng via Microsoft SQL Server Development Customer Advisory Team on 5/20/2010 11:46:00 PM

Author: Kun ChengReviewer: Alexei Khalyako Last week, I was presented with an interesting Full-text search problem, which I like to share with you, especially the ones who need to support international markets with SQL Server Full-text solution. The issue was that the customer application not able to find target strings as part of their routine test cycle. Note this customer is planning to enter Asia market with support of local languages. The unit test of Chinese language failed because of the ...

[ read more ]

Wednesday, May 19, 2010

CurCmd in TDS DONE token

by SQL Protocols via SQL Protocols on 5/19/2010 6:20:00 AM

Several customers approached us asking what are the possible values for CurCmd in TDS DONE token. The TDS DONE token is defined at http://msdn.microsoft.com/en-us/library/dd340421(PROT.13).aspx. Similar rules apply to DONEPROC and DONEINPROC. In the TDS protocol, we have: CurCmd The token of the current command. The token value is provided and controlled by the application layer, which utilizes TDS. The TDS layer does not evaluate the value. As it says, we don’t put the possible value in ...

[ read more ]

Tuesday, May 18, 2010

A new and improved sp_helpindex (jokingly sp_helpindex8)

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 5/18/2010 8:33:00 PM

OK, I first blogged about re-writing sp_helpindex here as sp_helpindex2 (April 2008). Shortly thereafter (Aug 2008), a reader found a bug and when I went digging, so did I (a couple of others). I did a few tweaks and the version that's stuck for the past couple of years is in this blog post: Updates (fixes) to sp_helpindex2. However, as much as I've used that - I've always been frustrated by its output. And, so, over the months+, I wrote sp_helpindex3 (this solely added the index ...

[ read more ]

TDS traceflags in SQL Server

by SQL Protocols via SQL Protocols on 5/18/2010 6:40:00 AM

Microsoft SQL Server has a traceflag framework through which users can set specific server characteristics or to switch on/off a particular behavior. For details about how to use traceflags, please refer to http://msdn.microsoft.com/en-us/library/ms188396.aspx In this blog, I will introduce two useful traceflags related to TDS, -T4052/-T4055.-T4052 can be used to print the TDS packet sent to client (i.e. output) to console.-T4055 can be used to print the TDS packet received (i.e. input) to conso ...

[ read more ]

Sunday, May 16, 2010

Determining the position of search arguments in a join

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 5/16/2010 9:17:00 PM

As a follow-on discussion to my SQL Server Magazine Q&A titled “Determining the position of search arguments in a join” where I was responding to a reader question about whether or not search arguments could be moved up into the FROM clause instead of placed in the WHERE clause and whether or not it would improve performance. While I was so focused on creating a scenario to highlight the problems when doing this, I missed a great point about what happened in my specific exa ...

[ read more ]

Tuesday, May 11, 2010

Resolving DTC Related Waits and Tuning Scalability of DTC

by MikeRuthruff via Microsoft SQL Server Development Customer Advisory Team on 5/11/2010 6:31:00 PM

Author: Mike Ruthruff Contributors: Gert Drapers, Fabricio Voznika Reviewers: Prem Mehra, Jimmy May, Kun Cheng During a recent performance lab we encountered a large number of waits related to the use of distributed transactions.  The specific application being tested used COM+ components and made heavy use of DTC transactions managed by MSDTC.  Each component was marked as either “requires a transaction” or “supports a transaction”.  This resulted in all of the database calls ...

[ read more ]

Thursday, April 22, 2010

Procedure cache and optimizing for adhoc workloads

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 4/22/2010 5:50:00 PM

I mentioned that servers receiving a lot of dynamic constructs (typically those generated by client SQL generaters/ORM/LINQ, etc.) can start to consume too much plan cache and have problems with "single-use plans" in my last post titled: Statement execution and why you should use stored procedures. I also mentioned that SQL Server 2008 has an option/feature specifically to help reduce the bloat on the plan cache by only storing a query plan hash the first time a plan is created. Fi ...

[ 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