Who Changed Jobs in 2010?
Linked in sent me an email saying that an astounding 209 of my connections changed jobs in 2010, out of...
2011-02-03
539 reads
Is the new 4k sector hard drives a blessing or is it going to be the next best thing after Internet?
I read on lots of websites that the new hard drives will be moving to 4K sectors instead of the...
2011-02-03
1,745 reads
What SQL Server Service Pack Do I Have Installed?
If you’ve used SQL Server for a while, you’re probably familiar with the @@version function. @@ variables are system variables that...
2011-02-03
853 reads
Time’s Makin’ Changes
Some History
Almost exactly 6 years I ago my wife and I decided to apply to be missionaries with New Tribes...
2011-02-03
787 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-03
11,121 reads
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-02
1,934 reads
A Full Backup can Impact a Log Backup–MCM Prep
In the early days of SQL Server you could not run a log backup while a full backup was running....
2011-02-02
2,927 reads
PASS Summit Location
Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...
2011-02-02
1,916 reads
Meet Me In Florida!
While much of North America is bracing for the Snowpocalypse 2011, my thoughts are turning to sunny Florida.
I’m not just...
2011-02-02
748 reads
A Mish Mash of Stuff
I don’t generally post bits of this and that, but I’ve accrued a few things that I wanted to share,...
2011-02-02
602 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