2011-03-04 (first published: 2011-02-21)
6,172 reads
Scripts
Monitoring Resource Governor Memory Grants
A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.
2011-03-03 (first published: 2011-02-14)
3,213 reads
Search for a text in all databases
This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.
2011-03-02 (first published: 2008-01-25)
5,118 reads
2011-03-01 (first published: 2011-02-18)
4,076 reads
Columns Explorer - With constraints create / drop scripts (no cursors)
Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.
2011-02-28 (first published: 2011-02-18)
1,625 reads
String tokenizing / splitting
We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.
2011-02-25 (first published: 2011-02-09)
2,066 reads
2011-02-21 (first published: 2011-02-05)
1,969 reads
2011-02-18 (first published: 2011-01-25)
3,092 reads
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,544 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,966 reads
Blogs
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
Forums
Layanan BCA KCU TASIKMALAYA Telp:0817°82°5533
Telp/Wa 62817825533 Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kota Tasikmalaya, Jawa Barat 46124
Layanan BCA KCU PURWAKARTA Telp:0821°8200°203
Telp/Wa 628218200203 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta,...
Layanan Resmi BCA KCU DAGO Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers