How to Perform Database Hack-Attach
This blog demonstrates attaching a database on the SQL Server Instance which already has the same name database up and...
2018-04-23
1,828 reads
SQL Geek
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,168 reads
Find Missing Indexes For All SQL Server Databases
DMV (Database Management View) and DMO (Database Management Objects) were added in 2005. There have been huge improvements in each...
2018-04-16
26,224 reads
SQL Server Logical Query Processing
Recently, while reviewing one of the stored procedure performance, I suggested a couple of changes to a developer to improve...
2018-04-12
19,874 reads
How to Check SQL Server View Utilization
If you are working on SQL Server optimization delicately, you may get often queries that how to find if any...
2018-04-09
973 reads
What is a Foreign Key & How many foreign keys can you have on a single table?
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,117 reads
How SQL Compilation Can Prove the Server CPU
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,261 reads
SQL Performance – Using Query Hint OPTION (FAST N)
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,326 reads
New Built-in Function CONCAT_WS() – SQL Server 2017
In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...
2018-03-02
1,385 reads
Set New Errorlog File location – SQL Server on Linux
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,606 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers