Backup log Truncate_Only in SQL Server 2008
BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...
2010-11-16
1,679 reads
My SQL PASS Summit Adventures part 1
I started my PASS Summit a little early this year. I arrived in Seattle on Friday night, November 5th, around...
2010-11-16
591 reads
How Often Do You Backup Your Transaction Logs?
Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least...
2010-11-16
1,870 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,851 reads
Help Set Recommendations for SSAS Counters in PAL
First, if you haven’t tried PAL yet, I highly recommend downloading it from CodePlex and giving it a try. You...
2010-11-15
893 reads
PASS Report 1: Why you should have been there!
PASS Summit 2010 is now history. This is my eighth summit but the first one since leaving the DBA world...
2010-11-15
1,562 reads
Inspiration, and the Joy of the Hive Mind
PASS Summit 2010 is over, and we are suffering from the lack of chatter and SQL celebrity sightings. Bloggers are...
2010-11-15
587 reads
PASS Summit Magic: The Turn
Watch closely...
I mentioned in my last post that the Turn is the point in the act where the magician executes...
2010-11-15
1,483 reads
SSIS Denali Resolve References
One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z)...
2010-11-15
1,412 reads
Presenting At East Iowa SQL Server Users Group On Nov. 16
On Tuesday, November 16, I'll be presenting Paging DR Availability, You're Wanted in the Recovery Room via LiveMeeting to the...
2010-11-15
515 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