Category Archives: Tips

Little Workaround in Report Manager

I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report), and from there clicking a link to generate and export a subreport (say, Individual Widget Report). The problem with this … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Random helpfulness, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips | 1 Comment

We Are TOTALLY Amused: A T-SQL Error

This has to be the best error I’ve ever seen: Msg 195, Level 15, State 10, Line 2 ‘SUM’ is not a recognized built-in function name. Uhm, I’m sorry to contradict you SQL Server, but yes it is. Here’s the code … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Random helpfulness, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL | 1 Comment

Search Argument Case Study: WHERE the year was 2002…

Content Rating: Beginner, Tips It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the boost a good index gives your query.  Here’s a quick demonstration of the power of a well-thought-out search clause … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Beginner, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL | 2 Comments