You have a reporting requirement where a user has two or more parameters for a single report, but the values for one parameter depend on the values chosen in a previous parameter. Ghanesh Prasad explains how to create cascaded parameters in SQL Server Reporting Services to solve this issue.
SQL Saturdau is coming to Tampa on February 28, 2015. This is a free training event for those wanting to learn about SQL Server. Register while space is available.
SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.
SQL Bits is Europe's largest SQL Server conference. They have experts teaching beginners, and beginners questioning experts, providing feedback and improving the event every year. Register with the code SSC-HERO to get a 15% discount on the ticket price!
Steve Jones talks about starting a new job and the need to get up to speed quickly, perhaps by being prepared on day 1.
What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query? Create the SQL code to score Ten-pin Bowling, of course. Dwain Camps explains the how, what and why.
How can we ship safe, and ship often? Steve Jones has a few comments on the need for better engineering.
SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.
Chris Testa-O'Neil on the origins of SQL Bits and the joys of community events.
If you are still on the edge about PowerPivot and have not given it a shot, this article will get you started with ample of screen shots and a step-by-step guide.
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
By Kevin3NF
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk...
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers