Generating SubTotals using GROUPING
This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.
2012-11-16 (first published: 2010-07-13)
37,842 reads
Sunil Chandurkar
2012-05-07
2,541 reads
Find for SQL Objects, Entities or Text
Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.
2012-04-18 (first published: 2008-05-28)
2,950 reads
2011-11-17
2,500 reads
2011-10-10
2,757 reads
2010-10-28
3,111 reads
2010-03-25
4,396 reads
Generating charts in SQL Server Reporting Services
This article displays how we can place charts in reports created using SSRS.
2010-02-01
12,784 reads
Writing Dynamic Stored Procedure
In this article I have shown a way of writing queries in which WHERE clause of the query is executed dynamically depending on values of input parameters.
2009-06-01
19,340 reads
Blogs
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Data Governance: The Invisible AI Accelerator
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs
On January 9 I have done an online presentation about Exploring PostgreSQL for the...
Forums
Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...
PK violation in replication but only one subscriber
We have a publication with three subscribers; it's basically a part list with around...
Recovery Takes 10-20 mins with ADR enabled
Hi Experts, I have database about 300GB in size with ADR enabled but after...
Question of the Day
Data API Builder Operations
What types of database operations does the Data API Builder support?
See possible answers