This Script reports locking on a particular database either to the console or to a database table. It also allows filtering based on a minimum locking level (say Page or Table and higher). Included is the CREATE TABLE statement to build the reporting table. This table can reside in any database but needs to be […]
2002-01-06
1,018 reads
We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.
2001-08-20
8,206 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Comments posted to this topic are about the item How Do You Patch 100...
Comments posted to this topic are about the item Microsoft SQL announcements at PASS...
Comments posted to this topic are about the item How to Develop Custom T-SQL...
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers