Browse by Tags
All Tags »
T-SQL »
SQL Server 2000 (RSS)
Ever had an error in your application and you couldn't find the source of all evil and where the error is thrown at the end ? Well, SQL Server profiler does a great job about that, but you really need to understand which events to filter for and how to
Read More...
A week ago a colleague asked for different options to do audit stored procedure calls. With his allowance I will post the question here. “The applications used at the customer site all access these databases using stored procedures ( only , as far as
Read More...
As a follow-up to my former post “ Why you shouldn't´trust the friendship of NULL and the (NOT) IN predicate ” I asked Paul Randal during our SQL Server Master training about the possible internal reason that the results can vary if you have NULL
Read More...
Coming as a simple sample with PBM (creating a policy with a condition that procedure names shouldn't´t start with SP_) and getting an interesting question in one of my classes, I wanted to revisit the question about the yet in some places existing naming
Read More...
A colleague had a problem concerning a query using the (NOT) IN predicate, use the following table creation script (attached to the blog entry) to see the effects of the problem and to repro it on your machine. Imagine you have two tables (not that hard
Read More...
Due to the problem that there is no definite table for getting information about the current status of jobs, I created a small procedure grabbing the information from parts of the internal procedures used to extract the very relevant information. As an
Read More...
While talking with a former colleague of mine, we were elaborating about methods for syncing databases in his company. After boiling down the scenario to a point where we excluded all sync technologies possible, we came down to good old triggers. As of
Read More...
