Browse by Tags

All Tags » T-SQL (RSS)
The problem To quote the online help: “…excluding trailing blanks”. The issue I was writing some position based datastrings using SQL server and was continually using the Len function to evaluate the total length of the string. This is a useful technique...
Posted by Mikael Sand | 1 comment(s)
Filed under:
Sometimes you come across these little code snippets that just makes you go: “Oh! I wish I was that smart”. I hope this has happened to you as well. Here is a very smart SQL snippet that solves the following dilemma: How do I detect gaps in a long series...
Posted by Mikael Sand
Filed under:
Ever asked this question: “I wonder if we access this table from any stored procedures?”. Well here is how to find out: SELECT distinct so.name, so.xtype FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%TABLE/COLUMN...
Posted by Mikael Sand
Filed under: ,
Today I started reading my new book but I also wanted to find out a bit more about Hyper V , just to do something else. Well it is quite simple: It is the new virtualization technique used in Windows 2008 Server R2. The cool thing (in my view) is that...
Posted by Mikael Sand
SQL-Server and I has had a bit of a fallout. I don't talk to it and it doesn't talk to me. A shame really since we used to be very close back in 2001. Today we once again stood face to face. I said: "Oh, you look good. You have changed, and...
Posted by Mikael Sand | 2 comment(s)
Filed under: ,