Showing posts with label SQL Server 2000. Show all posts
Showing posts with label SQL Server 2000. Show all posts
Tuesday, July 01, 2008

I tried to keep it a secret but it is all over the internet: I am a SQL Server MVP

›
So all over the internet is exaggerated,I became a SQL Server MVP today and was not going to do a blog post about it. However some other peo...
1 comment:
Thursday, June 26, 2008

Working On SQL Admin Hacks, Tips and Tricks

›
I haven't posted for a while because I have been working on SQL Admin Hacks, Tips and Tricks lately. it is still a work in progress but...
Tuesday, May 27, 2008

Interview With Erland Sommarskog About SQL Server and Transact SQL

›
I have interviewed Erland Sommarskog, you can find that interview here: Interview With Erland Sommarskog About SQL Server and Transact SQL E...
Thursday, May 08, 2008

How to log when a function is called?

›
This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The ...
Tuesday, April 22, 2008

How to rename a column in a SQL Server table without using the designer

›
If you have a table and you want to rename a column without using the designer, how can you do that? First create this table CREATE TABLE T...
2 comments:
Tuesday, April 15, 2008

Solutions for Common T-SQL Problems Wiki Launched

›
Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have launched a Wiki with Solutions for Common T-SQL Pro...
Monday, April 14, 2008

Use IDENT_CURRENT() to return the last identity value generated in all tables in a SQL Server Database

›
This is how you return all the tables with their last generated identity values in a SQL Server Database SELECT IDENT_CURRENT (table_name),...
Tuesday, April 01, 2008

Not An April Fool’s Joke: SQL Server 2000 Mainstream Support Ends In A Week

›
April 1st 2008 is the day on which support for SQL Server 2000 ends (and it is also my birthday) SQL 2000 SP4 - currently supported; support...
Friday, January 25, 2008

Tip: Find all The Rows Where Any Of The Columns Is Null Or Zero Or Both

›
This question is asked every now and then so I decided to do a little blog post. How can you quickly without writing a bunch of OR statement...
Wednesday, January 02, 2008

Use the *1 trick to do math with two varchars, this prevents the Invalid operator for data type. Operator equals subtract,type equals varchar message

›
Someone had code like this on the tek-tips forum DECLARE @v varchar (24) SELECT @v = '06029202400250029' SELECT RIGHT (@v,4) - SU...
Thursday, December 27, 2007

A year in review, The 21 + 1 best blog posts on SQLBlog

›
These are the best posts according to me, it might have been the content or it might have been the comments. Either way here are the 21 + 1 ...
2 comments:

Red Gate SQL Data Generator 1.0 Beta Available For Download

›
Red Gate have released Red Gate SQL Data Generator 1.0 Beta From the site: This tool is aimed at generating test data for SQL Server databas...
1 comment:
Sunday, December 16, 2007

EXISTS or COUNT(*)

›
Do you use this IF ( SELECT COUNT (*) FROM SomeTable WHERE SomeColumn = SomeValue ) > 0 Or do you use this IF EXISTS ( SELECT * FRO...
Thursday, December 13, 2007

The Strange Case OF Nulls And Case

›
Okay it is not Dr. Jekyll and Mr. Hyde but I had to come up with a title. This was a question someone asked yesterday in the sql programming...
2 comments:
Wednesday, December 12, 2007

SQL Teaser: LEN vs DATALENGTH

›
This should trip up some people..... Without running this code what do you think will LEN and DATALENGTH return? DECLARE @i int SELECT @i ...
1 comment:
Monday, December 10, 2007

The Sad State Of Programmers Part 2 : The In Person Interview

›
This is part two of a three part series. Part one was about the phone interview , this part is about the in person interview. Part three is ...
12 comments:
Sunday, December 02, 2007

The Sad State Of Programmers Part 1 : The Phone Interview.

›
This is going to be a three part series. Part 1 The phone interview. Part 2 The face to face interview. Part 3 Some tips and observations A ...
8 comments:
Tuesday, November 27, 2007

Integer Math In SQL Server

›
What do you think the following query will return in SQL Server? SELECT 3 / 2 If you said 1.5 then you are wrong! The correct answer is 1, ...
Friday, November 09, 2007

SQL Teaser: Printing Without Using PRINT

›
Print the @SQL variable without using PRINT DECLARE @SQL varchar (49) SELECT @SQL = 'Print This Now ' + CONVERT ( VARCHAR (30), ...
3 comments:
Tuesday, November 06, 2007

Return Null If A Value Is A Certain Value

›
You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLAR...