database – Page 3 – SQL Padawan

Query Store Usage Scenarios

What is Query Store? Query Store is a tool to troubleshoot query performance by capturing a range of information about

One more undocumented function/commands. The fn_dump_dblog function is used to read transaction logs from a log backup file. This is

Every database has a transaction log that records all transactions and the database modifications made by each transaction The transaction

What’s a heap table? I would say it’s a table without clustered index. What’s the characteristic of a heap table?

Great news, a visual way to manage SQL Server from Linux. SQL Operations Studio came to fill a gap we

A simple script to know how much space the tables are taking from the disk. SELECT t.name AS TableName ,

Update data in SQL Server is a simple task. Using the command update table set column = value where column

I like tools and I’ve used a couple of them. I had the opportunity to try SQL Examiner to compare

The first checklist before start using any application using SQL Server should be the default configurations. What configurations I used