When did SQL Server start and how long is the downtime window?
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...
2010-05-27
3,728 reads
DBA Philosophy
Issue with SQL Server 2K5 SP3 CU5
In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out...
2009-09-12
1,563 reads
Journey to trouble-shoot Error 5042 (cannot remove a file xxx because it is not empty)
I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each...
2009-08-10
8,911 reads
Thoughts on SSC Blog Site Improvement
I have been reading blogs from various sources, such as blogs on SSC, and on sqlblog.com etc. However on all...
2009-04-22
743 reads
Database Administration Literature Criticism
What is literature? I find this definition is pretty intuitive at http://classiclit.about.com/od/literaryterms/g/aa_whatisliter.htm and also this one is more comprehensive at...
2009-04-19
1,010 reads
DBA Education
I always consider taking seminars and technical conferences as a key component in my DBA education framework
Last week (Jan 21...
2009-01-27
1,739 reads
List Objects in a Filegroup in SQL Server 2005
I have tried hard to google a SQL query to find what objects exist in a specific filegroup, but in...
2009-01-16
12,542 reads
DBA Mission and Vision Statement
There is a saying that "The important is often not
urgent and the urgent not important". I could not agree more...
2009-01-03
18,327 reads
Database Administrtion Skillset Investment Rules
With each new release of SQL Server version, there is something new to learn. In SQL Server 6.5 days, it...
2008-12-05
785 reads
Database Adminstration Scalability
database administration scalabilityI am working on a project that is very successful in terms of its market
share, i.e. product users...
2008-11-27
1,869 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers