When using the BETWEEN operator on multiple columns, you are likely using a 2D range query. Such queries perform very poorly in SQL Server. This article examines rewriting these queries for improved performance.
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the data bar looks like something that I could really use. Can you provide an example of how to use this in a report?
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
Would you want to be part of a Strike Force or "A-Team" in IT? Steve Jones thinks most of us would rather just do a good job and go home.
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
Today we have a guest editorial from Andy Warren that asks you to look forward to the next year and think about your future.
This article shows how to slipstream the SP and CU during the SQL Server setup process.
This week Steve Jones talks about the need for people working in technology to be professional students. Get a few ideas of what you can learn this week from Database Weekly.
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;