Two weeks from today, Brent Ozar will be speaking at CBusPASS. This time around Brent will be presenting on Using Cloud-Based BI to Interpret Perfmon & Profiler Results. LiveMeeting will be available. There won’t be a dial-in number, though. Why? Because the sound will travel through Brent’s microphone, into a series of tubes, and [...]
Businesses have all kind of interesting rules for working with data. Sometimes these rules are incredibly easy to implement in the database. Sometimes these rules are incredibly to implement in the application layer. Sometimes, it’s difficult to construct these rules no matter where you are in the entire application stack.
I recently came across a situation [...]
SQL Server
Filtered Indexes: What You Need To Know Michelle Ufford dives into the wonders of filtered indexes and explains what they are, why you need them, and how you can go about using them. Makes me wish we were on SQL Server 2008 at work.
Use SQL 2008 Express as a Central Management Server Wish you [...]
The title of this blog is only half as thrilling as the SQL. I can assure you.
I have a calendar table at work that is based off of the calendar table that you can find on aspfaq.com in an article titled Why should I consider using an auxiliary calendar table?
The big problem is that the [...]
Did you know that you can use the OVER clause, in conjunction with PARTITION BY to find duplicate rows in the database?
Here’s a business case for you:
There is a table consisting of UserId, SiteId, and ClientId:
IF OBJECT_ID(‘window_test’) IS NOT NULL
DROP TABLE window_test;
CREATE TABLE window_test
(
UserId INT,
SiteId INT,
ClientId INT
);
Over [...]
