|
|
-
|
|
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...
|
|
-
|
|
ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($)
after getting one bug i learn this from bol...
|
|
-
|
|
Was trying to install HDInsight on Windows 7 machine but when I tried running the [Microsoft Web Platform Installer][1] and searched for [Hadoop or HDInsight][2], the search was failing. After some search online, I found that, HDInsight for Windows is a...
|
|
-
|
|
One common misconception about checkpoints is that they only write out pages with changes from committed transactions. This is not true—a checkpoint always writes out all dirty pages, regardless of whether the transaction that changed a page has committ...
|
|
-
|
|
This short tip is a result of my quick research in attempt to solve this MSDN thread
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/f02aefbd-09a5-4336-84d2-d67bdf238221
In order to use case sensitive search with PATINDEX we need to us...
|
|
-
|
|
If a table (temporary or permanent) is created in the same batch with the query, SQL Server has to recompile the query since the query definition is unknown when the batch is compiled the first time. This is not the case for table variables....
|
|
-
|
|
While writing Stored procedures if the comments are not included in the same batch as that of stored procedure they are not attached to stored procedure.
To understand the above scenario let us consider the following example
/*
Author...
|
|
-
|
|
We may came across situation to rebuilding new log file while attaching database to SQL server. By we doing that we know backup chain will be broken. Also, If you notice recovery model database it has been changed to SIMPLE.
So,we need to make it to FU...
|
|
-
|
|
SQL Server 2008 R2 has new feature to Deploy Report parts.
i.e You report has Table, Chart, Image etc then You can Deploy there report Whole and in parts as well.
To do that Go to Menu Report-> Publish Report Parts (Select The part you want to Deploy...
|
|
-
|
|
**Level 100 :**
Introductory level subject. Assumes that the audience is NEW to the topic.
**Level 200 :**
To drill down on a topic and empower audience to become advance and expert users
**Level 300 :**
To provide technical details necessary to st...
|
|