SQL by Design: Supertypes and Subtypes Commented on: 3 years ago (July 7, 2011) I agree with Kurt. Five years later, this is still a problem. Who to accomodate a database structure that needs to change and the applications developement? This topic has to be treated as one, so if...
Welcome to (SQL Server) 2011 Commented on: 3 years ago (January 19, 2011) I doubt that there is a single application out there waiting for the new features of a new release to be developed and deployed. In real world, you have to deal with limitations and you use to find...
Measuring Expertise: The New SQL Server MCM Program Commented on: 3 years ago (January 5, 2011) Off course a certification is not a proof of knowledge, but as it is not possible to proof you experience, I mean, in a interview, how is it possible to show all your experience? How do you proof it...
Top 10 SQL Server Performance Tuning Tips Commented on: 3 years ago (January 5, 2011) It is wonderful to know where you actually learn about those tips. I would like to see more references in the articles.

Take Care!
NoSQL? No Way! Commented on: 3 years ago (October 1, 2010) What about the January's issue? MySpace addressed the same problems using SQL Server. I believe it is easier to use NoSQL than digg in SQL Server, that is the real reason. Almost like Linq. It is far...
How to choose a good index fill factor Commented on: 3 years ago (October 1, 2010) Looks like this is a endless task, since this depends on the data beeing stored and the data can change everyday, in some cases more often then that, is it possible to implement some job to...
Parallelism Enhancements in SQL Server 2008 Commented on: 4 years ago (July 2, 2010) This is exactly what we expect when we upgrade the DataBase Server, otherwise, what is the point?

Take Care!
SQL Server 7.0 Security Commented on: 4 years ago (July 1, 2010) Hi,

When we click on print "which should create a printer friendly format", we loose the links to the screen. Isn´t it possible to include the screens in that?
Is Your Physical Disk I/O Affecting SQL Server Performance? Commented on: 4 years ago (May 17, 2010) I believe that the most important is to have a baseline. To do that, every database server should have a DW of it's metrics since day 1. This is the only way to know if the current performance is...
What Happens if I Drop a Clustered Index? Commented on: 4 years ago (April 26, 2010) Hi,

I wish all my teachers were like you.

Thanks again.

Upcoming Conferences

Register now to get the best rate available!

From the Blogs
start here sign
Aug 26, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 1: Introduction

While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
Man deciding which door to choose
Aug 15, 2014

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Management Studip Options screenshot
Aug 5, 2014

SQL Server Management Studio’s Ugly ANSI_PADDING Bug

Learn more about the problem with SQL Server Management Studio's generation of scripts with ANSI_PADDING OFF along with a helpful solution....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×