SQLServerCentral Editorial: Doing What It Takes To Get The Job Done
I wrote Doing What It Takes To Get The Job Done about a conversation with my nephew working late to...
2014-04-15
441 reads
Writing a Question Of The Day–More Notes
Today I wrote another question based on an error message. I included the error message in the question this time...
2014-04-15
497 reads
SQL Server First Aid
If you take basic first aid, say a CPR course, you’ll learn a handy mnemonic for the primary assessment you...
2014-04-15
1,125 reads
[SQL Snacks Video] SQL Server Table Partitioning 102
Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first...
2014-04-15
632 reads
Overview of Published Articles – 2014Q1
Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an...
2014-04-15
496 reads
A ever-increasing Clustered Key value doesn’t scale!
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-15
1,437 reads
SQL Server 2000 || Disable sa login
Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable...
2014-04-15
2,000 reads
Rounding versus truncating
Be careful when implicitly converting data types in T-SQL. Directly assigning 1.5 (either as a FLOAT or a NUMERIC) to...
2014-04-15
1,061 reads
Optional Parameters Causing Index Scans
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
744 reads
Listing the SQL Server SysAdmins With PowerShell
A very short blog today just to pass on this little script.
I was required to list all of the SysAdmins...
2014-04-14
542 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Tmn. Harapan Indah Telp:0821°8200°233
Telp/Wa 628218200233 Komp. Taman Harapan Indah Blok EE No.1, RT.14/RW.7, Jelambar Baru, Kec. Grogol...
Alamat BCA KCP Rajawali Telp:0821°8200°203
Telp/WA 628218200203 Rukan Multiguna, Jl. Rajawali Selatan Raya Blok C5. 2, Blok 2, Pademangan...
Alamat BCA KCP Mangga Dua Mal Telp:0821°7555°651
Telp/Wa 628217555651 Mal No. RM, Jl. Mangga Dua Raya No.49, RT.1/RW.12, Mangga Dua Sel.,...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers