From the category archives:

SQL Server

50% Off Microsoft Certification Exams, and a Free Retake

April 27, 2010

If you are interesting in getting Microsoft Certified, now is a good time! I have two types of vouchers available to everyone who leaves a comment. The first type, good for the 13 exams listed below, will give you 50% discount on the cost of the exam, and a free retake if you fail the [...]

Read the full article →

Issue Performing a SQL Server 2008 Differential Backup After a Canceled Full Backup

January 23, 2010

This issue was painful. It started off with a canceled release because the differential backup didn’t finish as expected. The idea was to perform a differential backup just before the release so I’d have a safety net in case something tragic happened. I had run a test diff a few hours earlier and it finished [...]

Read the full article →

UPDATE Statements and Indexes

May 29, 2009

I ran into a database earlier this week with a lot of stored procedures that look like this:

CREATE PROCEDURE updateUser
@id INT, @FirstName VARCHAR(50), @LastName VARCHAR(50), @EmailAddress VARCHAR(50)
AS
SET NOCOUNT ON
 
UPDATE Users
SET FirstName = @FirstName,
LastName = @LastName,
EmailAddress = @EmailAddress
WHERE id = @id
GO

Every table had  similar CRUD [...]

Read the full article →

Oregon SQL Developers – April Meeting

April 7, 2009

Please join me at the Oregon SQL Developers Meeting, tomorrow, April 8th. Free pizza, lots of giveaways, and 2 great sessions planned. Many people will walk away with either a TechNet Plus Direct annual subscription (Estimated Retail Value $349), or a voucher for a Microsoft Certification exam of your choice (Estimated Retail Value $125).
Logistics:
Wednesday, April [...]

Read the full article →

Who Should Write Database Code?

March 20, 2009

This week, I ran into a query that did 770 GB worth of logical reads…on a 3 GB database!!!
Kimberly Tripp asked “Who’s job is it anyway?” Should database design and database coding be done by the Application Developer, the DBA, or should there be a separate “Database Developer” role? There are many variables that make [...]

Read the full article →

Adam Machanic’s T-SQL Challenge

February 27, 2009

For you T-SQL experts out there, Adam Machanic just posted a challenge with a great prize. The best submission wins a full MSDN subscription valued at around $10,000.
Check it out!

Read the full article →

Custom FeedFlare for Syndication

February 25, 2009

In this post, I’m going to share how I created the custom links back to my blog as seen in my syndicated posts on SQLServerPedia.com.
I’m syndicating my all of my SQL Server related posts over at SQLServerPedia.com. Since I sometimes blog about topics other than SQL Server, I didn’t want to syndicate my entire feed. [...]

Read the full article →

SQL Server Uniqueifier Values and the Number of the Beast

February 13, 2009

Reading Gail Shaw’s post All indexes are unique, reminded me of an interesting piece of trivia I discovered back in SQL Server 7. The error message for running out of uniqueifier values is 666.

SELECT TEXT FROM sys.messages WHERE message_id = 666

Returns:
The maximum system-generated unique value for a duplicate group was exceeded for index with partition [...]

Read the full article →

Oregon SQL Developers Meeting Tomorrow

February 10, 2009

If you are in the Portland area, you won’t want to miss the OSQL-d meeting tomorrow. We have two great sessions planned.
Wednesday, Feb 11th, 2009 at 6:30 pm (Pizza and networking start at 6:00 pm) Microsoft Portland Office – 10260 SW Greenburg Rd, Suite 600
Using SQL Server Management Studio, Intellisense, and SQL 2008 [...]

Read the full article →

FizzBuzz in T-SQL

February 3, 2009

Pinal Dave posted yesterday about how to solve the Fizz Buzz problem using T-SQL.
Definition of FizzBuzz Puzzle : Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both [...]

Read the full article →

← Previous Entries