Let’s talk about why we have to wait and how to understand the wait types. Paul Randal in his post
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
SQL Server has many undocumented functions and commands. I will write series of posts with functions to have a library online.
OH: A: “What’s the scariest datatype?” B: “What?” A: “a BOOlean” … C: “It’s funny, because it’s TRUE” Lol