EXEC xp_msver returns SQL Server version information plus server details like platform, language and file version, with no need to check Windows system info.
SQL SERVER – 2005 – Multiple Language Support
Multiple language support in SQL Server: sys.syslanguages holds the details for each language, including month and day names. One query lists them all.
SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full
Error 3260, an internal buffer has become full, hit one of our older servers many times. A reboot and more RAM for the server and SQL Server helped.
SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode
How we rename database copies on our development server: set it to single user mode, run sp_renamedb, then set it back. The file names do not change.
Scaling Out Read Queries
Scaling out read queries uses replicas, caches, and routing with measured freshness and operating cost; learn when each path fits.
SQL SERVER – UDF – Validate Positive Integer Function – Validate Natural Integer Function
A Jr. DBA at my company changed my integer check so it accepts only a positive integer. I share his udf_IsNatural function with a few test values.
Designing Tables for High Insert Rates
High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.