More IMPORTANT miscellaneous info
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.
Okay,...
2012-04-19
1,272 reads
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.
Okay,...
2012-04-19
1,272 reads
In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to...
2012-04-19
3,966 reads
When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...
2012-04-19
1,027 reads
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen...
2012-04-19
640 reads
Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...
2012-04-19
3,289 reads
I've run across several incidents in the last couple of months regarding something that is typically called "tribal knowledge." This is...
2012-04-19 (first published: 2012-04-12)
1,302 reads
As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.
I've added the following features:
The query execution...
2012-04-19
3,463 reads
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE...
2012-04-19
34 reads
Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any...
2012-04-19
1,516 reads
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to...
2012-04-18
2,172 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
CSTelpon : 0853-73737551 Perumahan Citra Raya Blok KD.02 No. 10, 15, RW.Mardigrass, Mekar Bakti,...
Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota Depok, Jawa Barat 16454
CSTelpon : 0853-73737551 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24,...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers