Find Currently Running Query – T-SQL
Following script retrieves the queries currently executing on the server.
2016-02-29 (first published: 2014-09-04)
3,345 reads
Scripts
Validating null values in a column without using ISNULL or NVL.
We can check for null values using count.
2016-02-26 (first published: 2016-02-16)
1,182 reads
Cleanup old text files on the errorlog directory
SQL Agent job to cleanup all old text files on the errorlog directory.
2016-02-25 (first published: 2016-02-23)
460 reads
Change SQL Server Service Accounts with Powershell
If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.
2016-02-24 (first published: 2016-02-19)
6,323 reads
Orphaned login report for all databases
Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.
2016-02-23 (first published: 2016-02-04)
1,182 reads
NULLs to Not NULLs
Script finds char types columns defined to allow NULL values but have non NULL values and generates the ALTER statements for the changes.
2016-02-22 (first published: 2016-02-08)
1,011 reads
Grant EXECUTE on all user-defines types
Gives execute permission on all user-defined types for the specific user
2016-02-19 (first published: 2016-02-03)
772 reads
SQL Agent job to show SQL Server service details upon agent restart
To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.
2016-02-18 (first published: 2016-02-04)
729 reads
Enhanced Index Rebuild Script
Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.
2016-02-17 (first published: 2016-02-04)
1,815 reads
Restore Redgate Transaction logs files via SQL
The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.
2016-02-16 (first published: 2016-02-02)
504 reads
Blogs
A New Word: Immerensis
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Forums
SQL Server is terminating in response to a 'stop' request from Service error
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Database Files on Shares I
Comments posted to this topic are about the item Database Files on Shares I
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers