Browse by Tags
All Tags » SQL ( RSS)
-
2,720 Views
Comments
Writer: Paul S. Randal (SQLskills.com) Contributors: Sanjay Mishra, Prem Mehra Technical Reviewers: Darmadi Komo, Vineet Rao, Gopal Ashok, Kimberly L....
-
Comments
In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive...
-
Comments
Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate...
-
Comments
When we talk to Data Warehouse customers – they often raise questions about the star joins improvements SQL Server 2008. Star join is a set of optimizations that provide some interesting performance gains in data warehouse workload. Instead of digging...
-
11,698 Views
Comments
Writer: Thomas H. Grohser (=tg=) Contributor: Lindsey Allen Technical Reviewers : Sanjay Mishra, Lubor Kollar, Stuart Ozer, Thomas Kejser, Juergen Thomas...
-
5,532 Views
Comments
Writer: David P. Smith (ServiceU Corporation) Contributors: Ron Talmage (Solid Quality Mentors); Sanjay Mishra, Prem Mehra Technical Reviewers: James Podgorski...
-
8,126 Views
Comments
Writer: Sanjay Mishra Contributors: Marcel van der Holst, Peter Carlin, Sunil Agarwal Technical Reviewers: Stuart Ozer, Lindsey Allen, Juergen Thomas,...
-
16,106 Views
Comments
SQL Server Techical Article Published: May 2009 Authors: Jimmy May ( MS IT Assessment, Consulting, & Engineering (ACE) | bio ), Denny Lee Contributors...
-
6,765 Views
Comments
Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel Technical Reviewers: Jerome Halmans, Fabricio Voznika...
-
7,482 Views
Comments
Published : November 2008 Writers : JC Cannon, Denny Lee Contributors / Reviewers : Andy Roberts, Ayad Shammout, Dan Jones, Craig Gick, Jack Richins, Raul...
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
