2010-12-27 (first published: 2010-12-10)
1,198 reads
Scripts
2010-12-23
3,492 reads
SQL CLR Function for Email validation and string Split
I have added 2 functions here, one for email validation and another to split the string by specified separator by user.
2010-12-23 (first published: 2010-12-11)
1,722 reads
SQL 2008 : Uncompressed Objects Procedure
A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.
2010-12-22 (first published: 2009-08-27)
984 reads
What Is Filling Up The Transaction Log
Report unusual conditions that may be filling up your transaction log.
2010-12-22
577 reads
Charpad - Character Padding Function
A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.
2010-12-20 (first published: 2010-03-31)
2,354 reads
Script to get a list of publications an article is in
Script to get a list of publications an article is in
2010-12-17 (first published: 2010-12-08)
3,810 reads
Index Fragmentation Status (includes Partitioned Tables/Indexes)
This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.
2010-12-16 (first published: 2010-04-22)
7,616 reads
Eval arithmetic statement function in SQL
This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.
2010-12-15 (first published: 2010-12-08)
1,086 reads
2010-12-14 (first published: 2010-11-30)
3,877 reads
Blogs
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...
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Forums
Alamat BCA KCU TANGERANG CITY Telp:0817°82°5533
Telp/Wa 62817825533 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal...
Alamat BCA KCP Moch. Toha Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Moh. Toha No.A 2, RT.001/RW.001, Pabuaran Tumpeng, Kec. Karawaci, Kota Tangerang,...
Alamat BCA KCP Karawaci Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Imam Bonjol No.18, RT.001/RW.003, Karawaci, Kec. Karawaci, Kota Tangerang, Banten 15115
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers