Space used by Individual tables in SQL Server
Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here.
2022-02-14 (first published: 2022-02-01)
649 reads
Blog Posts
Daily Coping 11 Feb 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-11
35 reads
Data Pages – the Foundation of SQL Server
Last week we laid out the foundation for how SQL Server executes queries. I have also already talked here a little bit about pages that are buffers of 8kb....
2022-02-11 (first published: 2022-01-31)
800 reads
Speaking at SQL Bits 2022
A look at the sessions I'll be presenting at SQL Bits 2022 in London this year. Excited to return to a great conference and hope to see you...
2022-02-11
39 reads
SQL Homework – February 2022 – “Soft” skills.
Well, it’s a new year and a new start, even if I am a bit behind the start of the ... Continue reading
2022-02-11 (first published: 2022-02-02)
364 reads
Azure DB for MySQL – server parameters
If you have used MySQL before you will know about the system server variables, you know such commands as SHOW VARIABLES; You can access most of them via the...
2022-02-10
55 reads
Daily Coping 10 Feb 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-10
28 reads
You can’t use GO in dynamic SQL.
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-10
15 reads
Batch, Streaming, and Relational Data
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-09 (first published: 2022-02-03)
381 reads
BlitzBlockingChain, Getting Blocking Chains from sp_BlitzWho
I’m going to assume that most people will have at least heard of Brent Ozar’s brilliant First Responder Kit. If you haven’t then you’ve been missing out on some...
2022-02-09
109 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers