2008-12-15
4,277 reads
T-SQL
2008-12-09
4,054 reads
Power and Deception of CTEs
A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world
2008-12-01
9,168 reads
2008-11-27
4,111 reads
2008-11-26
5,056 reads
The Numbers Table
Having a table of just numbers can be very handy, and it doesn't necessarily take up much space in your database. New author Brandon Galderisi brings us a short tutorial on setting this up.
2008-11-24
10,783 reads
2008-11-20
3,743 reads
2008-11-18
4,500 reads
2008-11-14
13,486 reads
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
3,997 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kas Cipayung Tlpn/wa:085373737551
Jl. Bina Marga No.3, RT.6/RW.2, Cipayung, Kec. Cipayung, Kota Jakarta Timur, Daerah Khusus Ibukota...
BCA KCP Tebet Timur Telp/Wa:08218200174
Jl. Tebet Timur Dalam Raya Blok GG No. 97, Tebet Tim., Kec. Tebet, Kota...
BCA KCU MATRAMAN Tlpn/wa:085373737551
Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah Khusus...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers