Giving Back, SQLMeetings.com Is Going Live Soon
I’ve been pretty quite since the PASS Summit and with good reason. Every year we have a chapter leader meeting....
Understanding and Controlling Parallel Query Processing in SQL Server
Data warehousing and general reporting applications tend to be CPU intensive because they need to read and process a large number of rows. To facilitate quick data processing for queries that touch a large amount of data, Microsoft SQL Server exploits the power of multiple logical processors to provide parallel query processing operations such as parallel scans. Through extensive testing, we have learned that, for most large queries that are executed in a parallel fashion, SQL Server can deliver linear or nearly linear response time speedup as the number of logical processors increases. However, some queries in high parallelism scenarios perform suboptimally. There are also some parallelism issues that can occur in a multi-user parallel query workload. This white paper describes parallel performance problems you might encounter when you run such queries and workloads, and it explains why these issues occur. In addition, it presents how data warehouse developers can detect these issues, and how they can work around them or mitigate them.
Certified Private Clouds
Microsoft is working to certify vendors to build private clouds, which Steve Jones thinks is a great idea.
What's Happening Here?
A look at what's happening with the SQLServerCentral servers based on the public information exposed by SQL Monitor.
Denormalization in SQL Server for Fun and Profit
Normalization is standard practice in database design, however, an over-normalized database can have issues. This article examines the case for denormalization.
SQLRally Call for Speakers Closes December 15, 2010
The call for speakers is open through December 15, 2010, and I hope many of you will take the chance...
Costing Cool Projects
Can you accurately determine the cost or benefit of a new, cool project up front? Steve Jones thinks not, but coming up with new projects can be a way to set yourself apart from others.
24HOP Needs Women!
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
Getting Started with Maps in SQL Server 2008 R2 Reporting Services
I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers