SQLRally, Pre-Cons, and Taking Risks
Before I get into my thoughts, go vote! Here are the options this year for the SQLRally pre-cons:
BI Sessions: http://www.sqlpass.org/sqlrally/2011/PreConsforVotingBI.aspxDBA...
2010-10-29
1,459 reads
SQL Saturday 58 TODAY! #sqlsat58
Don’t forget the Minnesota SQL Saturday is TODAY. Obviously, this was written before today and I’m hoping to catch a...
2010-10-29
1,481 reads
Free SQL Server Training for the Week of November 1, 2010
Tuesday
PASS Performance Virtual Chapter - Five Fast Fixes for Fatal Flaws - Brent Ozar
Wednesday
SQL Lunch - Data Mining in SQL Server and Power...
2010-10-29
1,813 reads
Shopping
In about a week and a half, the SQLServerCentral opening night party takes place at the PASS Summit. And while...
2010-10-29
1,657 reads
SQLSaturday #59 – Speaker Interview Series #14 with Grant Fritchey
Sunday, October 31, 2010 is Halloween, and in the spirit of the holiday of ghosts, goblins, vampires, werewolves, witches and...
2010-10-29
2,417 reads
My Bucket List
I actually built on in 1999 and called it a Life List. Over the years I’ve tried to work on...
2010-10-29
1,526 reads
Creating Analysis Services Partitions Using BIDS
As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...
2010-10-28
3,361 reads
Adding Data Compression to an Existing Clustered Index in SQL Server 2008 R2
Working at an ISV like NewsGator Technologies, I get to work on products like Social Sites for SharePoint 2010, that...
2010-10-28
2,625 reads
PASS Summit Blogging
During the PASS Summit I have again been given the opportunity to keep my laptop plugged in… as long as...
2010-10-28
768 reads
Fundamentals of Storage Systems, Understanding Reliability and Performance of Solid State Storage
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
1,140 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers