|
|
|
|
-
Temporary tables are just that. They are used most often to provide workspace for the intermediate results when processing data within a batch or procedure. They are also used to pass a table from a table-valued function, to pass table-based data betwee...
|
-
**When can this happen automatically?**
Creating or dropping clustered indexes requires rewriting the entire table. If the table has nonclustered indexes, all the nonclustered indexes must all be recreated whenever the clustered index is changed. The...
|
-
The Output clause gives access to Inserted, updated or deleted rows of a table. In SQL Server 2005 this was possible only through Triggers.
Imagine a scenario that while inserting a value in a Person table, for audit purposes you need to insert a ...
|
-
**Introduction**
A deadlock is a situation wherein two transactions wait for each other to give up their respective locks.
When this happens, the SQL Server ends the deadlock by automatically choosing one and aborting the process, allowing the oth...
|
-
**What are Ranking Functions?**
Ranking functions were first introduced in SQL Server 2005. They are used within the column list of a query to create a new column containing an integer value for each row in a set of results. For example, the Row_Numb...
|
-
**Why Indexed Views?**
Views have been available throughout the history of Microsoft SQL Server. However, using views that return very large result sets can lead to poor performance, as the result set is not indexed and the entire result must be tabl...
|
-
**What is a Collation?**
Collation is a collection of rules that dictates how SQL Server encodes, stores, sorts and compares character types.
Collations have no effects on the way Unicode types (nvarchar or nchar) are stored , but the Collation ru...
|
-
**You have more locks than you think**
- You have a shared database lock
every time you connect This helps
someone from making the database
read only while you're on One update
on one row will give you three
additional lock...
|
-
:) feel so late to answer this quiz
interested in following answers
WHERE name LIKE '[A-J]%'
WHERE SUBSTRING( name, 1, 1) BETWEEN 'A' AND 'J'
WHERE 'A' <=SUBSTRING(name, 1, 1) AND 'J'>=SUBSTRING( WHERE 'A' <=SUBSTR...
|