SP_MONITOR is a SQL Server Database Engine system stored procedure which is used to Display statistics about Microsoft SQL Server.
849 total views
SQL Server SP_NAME is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.
2,547 total views, 9 views today
How to get the sizes of all databases on a SQL Server ?
748 total views, 5 views today
How to send a SQL Server Query result in e-mail message?
If we have configured SQL Server Database Mail then we can easily send query result as an attachment in mail body.
19,499 total views, 72 views today
Troubleshooting Database Mail
If you are not getting Database Mail after configuring it , you need to got through few more step to fix it.
1,486 total views, 2 views today
In SQL Server there are new Dynamic Management Functions that is used to keep track of Object Dependencies sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities.
1,093 total views
How to Find out Identity Column Without Using Column Name ?
490 total views, 1 views today
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.
4,737 total views, 17 views today
How to Retrieve data in XML Format in SQL SERVER ?
2,119 total views, 16 views today
how to delete duplicates records from a table in sql server ?.
608 total views, 1 views today
SQL Server Interview Question & Answer Quiz on CREATE statement
602 total views, 2 views today
SQL interview question and answer on Substring function
2,173 total views, 7 views today
How to get the full text descriptions / definitions of any stored procedures , UDF or triggers in SQL ? There are many ways to… Read More »Get the definitions of Stored procedures, User Defined functions and Triggers in SQL
1,329 total views, 7 views today
How to get the list of all the files in a folder into SQL table ?
24,520 total views, 98 views today
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?
1,062 total views
How to copy a data of table from another database in SQL Server?
Suppose, you have a database1 and table1 and one another database2 and table2 in SQL server.
Now you are required to select data of a table1 of database1 from database2 of table2.
What would be a query for that?
13,339 total views, 42 views today
How to check if User table or Temp table exists in database?
1,494 total views, 11 views today
A Cumulative total or running total refers to the sum of values in all cells of a column that precedes the next cell in that particular column
4,545 total views, 12 views today