Column order can matter
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,179 reads
Dave Ballantyne
Kent .Net/SqlServer User Group – Upcoming events
At the Kent user group we have two upcoming events. Both are to be held at F-Keys Training suite http://f-keys.co.uk/...
2011-06-05
645 reads
SqlHerts–26th May 2011
Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay. Its a true pleasure to...
2011-05-29
1,335 reads
#SqlBits and SSIS custom components
If you are in anyway interested in SQL Server and live in the UK, you cant of failed to of...
2011-04-11
713 reads
Do you know SqlServer ? Do you want an iPad ?
If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you.
Every day in March...
2011-03-12
540 reads
“Apparently, you signed a software services agreement without fully understanding it.”
I am not a lawyer. Let me say that again, I am not a lawyer.
Todays Dilbert has prompted me...
2011-02-24
807 reads
Denali Paging–Key seek lookups
In my previous post “Denali Paging – is it win.win ?” I demonstrated the use of using the Paging functionality within Denali. ...
2010-11-19
689 reads
Denali Paging–Is it win/win ?
I'm not one for automatically poo-pooing new ideas, new practices and new technology. Rather I like to take a measured...
2010-11-10
798 reads
The best things in life are free
Greg Gonzalez (blog | twitter) of SqlSentry, last night released a very cool new and free product. Plan explorer is a...
2010-10-21
2,940 reads
An impossible case
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
548 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
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,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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