SQL Server: Identifying Edition Specifc features Used in a Database
I had a situation which forced me to do a feasibility study to move SQL server 2008 enterprise edition environment to standard edition. It is...
2013-06-26
1,688 reads
PracticalSQLDba
SQL Server: Part1 : All About SQL Server Statistics :Density Vector
In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer use...
2013-06-25
10,995 reads
SQL Server : Index at a glance
In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...
2013-04-16
1,229 reads
SQL Server : Part 10: Importance of Key Column Position While Creating Index
Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...
2013-04-22 (first published: 2013-04-16)
6,619 reads
SQL Server : Part 9 : Filtered Index : A new way for Performance Improvemnt
Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now...
2013-04-08
6,166 reads
SQL Server : Part 8 : Explaining The Covering Index or Included Columns
In our earlier discussion about non clustered index ,we have seen that, the leaf level of a non clustered index...
2013-03-25
2,606 reads
SQL Server : Part 7 : Non clustered index on non unique column
In our earlier post, we have discussed about the non clustered index, but there we were always discussing about unique...
2013-03-24
3,558 reads
SQL Server : Part 6 : Design consideration of Clustered Index
In our earlier post, we have discussed about the structure and storage of clustered index. In this post we will discuss...
2013-03-21
2,053 reads
SQL Server : Part 5 : Explaining Non clustered Index on Heap
In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss...
2013-03-17
7,811 reads
SQL Server : Part 4 :Explaining the Non Clustered Index Structure
A table can have only one clustered index as the data rows are stored in the order of the clustered...
2013-03-14
30,608 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