Apologies, but I meant that still 10% un-clarity is there as referencing this Paper: http://www.emc.com/collateral/hardware/white-papers/h6665-symtrx-microsoft-windows-server-wp.pdf

It states that: (Below Fig 12: Page 27) for Win...

Thanks .. now I am clear on it.

Also, made an edit to my answer

Update:

The whitepaper from EMC also states the same .. (Windows 2003 server)

http://www.emc.com/collateral/hardware/white-papers/h6665-symtrx-microsoft-windows-server-wp.pdf

Page: 27,...

Perry Whittle (7/11/2012)

---

SQLQuest29 (7/11/2012)

---

Thanks a lot Perry for the clarification !

Still confused with http://msdn.microsoft.com/en-us/library/dd758814.aspx

Valid Starting Partition Offsets

Because versions of Windows earlier than and including Windows Server 2003 comply with...

Thanks a lot Perry for the clarification !

Still confused with http://msdn.microsoft.com/en-us/library/dd758814.aspx

Valid Starting Partition Offsets

Because versions of Windows earlier than and including Windows Server 2003 comply with the 63 hidden...

rummings (5/14/2012)

---

I read an article that stated that the .mdf and .ldf should be on different disks. Each time I create a new database, I make sure to adhere to...

Very well written and insightful.

Thanks for the article

Good script..

This will only work for SQL server 2008 and plus.

You wont be having data only...

Thanks .. got it !

I was struggling with http://www.sqlservercentral.com/Forums/Topic1282812-1351-1.aspx and did not find any solution.

Is it possible for you to point me in right direction.

Thanks .. that helped.

how can I make the script to take a user input and enable or disable the job ?

Do I have to use -- read-host for any...

why not use POSH (Powershell) ?

easy, convenient and efficient 😀

Simha24 (3/26/2012)

---

SQL Server sends a new query notification to the application, SQL server can’t find the remote service.

Following errors are getting logged in application log. beacause of any loggings...

Matthew Darwin (3/15/2012)

---

Well as soon as you alter the collation, you're changing the sort order from the way in which the index is currently sorted, and so you will no...

Matthew Darwin (3/15/2012)

---

Well as soon as you alter the collation, you're changing the sort order from the way in which the index is currently sorted, and so you will no...

Matthew Darwin (3/15/2012)

---

The problem looks to be the predicate for your scan is using CONVERT_IMPLICIT for your dealer_id and account_no.

I'm guessing this is being caused by the difference in collation...