Ever have a Reporting Services (SSRS) subscription that didn’t fire off as you thought it should? Or was SQL Agent offline when subscriptions should have been fired? Or did you just create a subscription and want to find out if it’s been configured properly? Fortunately all of the information is sitting neatly and plainly in … Continue reading I Didn’t Receive My Subscription
Category: SQL Server
Find Query Plans That May Utilize Parallelism
When ever I go to a new client to assist with performance issues, I inevitably download the Troubleshooting Performance Problems in SQL Server 2005 white paper. In my opinion and many others, it is one of those documents that should be at the click of a button to open and I keep it handy on … Continue reading Find Query Plans That May Utilize Parallelism
Big Tempdb Table
This won’t be the most exciting post. But hey, it’s Monday! What’s exciting about that? Maybe someone will bring in donuts. Or maybe I should since I am still on my couch and not headed to the office yet. Anyways, every now and then I need a big table to test some code out on … Continue reading Big Tempdb Table
Rounding Up to the Nearest 1,000
A co-worker came over and asked how to round up to the nearest 1,000. He tried to use ROUND but found that it always split between going up or going down depending on the value and the report he was working on always had to round up. Almost before he finished asking, actually before he … Continue reading Rounding Up to the Nearest 1,000
Troubleshooting Permission Issues with CREDENITIALS
I keep hearing this story and similar variations… ”On a dark and stormy night, I developed a SQL Server Integration Services (SSIS) package. It worked wonderfully on my desktop development environment. All the files were properly accessed and the data was processed in a magnificent matter.” ”But suddenly I deployed the SSIS package to production … Continue reading Troubleshooting Permission Issues with CREDENITIALS
UPDATE – ORDER BY and Deadlocking
I was working on a deadlocking issue a few days ago at a client The transaction that was continuously getting deadlocked utilized three SQL statements to checkout and return rows from a queue for the client’s application. Before going into the problem here’s a little code to setup the tables for the examples: The SQL … Continue reading UPDATE – ORDER BY and Deadlocking
DMV Version of sp_who2
I put together a presentation on Dynamic Management Views (DMVs) a few months back and one of queries I put together for that presentation was a version of sp_who2 that provided similar results but used DMVs instead. The query has most of the same columns as sp_who2 with some additional items that I found useful … Continue reading DMV Version of sp_who2
The OVER() Clause
Thought I'd share a cool trick I picked up a while back with the OVER() clause. Typically you’d use this clause with the PARTITION BY or ORDER BY arguments with the ranking functions released with SQL Server 2005. The OVER() clause though can also be used to do aggregations with a SELECT statement without a … Continue reading The OVER() Clause
Search Cache For Execution Plans
Updated content at - Really Search Cache For Execution Plans Sometimes when I am working with clients I need to take a look at execution plans for different stored procedures. Rather than digging around with SQL Profiler or executing the stored procedures with what I think might be the parameters I like to '”return to the … Continue reading Search Cache For Execution Plans
Raw Data
Every now and then I need to put together demonstrations. I don’t usually like to “invent” data and like to look for sources of raw data on the internet. A friend forwarded me a link to http://www.google.org/flutrends. The site has a download for current and historical flu trends by state. Cool site and even cooler … Continue reading Raw Data
Strate SQL 