2010-04-30 (first published: 2010-04-26)
5,320 reads
Scripts
Slow SP with date parameters solved.
when you use datetime parameters in SPs in the where clause the SP becomes very slow
2010-04-28 (first published: 2010-04-26)
2,909 reads
Database State and Backup Information
Displays the current database state, the last backup taken, it's size, and days since the backup.
2010-04-22 (first published: 2010-04-20)
2,294 reads
Disable / Enable All triggers on all tables in sql server 2005
Hi Sqlers,
Paramenter @Action, which will be Enable or disable to perform the requested action on triggers accross all tables in your sql db, this works on tables with schemas as well.
2010-04-19 (first published: 2010-04-14)
1,133 reads
2010-04-15 (first published: 2010-03-28)
15,127 reads
DBA Tools: sp_whocpu
The Stored Procedure sp_whocpu shows cpu_delta - a metric I introduced to define the real time CPU activity
2010-04-14 (first published: 2010-03-28)
3,608 reads
DBA Tools: sp_whoio
The Stored Procedure sp_whoio shows DiskIO_delta - a metric I introduced to define the real time I/O activity
2010-04-12 (first published: 2010-03-28)
3,879 reads
Check status of HEAP tables
This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!
2010-04-09 (first published: 2010-03-09)
2,229 reads
2010-04-06 (first published: 2010-04-01)
3,948 reads
2010-04-02 (first published: 2010-03-18)
2,153 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
Layanan Resmi BCA KCU A. YANI Telp:0821°8200°203
Telp/Wa 628218200203 Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282
Layanan Resmi BCA KCU BANDUNG Telp:0817°82°5533
Telp:Wa 62817825533 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
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