Searching through SPs, Tables, Views
Find quickly all stored procedures, tables and views that are somehow related to the search term.
2011-02-09 (first published: 2011-01-28)
2,762 reads
Scripts
List all Columns in Server Part 2
Generates a list of Server, Database, Table , Column Names and properties
2011-02-08 (first published: 2011-01-31)
1,390 reads
Resend Failed Scheduled Reports on Demand in SSRS
This Stored procedure re-sends the failed reports subscriptions on Demand.
2011-01-31 (first published: 2011-01-12)
1,116 reads
2011-01-28 (first published: 2011-01-11)
1,807 reads
Resend the reports scheduled to send on today's date
This stored Procedure grabs the reports scheduled to run on today's date and reruns the subscriptions on demand.
2011-01-26 (first published: 2011-01-12)
886 reads
2011-01-21 (first published: 2011-01-11)
2,920 reads
SQL Function to get Max, Min values from given collection of values
This func returns the max value,min value and count of values from collection of values
2011-01-20 (first published: 2011-01-08)
1,777 reads
2011-01-17 (first published: 2011-01-05)
7,206 reads
2011-01-14 (first published: 2010-12-28)
1,564 reads
Scheduling Jobs for Random / Multiple Dates
I needed to run an ssis package / job on many dates that were not consistent and initially started creating dozens of job schedules before coming up with this idea...
2011-01-13 (first published: 2010-12-29)
1,268 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers