Finding Untrusted Foreign Keys and Constraints
In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the...
2018-04-30 (first published: 2018-04-19)
3,146 reads
In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the...
2018-04-30 (first published: 2018-04-19)
3,146 reads
This blog demonstrates attaching a database on the SQL Server Instance which already has the same name database up and...
2018-04-23
1,814 reads
DMV (Database Management View) and DMO (Database Management Objects) were added in 2005. There have been huge improvements in each...
2018-04-16
25,940 reads
Recently, while reviewing one of the stored procedure performance, I suggested a couple of changes to a developer to improve...
2018-04-12
19,604 reads
Yesterday, I was attending a database design meeting. In the meeting, I was asked one of the questions – “How many...
2018-04-12 (first published: 2018-04-05)
12,085 reads
If you are working on SQL Server optimization delicately, you may get often queries that how to find if any...
2018-04-09
961 reads
It is relatively easy to spot CPU-bound system. But, the source of CPU pressure is not always easy to pinpoint....
2018-04-02
1,252 reads
It is fun working with SQL/Application developer where you exchange a lot of technical thoughts to find the root of...
2018-03-21
7,311 reads
TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.
2018-03-16 (first published: 2016-04-13)
8,776 reads
For SQL Server 2017 RTM, the fourth cumulative update was released on 20th February, and it is available for download...
2018-03-08 (first published: 2018-03-01)
1,599 reads
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
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