SQL Server Code,Tips and Tricks, Performance Tuning

A blog about SQL Server, Books, Movies and life in general

Wednesday, May 31, 2006

Unit Testing For The DB, Visual Studio Team Edition for Database Professionals Is Here

Microsoft Corp. today announced Visual Studio® Team Edition for Database Professionals, expanding Visual Studio 2005 Team System to include ...

Import Dates, Skip Bad Data By Using ISDATE() And CASE

›

You have a table with a 'date' column and it's stored as varchar, the problem is that you also have bad data in there You want t...

Tuesday, May 30, 2006

red-gate SQL Prompt: Intellisense for SQL Server

›

SQL Prompt™ Intellisense for SQL Server, plus other features There was a question on the SQL Server programming forum about intellisense and...

Monday, May 29, 2006

Chaos Isolation Level In SQL Server

›

The other day I posted SQL Server Teaser: Isolation Level So either no one reads this blog or no one knew he answer, or maybe you are too s...

2 comments:

Thursday, May 25, 2006

Populating A Dropdown With Weekly Dates

›

Let's assume you have a website and the user can pick from a date range, You want to be a nice guy/girl ( * reason for the asterisk is ...

Wednesday, May 24, 2006

Spatial Indexes In SQL Server 2005

›

Maybe you work with Oracle as well as SQL server 2005 and you use Oracle Spatial and Oracle Locator. Well there is a way to implement this i...

SQL Server Pics From Version 1.0 On

›

Euan Garden has posted pictures of the SQL server product boxes since version 1.0 Did you know version 1.0 came out on Floppy's for OS/2...

Tuesday, May 23, 2006

SQL Server Teaser: Isolation Level

›

In SQL server 2000 there are 4 isolation levels Read uncommitted which can produce a dirty read, a repeatable read and a phantom read Read ...

Monday, May 22, 2006

Cumulative Hotfix Package (build 2153) For SQL Server 2005 Available

›

So just after sp1 we already have a hotfix The following has been fixed SQL Server 2005 Post-SP1 hotfixes that are included in SQL Server 20...

Friday, May 19, 2006

Customers who bought this item also bought...

›

Customers who bought this item also bought....by now you probably know that I am talking about Amazon.com So let's try to implement our ...

Wednesday, May 17, 2006

List All Tables Without An Index

›

Here are 2 quick ways to list all tables in your database without an index The first query is using sysobjects and the second query is using...

Tuesday, May 16, 2006

SQL Compare Without The Price Tag

›

You want to know the differences between 2 tables but don’t have the money to pay for SQL Compare by red-gate software and your trial versio...

3 comments:

Monday, May 15, 2006

Convert Millisecond To "hh:mm:ss" Format

›

This question was posted in the Transact-SQL MSDN Forum You have a column in your table that stores duration in milliseconds You would like ...

1 comment:

Friday, May 12, 2006

Syntax Error Converting The Varchar Value To A Column Of Data Type Int

›

There was a question today on the microsoft.public.sqlserver.programming forum where a person had a problem with an in predicate The error t...

Changing The Schema Of A Table In SQL Server 2005

›

Since I am still in unpacking and putting up light-fixtures mode I decided to link to a cool post on the SQL Doctor's blog It covers the...

Thursday, May 11, 2006

String Or Binary Data Would Be Truncated

›

I have seen a couple of Google searches hitting this blog with the search 'String or binary data would be truncated' Basically what ...

Tuesday, May 09, 2006

Moved Into A New House

›

I have moved into a new house over the last week. If you are thinking of selling your house and buying a new one at the same time then eithe...