Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.
This is a deep dive developer session that explores error handling in SQL Server. The session focuses on core error handling areas such as understandign the anatomy of errors, detecting errors in TSQL and best practices for error handling and defensive programming in Microsoft SQL Server. tuesday, 1/26, 8:00am EST
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
While looking through the new features and improvements in SQL Server 2008 Management Studio (SSMS) we found a potentially interesting one called Activity Monitor. Database developers and Database Administrators can use Activity Monitor to get a quick overview of an SQL Server 2008 system performance. Can you give us a detailed explanation of how we go about using Activity Monitor?
What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
Phil Factor believes that we have become so immersed in the idea that administrators or accountants can run technical enterprises, unaided, that we are in danger of forgetting the vital creative contribution of the technologist.
Phil Factor points out the limitations and irritations of Hungarian Notation.
Microsoft SQL Server 2008 R2 introduces a number of interesting new features for both DBAs and developers alike. Read on to learn our top 10 favorites.
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Jl. Boulevard Raya No.1 Blok L, Klp. Gading Tim., Kec. Klp. Gading, Jkt Utara,...
BCA KCP Mayestik Telpon/WA:08137887595.Jl. Kyai Maja No.77, Gunung, Kec. Kby. Baru, Kota Jakarta Selatan,...
Jl. Raya Pluit Utara. 85 Blok E Kav. No. 11, RT.4/RW.5, Pluit, Kecamatan Penjaringan,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers