AND and OR Operator in Sql Server
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...
2014-08-13
554 reads
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...
2014-08-13
554 reads
Sum():- This function is used to get the sum of values of the specified numeric column.
Syntax:-
Select Sum (column_name) from tablename
Example:-...
2014-08-12
706 reads
Round():-This function is used to round a numeric field to the number of decimals specified.
Syntax:-
ROUND ( numeric_expression , length [ ,function ]
numeric_expression...
2014-08-12
854 reads
This function returns the distinct values from the left query that are not also found on the right query. For...
2014-08-12
773 reads
Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the...
2014-08-11
413 reads
1. All the tables in the database have properly defined relationship using primary keys and foreign keys .
2. Indexes should...
2014-08-11
2,281 reads
This function is used to select the values within a specified range. These values can be of Int type or...
2014-08-11
341 reads
Left():- This function returns the specified number of characters from the left part of the given character string.
Syntax:-
Select LEFT ( character_expression...
2014-08-11
948 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.
Syntax:-
Select RIGHT ( character_expression...
2014-08-11
766 reads
This function is used to returns distinct values that are returned by both the query on the left and right...
2014-08-11
1,065 reads
By Rohit Garg
What Is TempDB and Why It Matters TempDB is a shared system database in SQL...
By Daniel Janik
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure...
By Kevin3NF
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Capacity Planning for an Existing...
Comments posted to this topic are about the item Connecting to PostgreSQL with Node.js
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers