Ok, continuing from my post last night about the ‘Run as Administrator’ bug in SSMS, here’s the other half of what I had to do to get Reporting Services running on Windows 7 Home Premium. The whole issue was that the account I was using did not have permissions to… Read more
[Edit] Since writing this, I've realized that the true reason behind this was that my account was not a member of the System Administrators Role in SSRS. Once I adressed that (see this post for details), I no longer had to run SSMS as an administrator to modify roles. This… Read more
The April meeting went well. I had hoped that the prospect of a couple of Technet subscriptions would increase attendance a bit for this meeting, but it doesn't seem to have done so. On the bright side, that meant my competition for them was less and I managed to walk… Read more
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
New Posts on SSC Forums: Got a bit behind on this one as I really wasn’t posting until about a month ago. I’ve found that with the… Read more
A reminder to anyone in the Brevard County Florida area:
The SCSUG monthly meeting is at 6:30 on Thursday, April 8th at the SCCU HQ featuring Herve Roggero ( Blog | Twitter). Herve will discuss SQL Server performance and best practices on indexing, the new indexing capabilities of… Read more
Totally pointless, but fun. Run it to decode the message.
DECLARE @Message varchar(20)
SET @Message = '????????????'
DECLARE @Decode Table(
INSERT INTO @Decode(DSeq, DKey)
Decoder AS (
SELECT D.DSeq N,
CHAR( D.DKey + ASCII(SUBSTRING(@Message,D.DSeq,1)) ) DV
FROM @Decode D),
Conc (S) AS…
When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient or that you should be doing things a different way. While that is true, there's a flip side to this. In a perfect world, you would always do things the… Read more
I started blogging a few months ago and since I started writing my own blog, I've been a much bigger follower of other technical blogs. I now follow over 25 SQL blogs and add more on a regular basis. Some of the blogs I follow are updated every day and… Read more
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog post to explain the differences in functionality between these two and provide some code for working with them.
- fn_get_sql returns the last *statement* executed, where as DBCC INPUTBUFFER returns…
If you read my last post, you may have noticed that my images now include boxes, balloon text and highlighting. This is due to a friend insisting the he couldn’t live without Snagit for blogging or documentation and that I simply must try it. I figured I’d sign up… Read more
Here are many different thoughts/facts/preferences on aliasing. Most of this applies to column aliasing. Regardless of whether or not you like aliasing tables, you should still be aliasing columns. If you do happen to be one of the people who is against table aliasing (some of you may be… Read more
Now that I have several posts on what you can do with a Tally table, I figured I'd share my favorite way to create one inline. I still prefer to have a physical tally table (usually in a Utility database that can be accessed from anywhere and doesn't need to… Read more
My trip to the meeting, short as it was, involved some of the worst driving conditions I've ever personally encountered. It was coming down in sheets and I was doing 40mph on I-95. Before you roll your eyes about how I'm one of "those guys", note that only… Read more
David will be speaking about how to troubleshoot performance issues on SQL Server 2005 and SQL Server… Read more
Dealing with delimited lists (Usually separated by a comma) in SQL is a problem easily handled by a simple function and a Tally Table. (Tally tables are also often referred to as Numbers tables or spt_values tables. If you still don't know what that is, please see this excellent article Read more
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that ISNULL attempted to convert the second parameter to the data type of the first parameter where as COALESCE converted according to the Data Type Precedence table. A reader requested… Read more
There are a lot of arguments about which of these to use. In my opinion, they both have their place. Here are a few facts about the two functions.
- ISNULL can accept only two arguments where as COALESCE can accept any number of input parameters
- ISNULL is not ANSI standard…
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a forum topic on it because I didn't know what the difference was. This post will join a small army of other places on the net devoted to correcting this misunderstanding.… Read more
After a while, most people who work with SQL have accumulated quite a few scripts that they use for investigation, troubleshooting, commonly requested ad hoc queries etc. I've seen people suggest a few different methods for keeping this 'script library' available on several different machines. Some people recommend saving everything… Read more
This is something that most people eventually need for reporting purposes. This function uses a Tally table to 'clean' a string, removing anything you don't specify in the @Rep parameter. In the case below, I remove everything but letters, numbers, spaces, commas and periods. This is a slightly modified… Read more