My client during the Comprehensive Database Performance Health Check. I created a video on the topic of Transfer Schema of Table.
SQL SERVER – Move a Table From One Schema to Another Schema
My client of Comprehensive Database Performance Health Check wanted to learn the trick to Move a Table From One Schema to Another Schema.
SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information
If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.
MySQL – Download Sample Database – Sakila, World, Employee
However, whenever we are exploring the new feature, it is a good idea that we work with the sample database and build our scripts
SQL Puzzle – Schema and Table Creation – Answer Without Running Code
It has been a while we have a puzzle on this blog. Let us have a very simple and interesting puzzle today about Schema and Table Creation.
Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209
Question: Does NOLOCK Really Applies No Lock?
Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct.
SQL SERVER – Finding User Who Dropped Database Table
Though I mainly focus on SQL Server Performance Tuning as my primary consulting engagement, there are moments when I am asked questions from my regular clients which are not related to SQL Server Performance and they still expect me to answer. I think it is totally fair, no one wants to go to find a new consultant for some simple questions. Recently my customer wanted to know who dropped the database table from their primary database.