Generate RPC:Completed Event
I was doing a research on SQL trace regarding RPC:Completed event. So I need to generate a RPC:Completed event first...
2007-11-14
1,719 reads
I was doing a research on SQL trace regarding RPC:Completed event. So I need to generate a RPC:Completed event first...
2007-11-14
1,719 reads
As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to...
2007-11-11
373 reads
I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but...
2005-09-11
1,331 reads
I got a very interesting issue, I may guess the reason but not sure why it is this way.
Symptom: Logon to...
2005-09-09
1,371 reads
This is my first post, congrats to myself. 🙂
DTS Connection object does not list "UseTrustedConnection" property
I am working on a...
2005-09-08
1,342 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...
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