GilaMonster (3/21/2013)

---

SQL* (3/21/2013)

---

If there is any corruption while writing the data to PRIMARY File Group's files the database will not available to access. We can make the Database available by...

hey thanks, but after restarting the sql server also is giving the same problem. what is happening is...

opc.three (2/13/2013)

---

I am not exactly sure what you're after but if you provide two sample XML documents and your expected results per your thoughts on the filtering and joining requirement...

anthony.green (1/29/2013)

---

Are you familiar with fractions of time?

10th of a second

100th of a second

1000th of a second

etc.

Well a nano second is 1 billionth of a second.

So time is actuate to...

Lynn Pettis (1/28/2013)

---

It means the time reported is accurate to 100 nanoseconds. You won't get any time values less than that reported.

If you need more information you may want...

Thank you.

Divine Flame (1/28/2013)

---

SQL* (1/27/2013)

---

To delete rows in a heap and deallocate pages, use one of the following methods.

Specify the TABLOCK hint in the DELETE statement. Using the TABLOCK hint causes...

Thank you,

Great explanation

Kingston Dhasian (1/28/2013)

---

A nanosecond (ns) is one billionth of a second (10-9 or 1/1,000,000,000 s)...( From Wikipedia http://en.wikipedia.org/wiki/Nanosecond )

As an example, a variable with data type TIME may store a...

HowardW (1/25/2013)

---

ScottPletcher (1/24/2013)

---

Seems an odd way to read it in context here, since the OP stated in his original post that he could index a computed column w/o explicitly persisting...

Hi,

From the MSDN we have a below statements,

"To delete rows in a heap and deallocate pages, use one of the following methods.

Specify the TABLOCK hint in...

Hi,

Thanks,

But can you tell me any scenarios where we can use Clustering/Mirroring together.

Actually I am very much confused on High availability/Disaster Recovery options.

High availability : Means 99.99% of...

🙂

I got the importance of the Computed column, but what about other questions? PERSISTED/Creating Index on Calculated column.

Thanks for your explanation.

But still i am not getting the exact point of HA vs DR. Can you tell me in which case each of the solution is applied for...

Actually the SP is calling one more SP, in that sp we have used the same temp table.

Thank you,