Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main difference of those 2 is that Len() gets the...
2013-05-16
20 reads
Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main...
2013-05-16
1,330 reads
Magnify SQL Text with SSMS 2012
This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday....
2013-05-16
845 reads
Rated R (A Teaser)
How many lines of TSQL codes and Window Functions you need to come up with this?
With R, it takes about...
2013-05-16
915 reads
Lost Phone, Ring,Glasses,Etc, At the Office
If you work at a company with more than a 100 or so employees you probably get an email every...
2013-05-16
638 reads
From Google Reader to Feedly
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
2013-05-16
645 reads
DMV-11 : T-Log space used by transaction……..sys.dm_tran_database_transactions
sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms186957.aspx
Returns information about transactions at the database level.
Some time , T-log...
2013-05-16
2,018 reads
Xp_readerrorlog in SQL Server 2012
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...
2013-05-16
1,704 reads
Get Just The Tools: SSMS Download
Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools. For some reason,...
2013-05-15
963 reads
SSAS – Find Cube Database Name, Size,Status and Total Size of SSAS Server
We are planning to take SSAS cube database backup since our backup tool does full file system backup in case...
2013-05-15
10,884 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 Telp BCA KCP Bintaro +62 838-4945-0961
Wa:083849450961 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
Alamat Telp BCA KCP Kepa Duri +62 838-4945-0961
Wa:083849450961 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Training the next generation
Comments posted to this topic are about the item Training the next generation
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