Category Archives for "SQL Administration"

Jun 08

Get a List of Tables That Are Compressed

By SQLRx Admin | Beginner , Helpful Scripts , SQL Administration , SQL Server , Tip of the Month

Find out if any of your tables are compressed in your database using the query below. Compressed tables can save space and make queries run faster. — Compressed Tables select distinct t.name AS CompressedTables from sys.partitions p inner join sys.tables t on p.object_id = t.object_id where p.data_compression > 0 If you don’t have any tables […]

Continue reading
May 25

AlwaysOn 2016 – Encrypted Databases in an AG

By Ginger Daniel | Encryption , SQL 2016 , SQL Administration , SQL Server

In the AlwaysOn 2016 release, there are several enhancements that have improved manageability, scalability, and availability. One of the enhancements is the ability to add encrypted databases to an AlwaysOn group. Encrypted databases were allowed in earlier versions of AlwaysOn, however they could not be accessed if there was a failover to a secondary replica […]

Continue reading
May 04

List Partitioned Tables And Other Info About Them

By Lori Brown | Beginner , Helpful Scripts , Partitions , SQL Administration , SQL Server , Tip of the Month

Here is a good way to find out if any of your tables are partitioned in your database using the query below. It is important to know so that you can find out how the tables are partitioned. — Partitioned Tables SELECT DISTINCT t.name AS ParitionedTables FROM sys.partitions p INNER JOIN sys.tables t ON p.object_id […]

Continue reading
1 3 4 5 6 7 15
>