SQLServerLog.com

SQLServerLog.com - Database Tips, Techniques and Tutorials

0

SQL Commands / SQL Server

SQL WHERE Clause

The WHERE clause is used to restrict the number of rows returned by SELECT statement, in this case SELECT statement return the rows only if the condition specified in the WHERE clause is satisfied. Syntax:...

0

SQL Commands / SQL Server

SQL Aliases

Sometimes you want to change the column names to make them more readable, SQL aliases are used to change the names of tables or columns headings, it is used as follows: Syntax SELECT column_name AS...

0

SQL Commands / SQL Server

SELECT Statement

The SELECT statement is used to retrieve the useful data from one or more tables in a database. The basic use of SELECT statement is as follows: Syntax: SELECT * FROM TableName          –To select all columns or...

0

Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials

Identify Database Bottlenecks with Performance Monitor Counters

445viewsPerformance monitor is a free tool provided by Microsoft windows and is very useful to analyse real time and historical performance information of your database servers and windows servers. So if you don’t have...