Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 » T-SQL   (RSS)
Cannot find the source of a SQL Server error ?
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...
Posted: Friday, September 25, 2009 9:33 AM by Jens K. Suessmeyer | 0 Comments
Filed under: , , , ,
Database Programming: Did You Know IN Can Do This?
Ward Pond , one of the marvelous SQL geeks within Microsoft published a nice thing wich we had a discussion internally on concerning the capabilities of the IN operator: http://blogs.technet.com/wardpond/archive/2009/09/04/database-programming-did-you-know-in-can-do-this.aspx Read More...
Posted: Sunday, September 06, 2009 5:50 PM by Jens K. Suessmeyer | 1 Comments
Filed under: ,
Light weight SQL Server procedure auditing without using SQL Server auditing
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...
Posted: Monday, June 08, 2009 8:50 PM by Jens K. Suessmeyer | 0 Comments
Filed under: , , ,
The “magic” about trustable relationships with NULL and NOT IN
  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...
Posted: Monday, May 25, 2009 8:52 PM by Jens K. Suessmeyer | 1 Comments
Filed under: , , , ,
A long (but not missed) friend revisited, prefixing stored procedures with SP_
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...
Posted: Tuesday, April 28, 2009 7:59 AM by Jens K. Suessmeyer | 2 Comments
Filed under: , , , , ,
When is random “random enough” ?
An interesting question came up in a private conversation. If you want to pick a random value from a random generated result set and want to make sure that the row is really random, is the known ORDER BY NEWID() really random enough ? The point is that Read More...
Posted: Wednesday, April 08, 2009 8:19 AM by Jens K. Suessmeyer | 2 Comments
Filed under: , , ,
Why you shouldn't´trust the friendship of NULL and the (NOT) IN predicate
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...
Posted: Saturday, March 07, 2009 7:33 AM by Jens K. Suessmeyer | 7 Comments
Filed under: , , ,
Determine the current status of a SQL Server Agent job
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...
Posted: Thursday, January 08, 2009 9:36 PM by Jens K. Suessmeyer | 1 Comments
Filed under: , , , ,
Tedious trigger generation getting simplified
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...
Posted: Thursday, January 08, 2009 11:50 AM by Jens K. Suessmeyer | 0 Comments
Filed under: , , ,
Page view tracker