|
Sponsored Links
Resources
.NET Research Library
Get .NET related white papers, case studies and webcasts
|
News
News
News
|
Messages: 0
Messages: 0
Messages: 0
Printer friendly
Printer friendly
Printer friendly
Post reply
Post reply
Post reply
XML
XML
XML
|
 |
TechTalk: Kimberly L. Tripp on Developing for SQL Server
Kimberly L. Tripp talks about indexing best practices and what developers should know about SQL Server management. She also discusses stored procedure and parameterized queries caching, the new availability features in SQL Server 2005, and the SQL Server CLR.In terms of indexes, I think the most important thing that people can do is learn what the base structures look like and that means determine whether or not your table should have a clustered index or not. In many cases, the clustered index being put on an identity column can be a really good choice for performance because it minimizes fragmentation and all of the secondary uses of nonclustered indexes can be a lot more efficient when the clustered index is static, narrow, and unique. If I just say start with the base structure that’s you’re clustered index, probably choose a clustered index on an identity column and then help your performance through secondary indexes, which is nonclustered, kind of my best practices. The conversation turned toward the debate over stored procedures vs. parameterized queries and she pointed out that they both share the same pitfalls.It’s a great question actually and I am a big fan of stored procedures, especially because I can control that. You can really look at a variety of different ways in which data and objects and queries are cached, that’s kind of the first thing to look at. When you send a statement ad hoc to SQL Server what does SQL Server do and SQL Server evaluates that statement and determines whether or not it is safe. There is this whole process where SQL Server will look at the statement and try to figure out if it is safe enough to parameterize and save in cache so that subsequent users can benefit from a precompiled statement. The other option is to do forced statement caching, which is often done through sp_executesql, which is a parameterized statement where when its sent to the server, SQL Server automatically chooses its plan and caches it and subsequent executions use that same plan and then there are stored procedures. When you execute a stored procedure, the first execution generates this plan and subsequent users get that same plan. With sp_executesql and stored procedures, they both re-use plans and they both have the same negative, which is if the plan that’s chosen on the first execution isn’t good, then subsequent users suffer through that bad plan as well. She also discussed SQL Server 2005 and what it would means in terms of availability as well as how she sees the CLR on SQL Server and HTTP Endpoints being used.How do I see that used and I’ve had this question, people have said, “Do I see SQL Server turning into an application server” and no I don't. Watch Kimberly L. Tripp on Developing for SQL Server
|
|
|
| |
|
| New content on TheServerSide.NETNew content on TheServerSide.NETNew content on TheServerSide.NET |
|
|
Language "mashups" will become more prominent, and developers will become polyglots, one programmer suggests.
SearchWinDevelopment.com offers an introduction to the language, performance, testing and data management improvements in VS 2008.
VBCode.com code snippets cover all aspects of application development, from data binding to security to the user interface.
Get up to date on XAML best practices with a variety of articles, tutorials and webcasts. [SearchWinDevelopment.com]
One team's experience with the VSTS DB edition suggests that it can improve workflow for dev teams. It also enhanced Agile efforts.
(June 24, Article)
Microsoft has begun to include DSL tools in the VSTS kit. A new book by Steve Cook and other VSTS team members helps set the stage.
(June 24, Article)
Cartoon: Be it ever so humble there is no place like your home after you get a Microsoft Home Server .
(June 18, Cartoon)
Microsoft's Thom Robbins says new technology to highlight in NET 3.5 includes AJAX, LINQ for both C# and VB, as well as tooling enhancements intended to ease the task of building WPF, WF and WCF apps.
(June 29, Podcast)
Venkat Subramaniam discusses AJAX bottlenecks, the tenets of Agile development and more. He spoke at the Ajax Experience.
(June 25, Tech Talk)
In the second of a two-part series, Michele Leroux Bustamente discusses design decisions related to the claims-based security model. Read the story and walk through the process for creating a set of claims-based utilities to encapsulate claims authorization at the service tier.
(May 24, Article)
Understanding why the Entity Framework exists and learning where it can fit into your projects can get you prepared for the eventual release early next year.
(May 10, Article)
Resource: This learning guide gives you quick access to useful links on Windows Communication Foundation security information.
(April 24, Article)
TSS.NET's Jack Vaughan spoke recently spoke with Microsoft's Brad Abrams to find out what he is seeing in the field and what the chefs in Redmond are cooking. Along the way he discusses patterns of AJAX frameworks.
(April 11, Article)
In a two-part series, Michele Leroux Bustamente explains how claims-based security is supported by WCF, and how you can implement a claims-based security model for your services.
(March 29, Article)
Windows Workflow Foundation is a new technology that many developers will need to get their heads around. In a brief excerpt adapted from Programming Windows Workflow Foundation: Practical WF Techniques and Examples using XAML and C#, K.Scott Allen considers aspects of workflow definition.
(March 22, Chapter Excerpt)
|
|
