Showing posts with label SQL Server 2005. Show all posts
Showing posts with label SQL Server 2005. Show all posts
Monday, January 16, 2012

SQL Advent Recap and What is coming in SQL Server 2012 recap

›
In case you missed these, here is a recap of the SQL Advent and the SQL Server 2012 posts SQL Advent Recap Day 1:  Date and time I...
Sunday, December 11, 2011

SQL Advent 2011 series of posts

›
I have started a series of post about upgrading your skills to 2005 and 2008 versions of your code from 2000. Below is a list of posts that ...
Friday, October 31, 2008

SQL Server 2005 Service Pack 3 Beta and SQL Server 2008 Feature Pack October 2008 available for download

›
SQL Server 2005 Service Pack 3 Beta and SQL Server 2008 Feature Pack October 2008 are available for download Download SQL Server 2005 Servic...
1 comment:
Monday, July 07, 2008

sp_indexinfo an enhanced index information procedure

›
Tibor Karaszi has created a very useful index information stored procedure for SQL Server 2005 and up. This stored procedure will tell you t...
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 ...
Wednesday, May 07, 2008

Should SQLServer Have The CREATE [OR REPLACE] PROCEDURE Syntax?

›
I was asked by a developer at work the other day why SQL Server does not have the create or replace syntax. I started thinking and there wer...
3 comments:
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

SQL Champ - A Quiz to Prove Your SQL Knowledge

›
In case you are bored CodeProject has a small SQL test (7 questions) Take the test here: SQL Champ - A Quiz to Prove Your SQL Knowledge And ...
1 comment:
Tuesday, March 18, 2008

What tastes better, Microsoft SQL Server 2005 or Oracle 11g?

›
Find out here: http://www.databasetastechallenge.com/landing/index.html You can win some cool prizes. the video is very funny
Thursday, February 07, 2008

Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization

›
SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let’s put this in perspec...
Friday, February 01, 2008

Vote for SQL Server 2005 Service Pack 3

›
Hugo Kornelis makes a good point here: Want a Service Pack? Ask for it! Service pack 2 for SQL Server 2005 is already 11 months old. And th...
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...
Monday, January 21, 2008

SQL Server 2005 Best Practices Analyzer (January 2008) Available For Download

›
This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer. Get it here: http://www.microsoft.com/downloads/detail...
Monday, January 07, 2008

Has Anyone Succeeded In Creating A Collision Between NEWID and NEWSEQUENTIALID

›
SQL Server 2005 introduced a new type of function to create a uniqueidentifier; the NEWSEQUENTIALID(). This new function has been created fo...
1 comment:
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: