Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files
SELECT instance_name AS DatabaseName,
[Data...
2016-03-10
1,113 reads
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2016-03-10
373 reads
In case you missed it, back in November I blogged about the importance of nominating individuals within the SQL Server...
2016-03-10
393 reads
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,324 reads
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism for AlwaysOn Availability Groups. Check out the many new...
2016-03-10
20 reads
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism...
2016-03-16 (first published: 2016-03-10)
1,819 reads
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
21 reads
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
7 reads
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...
2016-03-10
108 reads
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
1,022 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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