2017-09-26
1,193 reads
T-SQL
When sp_HelpText is not so helpful!
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,789 reads
2017-09-22
1,141 reads
2017-09-21
932 reads
2017-09-18
1,174 reads
2017-09-12
1,033 reads
SQL Data Aggregation Aggravation
When we have to deal with and store a lot of data, it makes sense to aggregate it so that we store only the information we actually need. If we get this right, this works well, but the design of the system takes care and thought because the problems can be subtle and various. Joe Celko describes some of the ways that things can go wrong and end up providing incorrect, inaccurate or misleading results.
2017-09-12
3,866 reads
2017-09-05
1,105 reads
Statistics in SQL: The Mann–Whitney U test
Phil Factor shows how to use the Mann-Whitney U test in SQL to to find out whether two samples come from the same distribution.
2017-09-04
4,456 reads
2017-08-31
1,150 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
ActualExecute
IT's OK I've create a stored procedure ActualExecute which is the TSQL script equivalet...
BCA Finance Seasons City Layanan Mobil. Tlp/wa:085373737845
Seasons City Mall, Jalan Prof. Dr. Latumenten V No.33 Lt LG, RT.13/RW.1, Jemb. Besi,...
BCA KCP Pasar Minggu Center Call Cs: (+62 821°3111°179
Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota...
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