Quick Roundup of Intel Ivy Bridge Reviews
The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically...
2012-04-23
1,040 reads
Glenn Berry
SQL Server 2012 Core Factor Table for AMD Processors
As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can...
2012-04-23
2,968 reads
Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers
If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is...
2012-04-18
2,181 reads
SQL Server 2008 R2 SP1 CU6 Released
This morning, Microsoft released SQL Server 2008 R2 SP1 CU6, which is Build 10.50.2811.0. This Cumulative Update lists 20 fixes...
2012-04-17
2,741 reads
Windows Server 2012
Microsoft’s Corporate Vice President Brad Anderson announced today at the Microsoft Management Summit 2012 in Las Vegas that the next...
2012-04-17
1,024 reads
SQL Server 2012 RTM Cumulative Update 1
Microsoft has released SQL Server 2012 RTM Cumulative Update 1, which is Build 11.0.2316.0. I count 55 fixes in the...
2012-04-12
2,257 reads
Building an Intel Ivy Bridge Desktop System, Part 1
I stopped by my local Micro Center on April 9, 2012, and I noticed that they had just received their...
2012-04-11
1,292 reads
Onward and Upward!
As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting...
2012-04-09
1,019 reads
Intel Sandy Bridge-EP Processor Recap
On March 6, 2012, Intel finally released the Xeon E5 processor family, (aka the Sandy Bridge-EP). Sandy Bridge is a...
2012-04-05
1,288 reads
More Fun with my NEST Thermostat
NEST has rolled out a nice software update for their NEST thermostat that gives you a 10 day history of...
2012-04-05
1,071 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...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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