DevWeek 2010 is Coming Up
The time has come again for the UK’s biggest conference for .NET developers and SQL Server professionals. Read the press release about this years DevWeek.
2010-01-27
312 reads
Articles
Get Your ANSI_NULLs Settings Consistent
William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.
2010-01-27
8,154 reads
SQL Server Consolidation : how to decide on the right approach
The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.
2010-01-27
1,120 reads
Celko's SQL Stumper: The Class Scheduling Problem
What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!
2010-01-27
1,535 reads
SQL Saturday #34 - Boston
Coming on Jan 30, to the Boston area, be sure to attend this SQL Saturday if you are nearby.
2010-01-27 (first published: 2010-01-20)
1,505 reads
2010-01-26
442 reads
Using "Multiple Assignment Variables" for a Generic Compare Data Script
Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.
2010-01-26
5,998 reads
Best Practices for Exception Handling and Defensive Programming in Microsoft SQL Server
This is a deep dive developer session that explores error handling in SQL Server. The session focuses on core error handling areas such as understandign the anatomy of errors, detecting errors in TSQL and best practices for error handling and defensive programming in Microsoft SQL Server. tuesday, 1/26, 8:00am EST
2010-01-26 (first published: 2010-01-21)
10,699 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-26
1,290 reads
Performance Analysis Using SQL Server 2008 Activity Monitor Tool
While looking through the new features and improvements in SQL Server 2008 Management Studio (SSMS) we found a potentially interesting one called Activity Monitor. Database developers and Database Administrators can use Activity Monitor to get a quick overview of an SQL Server 2008 system performance. Can you give us a detailed explanation of how we go about using Activity Monitor?
2010-01-26
4,406 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
Make your moments memorable with Fildena 200mg
Make your moments memorable with Fildena 200mg, a high-strength option designed to support men...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers