CREATE DATABASE [Story]
ON PRIMARY
( NAME = N'Story', FILENAME = N'C:DataStory.mdf',SIZE = 101MB),
FILEGROUP [Line1]
( NAME = N'File1', FILENAME = N'C:Data_.It',SIZE = 102MB),
( NAME =...
2021-10-18 (first published: 2021-09-30)
502 reads
It’s TSQL Tuesday! John Armando McCormack (blog|twitter) is our host this month and he’d like us to share some of ... Continue reading
2021-10-12
34 reads
One of the easiest ways to collect information about table activity is to add a series of audit columns to ... Continue reading
2021-10-11 (first published: 2021-09-28)
502 reads
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of ... Continue reading
2021-10-07
88 reads
Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? ... Continue reading
2021-10-05
54 reads
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql ... Continue reading
2021-10-04 (first published: 2021-09-21)
620 reads
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
548 reads
Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure ... Continue reading
2021-09-22 (first published: 2021-09-14)
438 reads
In my house, this is rule one. Sometimes it’s my wife or I reminding our kids, sometimes it’s them reminding ... Continue reading
2021-09-17 (first published: 2021-08-31)
332 reads
Last month I had you create a security standards document. This month we are going to document our recovery plan. ... Continue reading
2021-09-15 (first published: 2021-09-02)
252 reads
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
Ontario, CA is home to a variety of restaurants, but when people talk about...
Ontario, CA is home to a variety of restaurants, but when people talk about...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers