Blog Archives

How to list all objects and indexes [SQL Server]

Today I had to list which objects belongs to which filegroup. It’s a simple and useful script that you can take from system catalogues: sys.filegroups, sys.indexes, sys.database_files and sys.data_spaces. Take a look this sample In the next post I’m going to share

Tagged with: , ,
Posted in Scripts, SQL Server Tips

Repository of White Papers – SQL Server

Like a good reader, I highly recommend that you read these white papers. These links contain much more knowledge that I can provide here. https://www.sqlskills.com/sql-server-resources/sql-server-whitepapers/ http://social.technet.microsoft.com/wiki/contents/articles/13146.white-paper-gallery-for-sql-server.aspx That’s it! Have fun.

Tagged with: , ,
Posted in SQL Server Tips

Lookup All File Sizes, Status, and FileName for all Databases

This script can help you find some details in all databases.

Tagged with: , ,
Posted in Scripts, SQL Server Tips

How do I find a value anywhere in a SQL Server Database

The query below will search all fields in all tables for a specific value. Enjoy it!

Tagged with: , ,
Posted in Scripts, SQL Server Tips

High Availability and Disaster Recover – Syncronize logins [SQL Server]

Often I connect in new environments and I see solutions of High Availability and Disaster Recovery. But just the simple solution is sufficient for your applications? I’m saying that because in many cases a just simple detail is forgotten. Many

Tagged with:
Posted in High Availability, Scripts, SQL Server Tips

Estimated time of Backup / Restore [SQL Server]

Sometimes you will want to know how is the backup progress before a critical change of your environment or during the restore before setting a new high availability strategy. This script can help you to figure out.

Tagged with: , , ,
Posted in Backup, Scripts, SQL Server Tips

How to identify the last objects created or modified in all databases

The script provided below, shows every modified and created events in the last 7 days.

Tagged with: , ,
Posted in Security, SQL Server Tips