A second week at SQLskills – performance tuning
G’day,
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at...
2011-08-14
1,156 reads
G’day,
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at...
2011-08-14
1,156 reads
G’day,
I recently ran into a nice feature that I had never encountered before.
Sometimes, when developing or administrating an unfamiliar table...
2011-07-04
4,992 reads
G’day,
Here’s my input into this months Meme Monday – there are no dumb questions.
It seems (at least to me), that – occasionally...
2011-06-06
1,684 reads
G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...
2011-05-31
2,917 reads
G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...
2011-05-12
1,485 reads
G’day,
The recommended way to access SQL SERVER metadata is through the catalog views.
The challenge is to be able to distinguish...
2011-05-08
2,990 reads
G’day,
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them...
2011-05-05
716 reads
G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...
2011-05-04
17,905 reads
G’day,
Apparently “Meme Monday” was started by Thomas Larock (Blog | Twitter) , as a way for getting people writing. I haven’t been...
2011-05-02
728 reads
Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...
2011-05-02
20,167 reads
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...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
In today’s complex regulatory landscape, businesses must adhere to various laws, policies, and industry...
At NXG Electrical, our seasoned professionals provide effortless heating, ventilation, and air conditioning services...
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
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