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
The SQLOS Prior to SQL Server 2005, SQL Server runs as a user mode process like any other Windows application and it depends on...
I wanted build an expression to make a folder name dynamically. (Basically expressions are anyway dynamic in nature) So I simply used the ...
OSTRESS is a Microsoft tool comes with RML utilities package and it uses to stress SQL Server. This is especially useful when you want to tr...
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...