As a DBA I need to see the list of tables available in a particular database frequently. Traditionally, this can be done by traversing through the object explorer. This may be the popular method among GUI lovers. But for me it is a pain. I hope it is the same for most of the DBAs.
I use a different method to see the list of tables in a database using a shortcut key. I've assigned the below SQL statement to a shortcut key.
select SCHEMA_NAME(schema_id) [Schema],name from sys.tables order by SCHEMA_NAME(schema_id),name
To access, the shortcut key use the following steps;
3. Select Keyboard from the left pane.
4. Assign the above SQL statement to a shortcut of your choice
I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...
I wanted build an expression to make a folder name dynamically. (Basically expressions are anyway dynamic in nature) So I simply used the ...
When querying sys.dm_exec_requests dmv, you can see the waiting requests and the resource those requests are waiting for. Sample of such val...
The SQLOS Prior to SQL Server 2005, SQL Server runs as a user mode process like any other Windows application and it depends on...