Welcome to MSDN Blogs Sign in | Join | Help

January 2005 - Posts

Wednesday, January 26, 2005 5:00 PM

Block-Buster: SQL 2005 and Blocking/Deadlocking

If you'd like some help in going to sleep at night, try thinking about how concurrency is controlled behind the scenes in SQL Server. No guarantees however: you may wake up in the middle of the night having nightmares about blocking and deadlocking. Seriously
Posted by cbiyikoglu | 1 Comments
Friday, January 14, 2005 2:21 PM

Ranking Functions, TOP and Aggregates

This is something I came across a few times within the last few weeks so thought I’d share the findings: You probably heard about ranking functions by now. However you may have a missed this great benefit ranking functions bring to easing a complex scenario:
Posted by cbiyikoglu | 4 Comments
Wednesday, January 12, 2005 7:04 PM

TSQL Exception Handling and Deadlocks

You probably hear about exception handling in TSQL already but here is a neat use of the feature: TSQL exception handling is very close to the top when it comes to popularity of the new TSQL features. The ability to handle exceptions without having to
Posted by cbiyikoglu | 1 Comments
Wednesday, January 12, 2005 7:00 PM

Soundcheck...

Testing 1,2,3... Quick Intro: I am a program manager in the ISV team in SQL Server development. I try to ensure SQL Server is well crafted to solve the underlying issues in the financial vertical. I've recently left the field organization where I worked
Posted by cbiyikoglu | 1 Comments
 
Page view tracker