This script scans all DB-s in the instance & send result to the email. I use sp_MSforechdb function & missing index finding script what i found here https://technet.microsoft.com/en-us/magazine/jj128029.aspx
2016-03-28 (first published: 2016-03-23)
1,069 reads
2016-03-25 (first published: 2015-01-30)
2,715 reads
From a plain text containing multiple instance names you can deploy EXCEL files to report just changing your query text
2016-03-24 (first published: 2016-03-08)
1,218 reads
This script will parse a list of names copied from the To box of an Outlook email.
2016-03-23 (first published: 2015-07-20)
1,841 reads
Merge replication conflicts 'upload insert failed' and 'download insert failed' cannot be resolved using Conflict Viewer alone. Here's a script that will semi-automate the process for most conflicts
2016-03-21 (first published: 2016-03-03)
1,114 reads
A script I can run after deployment to refresh views and force a recompile due to modified DDL.
2016-03-18 (first published: 2016-03-03)
602 reads
This was used to alert on VLF counts to high due to replication log reader having issue reading the transaction log.
2016-03-17 (first published: 2016-03-02)
906 reads
This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!
2016-03-16 (first published: 2016-02-25)
1,126 reads
This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.
2016-03-15 (first published: 2016-02-25)
1,657 reads
A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.
2016-03-14 (first published: 2016-02-25)
846 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers