SQL server – ISNUMERIC and checking for valid numeric tyopes
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16,...
2012-01-30
1,076 reads
- Interests: Performance Tuning Database Servers, Running and Coffee
SQL Server - Generate SQL INSERT from Excel
Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested access to a Production database. The details were to COPY...
2012-01-27
1,078 reads
SQL Server – Error Logs recycle without SQL Server Restart
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming...
2012-01-26
734 reads
SQL Server - BACKUP LOG WITH NO_LOG
The BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY options are discontinued in SQL Server 2008.
There is no replacement for this...
2012-01-22
2,798 reads
SQL Server – Modifying Production Data Good Practise
Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...
2012-01-21
1,015 reads
SQL Cachestore flush
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL...
2012-01-20
1,185 reads
SQL Server – Powershell Excel to HTML
SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring...
2012-01-19
865 reads
SQL Performance Tuning - optimizing for response time
Different queries are optimized for different objectives
Response Times and Throughput are two standard objectives.
Response Time is about retrieving the hits...
2012-01-18
851 reads
Hungarian Notation is misunderstood
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
1,004 reads
SQL Agent Jobs – Schedule in seconds
1) How can I execute a SQL Server Agent Job every few seconds? Administrators try to use SQL Server Agent as...
2012-01-16
1,826 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 Pondok Ungu Bekasi Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Sultan Agung No.19-20 Kavling Blok A, RT.007/RW.007, Medan Satria, Kecamatan Medan...
Alamat BCA KCP Central Park Telp:0821°8200°203
Telp/Wa 628218200203 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren,...
Alamat BCA KCP Ruko Swadaya Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers