 |
| Transaction Locking & Isolation
|
|
|
|
|
|
Retrospective Deadlock Analysis using Extended Events
There are several methods for tracing/obtaining deadlock information, but little in the way of retrospective analysis without pre-existing trace flags or profiler traces. In this article, Jonathan shows us another alternative, this one using the new Extended Events feature introduced in SQL Server 2008 ... Source : Jonathan Kehayias - SQLServerCentral.com
Deadlock MasterClass
A fantastic 3 part series from Bart on Deadlocks ... Source : Bart Duncan - MSDN.com - Blog Post
Lock Escalation
In this post, Sunil covers lock escalation - what it is, how to disable it and warnings about the side effects of doing so ... Source : Sunil Agarwal - SQL Server Storage Engine Team - Blog Post
Row Level Versioning & Database Concurrency
This white paper focuses on concurrency enhancements in SQL Server 2005. On the server side, it covers all the features of SQL Server that leverage RLV technology. These include the new features: Snapshot Isolation, Multiple Active Result Sets (MARS) and Online Index Rebuild. RLV is also used in SQL Server 2005 to support database triggers, so the differences in trigger behaviour between SQL Server 2000 and 2005 are also discussed. On the client side, concurrency enhancements covered include concurrency in CLR objects, transaction control from the new SQL Native Client, Windows Enterprise Services and queued components, and concurrency using Service Broker enabled applications ... Source : Microsoft.com - Technet Article
Previously committed rows might be missed if NOLOCK hint is used
This blog post from Lubor Kollar explains some of the lesser known issues around the NOLOCK hint ... Source : Lubor Kollar - SQL Server Customer Advisory Team - Blog Post
Partition-level lock escalation in SQL Server 2008
In this blog post, Paul discusses the new Partition Level locking option in SQL Server 2008. He begins ... "Lock escalation in SQL Server 2005 and before only allowed table-level lock escalation. If you have a partitioned table with queries going against different partitions, then table-level escalation is a pain because the whole table is suddenly locked and concurrent queries against distinct partitions can't run. SQL Server 2008 gives the ability to escalate to a partition lock, which won't affect the queries on the other partitions" ... Source : Paul S Randal - SQLskills.com - Blog Post
Snapshot Isolation
One from the archives. In this article titled 'Another Version of the Truth', Peter Ward explores the Snapshot Isolation feature introduced in SQL Server 2005, and how it can be used to reduce blocking and deadlocks by enabling applications to read a previous version of a row when the row is locked by another transaction ... Source : Peter Ward - sqlpass.org - article
Version Based Transaction Isolation
Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications ... Source : Microsoft.com - MSDN Article
MERGE statement with Optimistic Concurrency
If I was a Gartner analyst, this one would be titled something like "Merging the old and new; Exploiting Synergies for Elegant Design". I'm not sure what Synergy Exploitation involves (I'm not sure it's legal either!), but this probably comes close. In this post, Simon describes combining new features in SQL Server 2008 (MERGE and Table Valued Parameters) with the classic optimistic locking design to enable the passing of multiple rows into a stored procedure for insert/update (i.e.; merge) into an existing table, and as per the optimistic locking methodology, if ANY of the rows have changed, the whole operation is aborted. Very nice. ... Source : Simon Sabin - SQLBlogcasts.com - Blog Post
|
|
|
|
|
|
|
|
|
Performance Impact of Procedure Calls without Owner Qualification
Linchi tests the best practice recomendation that all procedures calls should include the owner prefix e.g.; exec dbo.procname instead of exec procname ... Source : Linchi Shea - SQLblog.com - Blog Post
Data Tier Generator
Generates SQL Server scripts for stored procedures and C# classes used to access those stored procedures ... Source : codeplex.com
Top 10 SQL Server 2008 Features for ISV Applications
A good overview of a number of new features in SQL Server 2008 which will benefit ISV applications ... Source : SQLCAT.com - Top 10 Lists
ABAPERLS
If you use Visual SourceSafe for version control, Erland's ABAPERLS tool should be on you radar. Amongst *many* other features, it enables an empty database to be built from sql files in SourceSafe and the ability to general insert statements from Excel workbooks ... Source : Erland Sommarskog - sommarskog.se
Presentation Logic; Database or App?
Do you format dates in stored procedures or an application layer? This post from Jonathon Kehayias (and a follow up post from Alexander Kuznetsov) talks about the pros and cons of each technique ... Source : Jonathan Kehayias - SQLBlog.com
Using the Management Studio T-SQL Debugger
In this screencast, SQL Server MVP Paul Nielsen walks us through the new T-SQL Management Studio debugger ... Source : Paul Nielsen - screencast.com
Free the Data Dude
Data Dude is now included for free with the Developer Edition of Visual Studio Team Edition. Amongst other things, this means that functionality such as Stored Procedure Unit Tests and Data Generation processes are now available (and free) to a large number of Developers. Good Stuff ... Source : Andy Leonard/Greg Low - SQLBlog.com
The DBA's Guide to the SQL Server .NET Common Language Runtime (CLR)
This whitepaper helps the DBA determine appropriate use of this new feature and guidance on when other alternatives may provide better performance, flexibility or capabilities. As well as offering guidance on suitable uses for the Database Engine .NET Framework Programming API this whitepaper also suggests code, change and release management processes that should be tailored to each DBA’s individual circumstances to ensure a professional and safe deployment ... Source : SQLskills.com
Data Modelling
The "Art or Science" club grows by the day. Hugo discusses the latest member … Data Modelling ... Source : Hugo Kornelis - SQLblog.com - Blog Post
Best Practices for Semantic Data Modelling for Performance and Scalability
Another great whitepaper from the SQLCat team; "This paper covers some of the issues that can arise when it is difficult to decide whether to use an object-oriented or relational approach to designing the database. It includes approaches to improve performance and scalability" ... Source : SQLCat.com - Whitepaper
Database Profiler
Need a tool to inspect the quality of an unknown database to assist in estimating development time? Check out this tool on CodePlex ... 'The Database Profiler enables you to analyze (profile) unfamiliar databases, to get an overview about the data quality, and to highlight predictable problems before they appear' ... Source : Codeplex.com
1753, Pope Gregory XIII and SQL Server DateTime
Half history lesson, half SQL Server; this post from Conor explains why the datetime data type cannot store dates earlier than 1753 ... Source : Conor Cunningham - sqlSkills.com - Blog Post
CLR Integration Security
SQL Server now integrates the user-based security model of SQL Server with the code access-based security model of the CLR. Some of the advantages of this combined approach to security are discussed in this link ... Source : Microsoft.com - MSDN Article
Giving Permissions through Stored Procedures
In this Blog post, SQL Server MVP Erland Sommarskog covers the major methods for granting users permissions to database objects in SQL 2005; Ownership Chaining, Signing Procedures with Certificates, Using impersonation with EXECUTE AS, Application roles and Application proxies ... Source : Erland Sommarskog - Blog Post
Schema Comparison with Visual Studio Team Edition for Database Professionals
A great article from Dinesh Priyankara that highlights the Schema Compare feature in Visual Studio Team Edition for Database Professionals (Data Dude) ... Source : sql-server-performance.com - Article
Library of Free Data Models
Over 450 data models are available for free at this site. These are great as a Kick Start to your modeling project ... Source : databaseanswers.org
Visual Studio Team Edition for Database Professionals
In this blog post, Gert Drapers talks about the Visual Studio 2008 version of Data Dude, aka "Visual Studio Team Edition for Database Professionals" ... Source : Gert Drapers - Blog Post
What Microsoft Visual Studio 2005 Team Edition for Database Professionals Can Do for You
This article provides an overview of the latest addition to the Microsoft Visual Studio Team System: Visual Studio 2005 Team Edition for Database Professionals ... Source : Microsoft.com - MSDN Article
A Security Overview of Microsoft Visual Studio 2005 Team Edition for Database Professionals
To integrate database development into the overall life cycle most effectively, you must understand the variety of security implications in Team Edition for Database Professionals. These implications include how to set up and configure the product more securely, how to use the security-related features of the product, and best practices for a more secure implementation of your database projects ... Source : Microsoft.com - MSDN Article
XML Best Practices for Microsoft SQL Server 2005
Learn about the guidelines for XML data modelling and usage in Microsoft SQL Server 2005, and see illustrative examples ... Source : Microsoft.com - Technet Article
This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful ... Source : Microsoft.com - MSDN Article
Performance Optimizations for the XML Data Type in SQL Server 2005
This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005 ... Source : Microsoft.com - Technet Article
Sneak Peak - SQL Intellisense
In the spirit of continuing to wet your appetite for the next CTP of SQL Server 2008, I thought I would give you a glimpse of the T-SQL Intellisense functionality that is coming for SQL Server Management Studio ... ... Source : US ISV Developer Evangelism Team - Blog Post
SQL Server Data Services
A great interview with David Campbell, including an overview of the new SQL Server Data Services ... Source : Channel 9 - MSDN.com - Video
Application Patterns and database performance: Complex Screens
Complex screens can cause database performance problems when each control (grid, list box, etc) on the screen is treated as an individual object and is responsible for retrieving its own data. This pattern may seem too basic for experienced programmers, yet we still see it in production quite frequently ... Source : Kevin Cox - SQL Server Customer Advisory Team - Blog Post
Normalizing query text
It’s common for SQL Server application developers to want to “normalize” the query text returned in a Profiler trace such that executions of the same query with different parameters can be easily compared with one another and aggregated together. In this blog post, Ken blogs about a couple of approaches commonly used to normalize queries, and then discusses the sp_get_query_template that can assist with the process ... Source : Ken Henderson - Blog Post
Old vs New Conventional Wisdoms
Old: Power is free, but transistors are expensive. New: Power is expensive, but transistors are free. A great post from Linchi on a report from the Berkeley group that highlights how things have changed and how it will effect software development in the future ... Source : Linchi Shea - SQLblog.com - Blog Post
|
|
|
|
|
|
|
|
|
An Introduction to SQL Server Service Broker
This paper introduces Service Broker, a new feature in Microsoft SQL Server 2005. With Service Broker, internal or external processes can send and receive guaranteed, asynchronous messaging by using extensions to Transact-SQL ... Source : Microsoft.com - MSDN Article
Building Reliable, Asynchronous Database Applications Using Service Broker
Microsoft SQL Server 2005 Service Broker is a new platform for building distributed asynchronous database applications. Including an asynchronous, reliable messaging feature in the SQL Server database makes it possible to build a variety of database applications that were difficult, if not impossible, to build before ... Source : Microsoft.com - MSDN Article
Security Considerations for Service Broker
Discusses all aspects of Service Broker Security ... Source : Microsoft.com - MSDN Article
|
|
|
|
|
|
|
|
|
Find rows where any column is Null or Zero
How can you quickly without writing a bunch of OR statements determine if any columns have a NULL value, a value of 0 or if the value is 0 or NULL? ... Source : Denis Gobo - SQLblog.com - Blog Post
|
|
|
|
|
|
|
|
|
Getting Started with Spatial Data
The coming years will see a number of applications build to take advantage of the new Spatial features introduced in SQL Server 2008. In this post, John Paul Cook walks us through a quick and easy way to "see" spatial data using the sample AdventureWorks database ... Source : John Paul Cook - SQL Blog.com - Blog Post
Spatial Data. A niche or a tool for the masses?
In this blog post, Bob Beauchemin talks about the upcoming support for spatial data in SQL Server 2008. This new functionality makes it possible to integrate location awareness into just about any type of application ... Source : Bob Beauchemin - SQLskills.com
Demystifying Spatial Support in SQL Server 2008
This blog post contains a wealth of information on spatial data in SQL 2008 ... Source : Roger Doherty - Blog Post
|
|
|
|
|
|
|
|
|
30,000 columns per table?
I've seen and worked with some bad table and index designs in my time, but none of them bad enough to push the limits of SQL Server 2008 which is expected to support 30,000 columns and 1,000 indexes per table! In this blog post, Kimberly provides an overview of the supported column and index maximums per table in both 2008 and 2005 and why these limits *may* be required ... Source : Kimberly L. Tripp - SQLSkills.com - Blog Post
Sparse Columns
SQL Server 2008 introduces Sparse columns which allows columns containing NULL to consume zero space, even for fixed length columns. Combined with the increased number of columns supported in 2008 (30,000), sparse columns provide an excellent solution to common database design problems such as document repositories that require lots of attributes to be stored for lots of document types. In this post, Paul blogs about Pre-2008 solutions, and how the solution could be implemented using Sparse columns ... Source : Paul S. Randal - SQLSkills.com - Blog Post
|
|
|
|
|
|
|
|
|
|
Abusing Triggers
In this post, Aaron discussed some situations in which triggers are (and are not) appropriate ... Source : Aaron Bertrand - SQLBlog.com
Using Cross Joins to generate test data
Joe walks us through a novel approach to generating large test data sets ... Source : Joe Webb - SQLServerCentral.com - Blog Post
MERGE and OUTPUT
Adam explores the various uses for the MERGE command, including the power of its OUTPUT clause ... Source : Adam Machanic - SQLBlog.com
Can NOLOCK block inserts?
Yes, and Linchi demonstrates how this can occur ... Source : Linchi Shea - SQLBlog.com
Calculating the third Wednesday of the month
Alexander provides a (fast) solution to problems such as this using inline UDFs ... Source : Alexander Kuznetsov - SQLBlog.com
Un-named Defaults
In this post, Andrew covers several reasons why it's important to give default constraints a name ... Source : Andrew Kelly - SQLBlog.com
Grouped String Concatenation
Adam announces the results of his "Grouped String Concatenation" challenge ... Source : Adam Machanic - SQLBlog.com
TRY, CATCH, FAIL
In some (rare) cases, the CATCH block of a TRY-CATCH statement may fail to fire. In this post, Alexander walks us through one such example ... Source : Alexander Kuznetsov - SQLBlog.com
What the?
What looks odd here? select * from person where 'thomas' in (Firstname,LastName,LEFT(emailaddress,7)) ... Source : Denis Gobo - SQLBlog.com
Data type conversion
A timely reminder from Tibor to watch out for implicit data type conversion ... Source : Tibor Karaszi - SQLBlog.com
Paging T-SQL Results
How do you return a particular page of results with minimal overhead? Robert walks through a number of options before finishing with the lowest overhead approach ... Source : Robert Cary - SQLServerCentral.com
T-SQL debugger for SQL Server 2008
The first of Bill's three part series on using the T-SQL debugger in SQL Server 2008 ... Source : Bill Ramos - MSDN.com - Blog Post
Recursive Queries
Linchi answers one of life's great questions; How do recursive queries actually work? ... Source : Linchi Shea - SQLBlog.com
bit or char(1)?
Which camp are you in? Aaron makes his preference clear, but the blog comments suggest a few exceptions ... Source : Aaron Alton - The Hobt - Blog Post
T-SQL Enhancements in 2008
T-SQL Legend Itzik Ben-Gan takes us on a tour of the new T-SQL features in 2008 including MERGE, Table Valued Parameters, HIERARCHYID and lots more ... Source : Microsoft.com - MSDN Article
Using @@ROWCOUNT in Triggers
Steve warns us of the dangers of using @@ROWCOUNT in Triggers ... Source : Steve Kass - SQLBlog.com
T-SQL Formatter
There are a number of good T-SQL formatting tools out there, including this one which has a free web version ... Source : wangz.net
Table Variables Vs. Temp Tables
This post discusses and demonstrates some important performance differences between these two methods. Despite table variables avoiding compilations (and appearing "neater") sometimes the usage of a temporary table results in substantial performance improvements ... Source : Microsoft SQL Server Development Customer Advisory Team - Blog Post
Ranking Functions Compared
Aaron compared the function and performance of three ranking functions; ROW_NUMBER(), RANK(), and DENSE_RANK() ... Source : Aaron Alton - The Hobt - Blog Post
Solutions for Common T-SQL Problems
A great new site providing example code solutions for common TSQL problems. Examples include Controlling Return Results by Range, Incrementing an AlphaNumeric Value, and Creating a Comma Delimited List from a Column in a Table. Thanks to Denis Gobo for the link ... Source : Microsoft.com
Identity Columns - All the time?
Along with nulls, bits and natural keys, IDENTITY columns are guaranteed to get the conversation flowing. In this post, Aaron addresses some of the sweeping assumptions around this column property ... Source : Aaron Alton - The Hobt - Blog Post
Triggers to handle multiple records
Triggers enable flexible solutions to a variety of problems. Having said that, they're frequently misused, with arguably the most common problem being the failure to accommodate for multiple records, a problem Brent highlights in this blog post ... Source : BrentOzar.com - Blog Post
SET NOEXEC
A nice tip from Denis on using SET NOEXEC to determine if a script references invalid object names without actually running it ... Source : Denis Gobo - SQLBlog.com
Autonomous Transactions
Some nice tips from the ISV team on preserving the state of a committed inner transaction when the outer transaction rolls back ... Source : Microsoft SQL ISV Program Management Team - Blog Post
Stored Procedure Error Handling
As Alexander points out, mixing stored procedure error handling techniques sometimes leads to unexpected results ... Source : Alexander Kuznetsov - SQLBlog.com
Stored Procedure Best Practices
Everyone has their own Stored Proc layout and coding conventions (and occasionally stick to them!), but very few people go to the effort of documenting them to this level of detail. Whilst you may not agree with *all* of Aarons suggestions, he provides fantastic food for thought ... Source : Aaron Bertrand - SQLBlog.com
Trigger Finger
As Conor points out, Triggers are one of those very useful things that, if used for the wrong reasons in the wrong place, you'll end up shooting yourself in the foot (hence the name trigger?) ... Source : Conor Cunningham - SQLSkills.com - Blog Post
DateTime MasterClass
Everything you ever wanted to know about the DateTime datatype - hints, tricks, myths and more ... Source : Tibor Karaszi - Karaszi.com - Article
SQL Server 2008 - Datetime Data Types
Tibor's excellent article on the DateTime data type has been updated to include coverage of the significant enhancements introduced in 2008 ... Source : Karaszi.com - Article
Money vs. Decimal vs. Float
An interesting read comparing the performance and precision aspects of these 3 data types ... Source : SQLCat.com - Technical Note
Synonyms
An often overlooked but handy development feature is the Synonym. As Roman points out, we can use Synonyms to redirect data access when tables are renamed or moved to a different database or even server, all without having to change application or stored procedure code ... Source : Roman Rehak - searchsqlserver.techtarget.com - Article
Recursion and CTEs
Struggling to get your head around recursion and CTEs? Tony does a great job of explaining it in this post ... Source : Tony Rogerson - sqlBlogCasts.com - Blog Post
count(*) vs count(column) vs Count(1)
Conor points out the not so obvious differences between the various methods for counting rows in a table, and how NULL values effect the results. Also check out Conor's other post on the use of count(*) vs count(1) ... Source : Conor Cunningham - SQLSkills.com - Blog Post
Techniques for generating sequential numbers in SQL Server
This blog post from the SQLCat team talks about generating sequential numbers in SQL Server. They present commonly used techniques and how these techniques may not work under heavy load. An alternative is presented for high throughput environments ... Source : Howard Yin - SQL Server Customer Advisory Team - Blog Post
Performance of Scalar vs Table Valued UDF's
All UDF's are bad for performance. Well, not quite, as Alexander helps demonstrate in this great blog post ... Source : Alexander Kuznetsov - SQLBlog.com - Blog Post
Stored Proc Vs Adhoc
I'm firmly in the Stored Proc camp myself, but I still enjoy reading about the merits of Adhoc SQL …. ... Source : Peter Debetta - sqlBlog.com - Blog Post
How to rethrow errors in T-SQL
If you do application development and you're used to rethrowing errors in a catch block, you may have noticed that error handling in T-SQL still doesn't support this functionality. However, you can easily emulate this functionality by rolling out your own "rethrow" stored procedure ... Source : Roman Rehak - SQLblog.com - Blog Post
How can data-type choice affect performance?
In this blog posting, Paul talks about choosing the right data type depending on the expected field content, and how the choice can make a difference to performance. Should a column that holds a 2 digit state code be char(2) or varchar(2) ? ... Source : Paul S. Randall - SQLskills.com - Blog Post
Five Different Ways To Return Data From One Table Which Doesn't Exists In another Table
This blog compares methods for retrieving data in 1 table that doesn't exist in another. It covers Not In, Not Exists, Left/Right Outer Join, Outer Apply and Intersect. The last 2 are new in SQL2005 ... Source : Denis Gobo - SQLblog.com - Blog Post
Storing Intervals of Time with no Gaps
In this post, Alexander demonstrates a technique for ensuring stored time intervals don't overlap ... Source : Alexander Kuznetsov - SQLBlog.com
Table Valued Parameters
One of the cool new features in SQL 2008 is the ability to pass a table as a parameter to a stored procedure. In this post, Peter provides a code example of how this feature is used ... Source : Peter Debetta - sqlJunkies.com - Blog Post
Achieving Selective Uniqueness in SQL Server Tables
The SQLCat team discuss using indexed views to allow a unique index to be created on tables containing duplicate values (e.g.; NULL) for the column that requires the unique index ... Source : Lubor Kollar - SQL Server Customer Advisory Team - Blog Post
What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability?
In this blog post, the SQLCat team talk about options for making schema changes to databases with large amounts of data, and choosing techniques to minimise performance impacts. Part 2 of this blog post is here ... Source : Tom Davidson - SQL Server Customer Advisory Team - Blog Post
NEWID and NEWSEQUENTIALID
Denis discusses the new system function in SQL 2005, NEWSEQUENTIALID ... Source : Denis Gobo - SQLblog.com - Blog Post
NULL - The database's black hole
The blog about nothing ... Source : Hugo Kornelis - SQLblog.com - Blog Post
TSQL solutions for the classic {Top Per Group} problem
Adam blogs about common methods used for returning details relating to the top/bottom/min/max of a set ... Source : Adam Machanic - SQLblog.com - Blog Post
|
|
|
|
|
|
|
| Architecture & Scalability
|
|
|
|
|
|
10 lessons from 35,000 transactions per second
Paul Nielsen, author of the SQL Server Bible books, has spent the last 6 months on a contract developing a high transaction database system (~35K tps). In this post, he discusses the lessons learned covering agile development, test environments, application and database design, and index selection ... Source : Paul Nielsen - SQLblog.com - Blog Post
How SQL Server 2005 Enables Service-Oriented Database Architectures
Databases are a strategic part of a distributed architecture built using the Service-Oriented Database Architecture (SODA). This paper explores the concepts behind SODA and how SQL Server 2005 fits into this architecture ... Source : Microsoft.com - Technet Article
Service Oriented Database Architecture: App Server-Lite?
This paper describes the Service Oriented Database Architecture (SODA) developed for the Microsoft SQL Server DBMS. First, it motivates the need for building Service Oriented Architecture (SOA) features directly into a database engine. Second, it describes a set of features in SQL Server that have been designed for SOA use. Finally, it concludes with some thoughts on how SODA can enable multiple service deployment topologies ... Source : Research.Microsoft.com
SQL Server Scalability FAQ ... Source : Microsoft.com - Article
Internals, Troubleshooting, and Best Practices for use of Scaleout Technologies in SQL Server 2005
This white paper describes the internal details of SQL Server 2005 scaleout technologies, and suggests troubleshooting techniques for technical issues involved in scaleout. In addition, best practices are suggested for each technology ... Source : Microsoft.com - Technet Article
Solutions for Highly Scalable Database Applications: An analysis of architectures and technologies
Understanding the nuanced differences between two Relational Database Management Systems (RDBMS) products like Oracle 10g and SQL Server 2005 can be difficult for even the most seasoned database professional. In this paper, Performance Tuning Corporation compares and provides an analysis of the differences of these two RDBMS products in their ability to "scale-out" and "scale-up". From the paper, you will see how SQL Server 2005 supports both "scale-out" and "scale-up" while Oracle 10g offers "scale-out" only technologies ... Source : Microsoft.com - Whitepaper
Achieving Scalability & Availability with Peer to Peer Transactional Replication
Discusses the benefits and evolution of peer-to-peer transactional replication. It then outlines the steps for configuring a peer-to-peer topology and provides scripts and detailed directions for completing setup of this topology ... Source : Microsoft.com - Technet Article
Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005
This white paper describes planning guidelines and administration tasks to consider when implementing a scaleout solution with SQL Server 2005. Different scaleout features are compared to determine when to use a particular feature ... Source : Microsoft.com - Technet Article
A Rose By Any Other Name
Does having duplicate copies of the same stored procedure increase transactions/sec throughput? In this blog post, Linchi explains that the answer is most definately YES, depending on the load. He also mentions that this is a technique used in some of the TPC-C benchmark tests ... Source : Linchi Shea - SQLblog.com - Blog Post
Scalable Shared Databases
Shared Scalable Databases are a feature of SQL Server Enterprise edition to access the same database hosted on a SAN from several server instances. That means that read-only workloads can be scaled out by adding additional servers accessing the same database, and each server operates with it’s own CPU’s, RAM and TempDB ... Source : Microsoft.com - Knowledge Base Article
|
|
|
|
|
|
|