Help I’m an Oracle guy – whats all this SQL Server stuff ?
Having ventured into both the SQL Server world and the depths of Oracle RDBMS – Im often asked what the differences...
2012-05-18
742 reads
Having ventured into both the SQL Server world and the depths of Oracle RDBMS – Im often asked what the differences...
2012-05-18
742 reads
I’ve been deliberating over the last few years whether to make the leap into the contracting/consulting world.
Speaking to a good...
2012-05-18
783 reads
Hello Everyone – its been a while.
I’ve been out of the blogging scene over the last year or so due to...
2012-05-12
661 reads
The latest version of Ideras’ SQL Diagnositc Manager offers some pretty nifty predictive analysis capability. Offering at present, a 12 hour forecast.
This gives...
2011-05-06
1,022 reads
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-28
799 reads
DevConnections – London June 2011
DatabaseExpertise has negotiated 10 tickets for the main 2 day conference, at an amazing price of £100!!!
The first...
2011-04-28
696 reads
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-27
983 reads
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-26
961 reads
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
750 reads
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
784 reads
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
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...
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