Issues with SQL Server 2005 SP1
There have been reports of some issues with SQL Server 2005 SP1, especially
with SQL Server Integration Services not starting as...
2006-04-27
1,634 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
When life intrudes
I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...
2006-04-26
1,471 reads
Issues tracking members of the sysadmin fixed server role
I received an email from another DBA asking how to track a user who is
probably mapping into SQL Server via...
2006-04-25
1,590 reads
Determining if it's a SQL login, Windows Login, or Windows group
A recent question on the forums asked how to determine if a database
user was a Windows user or group and...
2006-04-06
3,924 reads
Kerberos Delegation with SQL Server Reporting Services and SQL Server
I've been dealing with Kerberos delegation setup with respect to
Microsoft's CRM 3.0 product and while the process isn't difficult, if
you...
2006-04-05
2,164 reads
March/April 2006 Edition of SQL Server Standard Available
The March/April 2006 edition of SQL Server Standard magazine is now
available. This issue focuses on Transact-SQL for SQL Server 2005.
Though...
2006-04-03
1,512 reads
12-inch grass stem?
Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...
2006-03-29
1,364 reads
Internet Explorer Vulnerability
If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...
2006-03-28
1,562 reads
Rights within the database
This is a follow-on to my post What are the actual rights?
First and foremost, I want to include membership in...
2006-03-14
1,421 reads
What are the actual rights?
One of the things I've started to work on are some scripts to quickly
be able to pull what a user's...
2006-03-14
1,450 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...
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
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