Splitting ID’s with commas, updating them, and then Slamming them back together
Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...
2011-08-16
1,236 reads
Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...
2011-08-16
1,236 reads
find.....underlings.....
searching......
underlings found......
I recently was given the task to create a stored procedure to find people who are under other people...
2011-06-22
824 reads
I recently had to battle through THE DOUBLE HOP OF DOOOOOMMM!! It was a very rewarding experience and I think...
2011-06-20
4,400 reads
Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so...
2011-06-12
1,927 reads
Agile! Scrum! Development methodologies! Sprint!
If you have a manager who reads any web page about being a manager, then you...
2011-05-29
8,375 reads
One thing that is enjoyable about my position is working with people who have no idea what SQL is besides...
2011-05-25
1,159 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