2004-06-16
2,280 reads
Administration
2004-06-15
2,365 reads
Case Sensitivity in Selects - Part 3
See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.
2004-06-15
7,395 reads
2004-06-11
2,149 reads
2004-06-09
2,150 reads
Which Databases are Being Backed Up - Another Look
Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up.
2004-06-09
9,512 reads
2004-06-08
1,690 reads
2004-06-07
2,188 reads
2004-06-04
1,881 reads
Checking Your Database Fragmentation Level
Fragmentation in SQL Server is a huge debate. Does it matter? How much is too much? What should you do? In any case, new author Nicholas Cain has put together a system that allows him to keep track of the levels of fragmentation as well as defragment those tables when he feels they are getting too spread apart.
2007-10-02 (first published: 2004-06-04)
34,781 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCU WISMA ASIA Telp:0818751777
WhatsApp:0818-751-777 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers