One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.
2010-12-10 (first published: 2009-01-28)
33,829 reads
Three contests from Red Gate Software are coming next week. Get a hint about what might be coming and set a reminder on your calendar.
2010-12-10 (first published: 2010-12-08)
1,539 reads
Cross-posted from a Goal Keeping DBA blog:
Just recently, my oldest son entered the ranks of the teenagers. I shouldn’t actually...
2010-12-10
2,038 reads
I’ve been pretty quite since the PASS Summit and with good reason. Every year we have a chapter leader meeting....
2010-12-10
618 reads
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.
2010-12-10
4,645 reads
A look at what's happening with the SQLServerCentral servers based on the public information exposed by SQL Monitor.
2010-12-09
1,727 reads
Normalization is standard practice in database design, however, an over-normalized database can have issues. This article examines the case for denormalization.
2010-12-09
4,755 reads
The call for speakers is open through December 15, 2010, and I hope many of you will take the chance...
2010-12-09
1,187 reads
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
2010-12-08
1,206 reads
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?
2010-12-08
4,723 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers