2011-02-18 (first published: 2011-01-25)
3,060 reads
Scripts
Financial Month
This Script will return the respective financial month(Starts from April to March) for a calander month Input(Starts from January to April), May use for many Consolidated Financial Reports.
2011-02-16 (first published: 2011-02-05)
1,529 reads
(new) Kill ALL Connections To a SQL Database
Ever puzzled by the database "Currently in Use" error even though you thought all connections had been Killed? That’s because the wrong table SysProcesses was used.
2011-02-15 (first published: 2011-01-26)
3,938 reads
Query to get tables with no clustered indexes
Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)
2011-02-14 (first published: 2011-01-28)
1,845 reads
2011-02-11 (first published: 2011-01-31)
2,940 reads
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,745 reads
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,378 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,104 reads
2011-01-28 (first published: 2011-01-11)
1,799 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)
875 reads
Blogs
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers