Contents tagged with SQL
Microsoft SQL Server has the handy dandy View Dependencies functionality. How can you view dependencies in MySQL? Well I needed to get the dependent tables for the stored procedures … more
This is something I use in SQL development but forget a lot. How to refresh the intellisense data in SQL Management Studio after making a schema change. It’s a nifty keyboard … more
Here are the SQL Server Isolation Level in brief.
Dirty reads. No locks are engaged so you can read data while it’s changing due to some other transaction.
Read … more
Here are a few questions regarding MS SQL Server indexes that I have been asked in interviews. This is important stuff, read on!!
What is a primary key?
A unique index that identifies … more