Multiple Windows Groups with different default databases
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,859 reads
Microsoft Azure SQL Databases – Power and Performance
By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to...
2015-05-28
1,038 reads
SQL 2016 Preview has been released!
For those who haven’t noticed already:
SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means...
2015-06-01 (first published: 2015-05-28)
3,285 reads
Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5
Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...
2015-05-28
975 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015
For those of you who have been following along with this series of posts,...
2015-05-28
117 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...
2015-06-05 (first published: 2015-05-28)
4,138 reads
Integrating Other Data Mining Tools with SQL Server, Part 1.1: The Weaknesses of WEKA
By Steve Bolton
…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data...
2015-05-28
2,368 reads
Visualizing the Tally Table
I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem...
2015-05-27
908 reads
Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)
Continuation from the previous 53 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a not very deep technical...
2015-05-27
958 reads
How an MPP appliance solution can improve your future
Massive parallel processing (MPP) is the future for data warehousing.
So what is MPP? SQL Server is a Symmetric Multiprocessing (SMP) solution, which...
2015-05-27
808 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers