How to get the SQL server critical errors via mail using native T-SQL Script
Advertisements
T-SQL Tuesday #015: Automation:
I am very much interested to participate in the T-SQL Tuesday event party. I have seen the...
2011-02-06
1,002 reads
How to setup the Database mail in SQL server 2005
AdvertisementsHow to setup the DB mail using Gmail account
In this article I am going to show the database mail setup...
2011-02-05
753 reads
Five DMV Queries That Will Make You a Superhero in 2011!
Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...
2011-02-04
2,816 reads
January OPASS Meeting Recap
On January 20th OPASS was pleased to have had Kevin Kline (Blog|Twitter) from our sponsor, Quest, present 10 Things Every Developer should know. This was the first regular OPASS...
2011-02-04
5 reads
Setting the Standard with Personal Appearance
Cross-posted from the Goal Keeping DBA blog:
Personal appearance matters. We all know this. Yet a lot of times we don’t...
2011-02-04
1,144 reads
January OPASS Meeting Recap
On January 20th OPASS was pleased to have had Kevin Kline (Blog|Twitter) from our sponsor, Quest, present 10 Things Every...
2011-02-04
864 reads
The Many Faces of SQL Server
Well, one of my goals this year was to focus on branding myself a little more. So I decided to...
2011-02-03
453 reads
SQL University: State of the Union
The new SQL University Logo
Well the new year is here and SQL University is back and better than ever! I...
2011-02-03
650 reads
Poll Reveals DBAs Actively Tune TEMPDB
When I manage a SQL Server instance, I always make an extra effort to optimize the performance of TEMPDB, so...
2011-02-03
717 reads
SQL Saturday Advice–Upload Decks Early
One of the neat features for the SQL Saturday site is that it allows the speakers to upload a deck...
2011-02-03
1,418 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
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