2015-09-14
2,374 reads
Site Owners
2015-09-07
2,299 reads
2015-08-31
857 reads
Learning Live Query Statistics
References and information on the Live Query Statistics feature in SQL Server 2016.
2015-08-24
1,817 reads
2015-08-17
4,183 reads
2015-08-10
2,149 reads
2015-08-03
3,355 reads
Learning Backup to Azure
References and links to get you started in backing up your database to the Azure blob storage.
2015-07-27
804 reads
2015-07-20
3,370 reads
2015-07-13
1,826 reads
Blogs
The Mysterious Empty Table
By alevyinroc
It seems like no matter how long you work with a system beyond a...
Choosing to not drive the Tesla
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
Advice I Like: Transactions and Relationships
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
Forums
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Mixed Backups
Comments posted to this topic are about the item Mixed Backups
Or condition in where clause works differently in MS SQL comparing with Sybase
Hello, I ran below statements in MS SQL, and got error, but fine in...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers