Indexes and their Effect on Query Performance
Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the...
2010-07-29
983 reads
Blog Posts
Interviewed by Andy Leonard
Last year Brent Ozar interviewed all the candidates for the PASS Board of Directors. I think it went over pretty...
2010-07-29
1,913 reads
Introduction to Parallel Data Warehousing
What are we talking about?
Recently Microsoft released a new version of SQL Server 2008 R2 called Parallel Data Warehouse Edition....
2010-07-29
794 reads
Limiting Table Access for Reporting Part 1
End users may have a need to do some form of reporting of data from source systems. Opening up the...
2010-07-29
459 reads
Limiting Table Access for Reporting Part 2
Blog Title: Limiting Table Access for Reporting Part 2
In the first blog post of this series, I showed you how...
2010-07-29
575 reads
Log Shipping By Abi Chapagai (Revised)
Log Shipping By Abi Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...
2010-07-29
2,386 reads
Pesky Protected Mode
How many of you keep falling for this one…You open up Report Manager for a user that you know you...
2010-07-29
1,481 reads
Poor Little Misunderstood Views
Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that...
2010-07-29
60,052 reads
Schedule Published for SQLSaturday #51 in Nashville
Just released, http://www.sqlsaturday.com/51/schedule.aspx?sat=51. Five tracks, lots of good speakers, but I see a few new names too. Looks like a...
2010-07-29
1,373 reads
SQL Bits 7 – Registration is Open !
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,489 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