Exploring the Possible in Windows, Web and The Cloud
Translate This Page
Translate this page
Framework Master Class
Office & VSTO
Rock Paper Azure
SharePoint for Developers
Browse by Tags
Tagged Content List
Questions on Tuning SQL Queries
Sometimes I get questions about how to get better performance from a database. In working with SQL Server over the years and now SQL Azure this is not an uncommon question. In SQL 2008 and beyond the tools include a Tuning Wizard, which is great, but it relies on capturing a realistic sample of the database...
14 Mar 2012
How to Convert from Number Seconds to Time String in SQL Server
I’ve been working with a sample timer application on the Windows Phone to track our TechMasters meeting timings. In the user interface I capture the number of seconds that someone spoke, and I’d like to return the value of number seconds formatted as a standard looking time string. In SQL Server there...
24 Dec 2011
SQL 2008 Templates...a little more info
Last week in Kansas City while presenting the New Features of SQL 2008 for Developers session of MSDN Unleashed we had some questions of whether this is a new feature in this release. I mentioned that it isn't and has been part of the product since at least SQL 2005, and someone asked whether the keyboard...
17 Nov 2008
SQL Tuning Webcast
As promised I'm posting the code we used for doing some of our analysis for tuning SQL Server applications. In today's webcast we started out by assuming we didn't know much about the schema we were working with, so we captured a profile trace of what was running on the server (to simulate the server...
13 Nov 2006
Page 1 of 1 (4 items)
© 2013 Microsoft Corporation.
Privacy & Cookies