Find Query with Implicit Conversion in the Plan Cache
In my previous blog, I discussed about “Which are the queries using a particular index or table?“. Today’s post, I am...
2018-05-13
2,207 reads
SQL Geek
Which are the queries using a particular index or table?
The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...
2018-05-07
913 reads
Determine Referenced Objects in the Stored Procedures
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
454 reads
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,657 reads
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,087 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
22,906 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
15,721 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
919 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)
11,080 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,095 reads
Blogs
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Forums
same Procedure with same source tables in 2 environments but delay in exec in 1
Good Morning, I have the below procedure, in both UAT & PROD same data...
DC migration SQL DB suggestion
Hi All, Our server team is planning to move secondary data centre from one...
SSDT import into a table from .csv corruption
Hello everyone, I am importing from a csv file into a table. Everything works...
Ask SSC