Second TPC-E Benchmark Result Published For SQL Server 2012
NEC has submitted the second TPC-E OLTP benchmark result for SQL Server 2012, running on an Express5800/A1080a-E system, which is...
2012-04-05
1,662 reads
Glenn Berry
Toshiba Satellite C655-S5503 Review
If you are “in computers” according to your family and friends, you are typically expected to provide lifetime, free tech...
2012-04-04
1,504 reads
Three Sessions at Spring 2012 Connections Conference
I will be a busy little beaver today, presenting three sessions at the Spring 2012 Connections Conference, the first one...
2012-03-29
1,755 reads
SQL Server 2008 Diagnostic Information Queries (April 2012)
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,082 reads
SQL Server Database Mirroring Tips and Tricks, Part 3
One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that...
2012-03-27
10,058 reads
Microsoft DreamSpark Program
Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools...
2012-03-21
1,371 reads
Microsoft Releases SQL Server 2008 SP3 Cumulative Update 4
Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes...
2012-03-21
4,260 reads
SQL Server Database Mirroring Tips and Tricks, Part 2
If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...
2012-03-21
1,501 reads
Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9
Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...
2012-03-20
1,803 reads
Intel Xeon E5-2600 Series Processors Released
Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...
2012-03-07
1,230 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers