Find the second work day of the month

RIL_button( “http://sqlconcept.com/2012/02/22/find-the-second-work-day-of-the-month/”, “Find the second work day of the month” );

Just some fun with T-SQL.
Recently someone asked me to write a code which answers the question if today is the second business day of the month or not.
Here is a version of the code. If you have better ideas for doing this, feel free

Continue reading [...] Find the second work day of the month [...]

February 22nd, 2012 | Category: T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (4 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

SQL SERVER TRANSACTION ISOLATION LEVELS

RIL_button( “http://sqlconcept.com/2012/02/06/sql-server-transaction-isolation-levels/”, “SQL SERVER TRANSACTION ISOLATION LEVELS” );

SQL SERVER TRANSACTION ISOLATION LEVELS

by Mukiibi Ivan

On a busy day, our streets are given order by the traffic police, they keep the traffic flowing and they also keep motorists safe. Maximum safety can be ensured by only allowing one person to use a junction at a time.
Unfortunately, if

Continue reading [...] SQL SERVER TRANSACTION ISOLATION LEVELS [...]

February 6th, 2012 | Category: Database Objects, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (4 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

SQL Server Interview Questions and answers - earning the honor of thinking - Book Review

RIL_button( “http://sqlconcept.com/2012/01/29/sql-server-interview-questions-and-answers-earning-the-honor-of-thinking/”, “SQL Server Interview Questions and answers – earning the honor of thinking” );

Reading books is a very labor-intensive task (well, at least when taken seriously!).

It is not easy for several reasons:

We have to figure out the level of the book according to our knowledge level
We have to question the book’s title
We have to

Continue reading [...] SQL Server Interview Questions and answers – earning the honor of thinking [...]

January 29th, 2012 | Category: Book Review, SQL Server Architecture, SQL Server Wishlist, T-SQL | 3 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (6 votes, average: 4.83 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

« Newer Entries  
  Older Entries »