|
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
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...
|
-
Guru Samy Learned 4 Months ago through Just Learned | 1 Point
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...
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
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 comm...
|
-
Guru Samy Learned 4 Months ago through Just Learned | 1 Point
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 comm...
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
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...
|
-
Guru Samy Learned 4 Months ago through Just Learned | 1 Point
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...
|
-
Guru Samy Learned 5 Months ago through Just Learned | 1 Point
I just learned how to setup a RSS subscription on stackoverflow tags.
There are couple of ways:
1) Just hover your mouse over the tag to see the "RSS" button:
2) Scroll to the bottom of the page to see a RSS link:
And If you know the tagname, here...
|
-
Guru Samy Liked 5 Months ago through Just Learned | 1 Point
**Hold Control and shift key while Clicking on Program icon**.
**For example:** You want to open visual studio with administrator rights then **Ctrl + Shift + Click on visual studio icon**...
|
-
Guru Samy Learned 5 Months ago through Just Learned | 1 Point
**Hold Control and shift key while Clicking on Program icon**.
**For example:** You want to open visual studio with administrator rights then **Ctrl + Shift + Click on visual studio icon**...
|
-
Guru Samy Liked 5 Months ago through Just Learned | 1 Point
Whenever you have a filtered index you just might find that it's not used when its columns are compared to a variable.
The thing is, SQL Server will always make an Excecution Plan that would work with any values for those variable (including the valu...
|