Why You Should Vote for My SQLRally Pre-Con
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
2010-10-29
2,492 reads
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
Blogs
T-SQL Tuesday #201 - Temp Tables, Friend or Foe?
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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