Posts tagged as:

SQL Server

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 →

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 →

The Top 10 SQL Server 2008 Features for the DBA

February 2, 2009

The SQL Server Customer Advisory Team (SQLCAT) just posted a great article listing some of the best new SQL Server 2008 features for the DBA. Here they are:

Activity Monitor
SQL Server Audit
Backup Compression
Central Management Servers
Data Collector and Management Data Warehouse
Data Compression
Policy-Based Management
Predictable Performance and Concurrency
Resource Governor
Transparent Data [...]

Read the full article →

SSIS Resources

January 29, 2009

***UPDATED 2/10/2009 – Added links***
***UPDATED 2/23/2009 – Added MSDN SSIS Forum and Jeff Wharton’s link list.***
Last Thursday I gave a talk at the Oregon SQL Server Developers Professional Association and promised to post some Integration Services resources.
SSIS Best Practices
SQLCAT – Top 10 SQL Server Integration Services Best Practices
Matthew Roche – SSIS Best Practices, Part 2
Jamie  [...]

Read the full article →

SQL Server Interview Blunders

January 16, 2009

I just read Jason Massie’s new Capt. Varchar(MAX) comic. If you have spent much time interviewing SQL Server candidates I’m sure this will bring back some memories.
I was helping a company phone screens candidates for a Senior DBA position a while back. We went through such a bad string of candidates that the three of [...]

Read the full article →

← Previous Entries