|
|
-
|
|
I just learnt that, based on the frequency of data access and type of storage, there are three different categories of data.
**Hot Data**: Data that is frequently accessed and stored on high speed storage/disks.
**Warm Data**: Data that is moderat...
|
|
-
|
|
If you want to create a row based checksum, you can use build-in functions CHECKSUM or BINARY\_CHECKSUM. Unfortunately, these functions are not precise enough - the chance to get the wrongly equal values is relatively high.
There is another function - H...
|
|
-
15
Liked
| 15
Learned
| 5
Comments
|
|
If you write a lot of dynamic TSQL queries, you might have experienced the problem of query text getting truncated when you try to print them for diagnostic purposes. A SELECT instead of PRINT will help, but you will loose formatting when the result str......
|
|
-
|
|
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has been ...
|
|
-
|
|
Earlier this week, one of the developers encountered issues when he tried to make a copy of the database on the server instance with a different name. He used the copy database wizard to perform this task. I was under the impression that he used the bac...
|
|
-
|
|
I have just tried to connect SQL Server default local instance by providing "." as server name and able to connect. We can connect with "(local)" also.......
|
|
-
|
|
Just found that all the below queries will return current database name.
[CODE]
SELECT DB_NAME(0)
SELECT DB_NAME()
SELECT DB_NAME('')
[/CODE]......
|
|
-
|
|
This is inspired from recent madhi's JL item.
An Identifier needs to follow certain rules.
1. First character needs to be any one of the characters (Alphabetical, Underscore(_) symbol, Hash(#) Symbol),@ sign
2. Remaining characters needs to be ......
|
|
-
27
Liked
| 22
Learned
| 5
Comments
|
|
While you are working in Query window, if you want to delete the current row, you have to highlight entire row and press delete key. Another alternate is to use SHIFT+DEL key. The cursor can be at any position and the entire row will be deleted......
|
|
-
|
|
You should note the behaviour in the expressions used in the ORDER BY Clause
[code]select 1 as a, 2 as b order by GETDATE()[/code]
The following code throws an error Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarcha......
|
|