Performance DashBoard
Introduction to Memory-Optimized Tables
Transact-SQL Execution: In-Memory OLTP achieves the best performance when using natively compiled stored procedures rather than interpreted stored procedures or query execution. There can be a benefit to accessing memory-optimized tables from such stored procedures.
Range Scan vs Point Lookup: Memory-optimized nonclustered indexes support range scans and ordered scans. For point lookups, memory-optimized hash indexes have better performance than memory-optimized nonclustered indexes. Memory-optimized nonclustered indexes have better performance than disk-based indexes.
DBCC CHECKDB
DATA_PURITY
Causes DBCC CHECKDB to check the database for column values that aren't valid or out-of-range. For example, DBCC CHECKDB detects columns with date and time values that are larger than or less than the acceptable range for the datetime data type; or decimal or approximate-numeric data type columns with scale or precision values that aren't valid.
[
What Default 'SA' SQL Admin user Password
Boolean Data Type
Difference between Left Join and Inner Join
Use a LEFT JOIN operation to create a left outer join. Left outer joins include all of the records from the first (left) of two tables, even if there are no matching values for records in the second (right) table.
You can use an INNER JOIN operation in any FROM clause. This is the most common type of join. Inner joins combine records from two tables whenever there are matching values in a field common to both tables.
Mandatory
If in case 'Not Null' is specified for column while creating table, that column value becomes mandatory to be filled while inserting data.
]
Additionally,
What is SQL Server on Windows Azure Virtual Machines?
Connect to a SQL Server virtual machine on Azure (Portal)
Best Regards
Amit Vaid
No comments:
Post a Comment