2014-07-10
2,278 reads
T-SQL
2014-07-08
2,529 reads
2014-07-07
2,150 reads
2014-06-05
2,349 reads
T-SQL User-Defined Functions: Ten Questions You Were Too Shy To Ask
SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get asked on the forums. It's a shame, because the answers to them tend to clear up some ingrained misconceptions about functions that can lead to problems, particularly with locking and performance
2014-06-04
7,408 reads
2014-05-23
2,262 reads
2014-05-12
2,135 reads
Paginating a SQL query result set
How to Paginate a query result set to keep from pulling the whole result set to the client side
2015-11-02 (first published: 2014-05-05)
3,713 reads
2014-04-09
2,246 reads
Divide and Conquer - Performance Tuning
Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance
2014-04-08
8,537 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Soepomo TLP/CS 08216977749
Alun Graha, Jl. Prof. DR. Soepomo SH No.233 Lt. Dasar, RT.007/RW.1, Menteng Dalam, Kec....
BCA KCP Gatot Subroto TLP/CS 08216977701
Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, Karet Semanggi, Kecamatan...
BCA KCP Santa TLP/CS 08216977749
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers