|
|
Browse by Tags
All Tags » sql (RSS)
-
In SQL Server, the cost of a particular plans is based largely on I/O, which makes this post a good candidate for this month’s T-SQL Tuesday , hosted by Mike Walsh who, like me, walks a straight path. In considering I/O – the movement of data generally Read More...
|
-
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 Read More...
|
-
Lots of blog posts for this month, for the first T-SQL Tuesday to leave the safe-haven of Adam Machanic’s blog . Some people obviously missed out, probably because they don’t read this blog, but I guess that’s the nature of the meme. Read More...
|
-
I’m feeling the pressure for this month’s T-SQL Tuesday , probably because I’m also the host. I’ll be posting a roll-up for it soon too, which I’m sure will be great fun researching. Given that the topic is on relationships, Read More...
|
-
It’s time for the third of Adam Machanic’s T-SQL Tuesdays, and this time, I’m the host. The first one , last December was on the topic of date/time, and the second was on Puzzling Situations. Check them both out, along with the round-ups Read More...
|
-
A recent discussion on Twitter about a query that Denny Cherry was looking at led to this post by Josef Richberg: http://josef-richberg.squarespace.com/journal/2010/1/28/is-a-case-statement-considered-sargable.html , and I thought it might be worth going Read More...
|
-
SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries. Incidentally – SARG is short for Searchable ARGument. Read More...
|
-
Earlier today you may have seen a blog post of mine about a puzzle involving HAVING . You should read that post before this one. It was part of Adam Machanic’s T-SQL Tuesday meme. The question was about the query: SELECT 'No Rows' WHERE 1=2 HAVING Read More...
|
-
Adam ’s hosting another T-SQL Tuesday, for which this post is jumping in. He’s themed it around T-SQL Puzzles , which I found quite interesting, because the world is full of them. Most of the questions that I answer on forums, help sites, and so on, are Read More...
|
-
Foreign Keys are great. For those of you who read some of my other posts, or heard me present on this material before , a foreign key can really help the Query Optimizer simplify out your query, because it knows that it must be able to find a match in Read More...
|
-
Far too often I see SQL code which uses apostrophes around column aliases, like this: SELECT ProductID, SUM(LineTotal) AS 'Total' FROM Sales.SalesOrderDetail GROUP BY ProductID; This is fine, but the worrying thing about this is if the user decides Read More...
|
-
There are so many places to ask a question these days. I get plenty of questions via MSN Msgr and email, and do my best to answer those of course. But there are many others too. I figured I’d list some of the ones that I frequent, and challenge some of Read More...
|
-
Grant Paisley of Angry Koala and Report Surfer put me onto this a while back, and I have to admit I’m a bit of a fan. The idea comes from the fact the way that SQL Server Reporting Services (both 2005 and 2008) handles parameters with Analysis Services, Read More...
|
-
To persuade your boss to embrace an upgrade to SQL 2008, you need to know which features have high Return On Investment. They may have seen presentations talking about features like Spatial, or MERGE (and been quite impressed), but they may well have Read More...
|
-
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 Read More...
|
|
|
|