How easy it is to check which statements consuming most of the CPU & RAM–TIP #68
Problem:- One of the most important question comes in our mind what is the cause of slow SQL SERVER.
We...
2014-11-01
254 reads
Problem:- One of the most important question comes in our mind what is the cause of slow SQL SERVER.
We...
2014-11-01
254 reads
As we discussed in earlier tips how to take full backup and differential backup now in this tip we will...
2014-10-30
892 reads
Friends,
We were discussing backup from last few post. Now lets take a look one more feature of backup which is...
2014-10-28
518 reads
In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can...
2014-10-25
283 reads
By alevyinroc
It seems like no matter how long you work with a system beyond a...
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Comments posted to this topic are about the item Mixed Backups
Hello, I ran below statements in MS SQL, and got error, but fine in...
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 GOSee possible answers