One of the most popular question I receive is usually about How to get column names from a specific table in SQL Server?
SQL Server – How to Get Column Names From a Specific Table?
Question: How to get column names from a specific table in SQL Server?
SQL SERVER – Simple Query to List Size of the Table with Row Counts
Sometimes we need simple query which can do the task, then complicated solution. Here is a simple query which list size of the table in MB with Row Counts. I often run at my customer understand how many different tables they have and what is the row counts as well as the size of the each table.
SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?
Question: How to Find Row Count of Every Table in Database Efficiently?
SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
While playing with my SQL Server startup parameter, I made some mistakes and came to a situation where SQL Server was not getting started. In this blog post, let us learn about error 17113.
Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101
Question: I just installed SQL Server 2016 developer version and new samples database WideWorldImports, upon expanding the tables, I noticed a special icon on the System-Versioned table which looks like a watch. What does this special icon which looks like a watch represents in SQL Server Management Studio 2016?
Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects
Sometimes questions in the interview are extremely open ended and such questions can be very useful for candidate to play around with. For example, in one of the recent interview one of the interviewer asked the candidate that what is his favorite T-SQL script as a database administrator. The answer…
Read More