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,860 reads
Scripts
2011-02-11 (first published: 2011-01-31)
2,959 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,775 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,398 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,125 reads
2011-01-28 (first published: 2011-01-11)
1,818 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)
890 reads
2011-01-21 (first published: 2011-01-11)
2,922 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,789 reads
2011-01-17 (first published: 2011-01-05)
7,223 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers