Viewing 15 posts - 76 through 90 (of 167 total)
On the question of 64-bit over 32-bit, I don't believe that it is as clear-cut to say 64-bit will always perform better than 32-bit. There are a couple of situations...
June 16, 2008 at 8:03 am
Hi Slawek,
You might also want to look at Paul Randal's take on multiple data files
plus, might want to look at this:
Paul's basically saying that unless...
May 22, 2008 at 9:41 am
Fantastic article. Many thanks for sharing your work. 🙂
May 16, 2008 at 2:42 am
Hi GilaMonster,
Good luck with this. It's worth fighting to get this right. I spec'd and worked on a SAN system almost from the beginning of the project. The system was...
May 14, 2008 at 2:54 am
And also the following link http://msdn.microsoft.com/en-us/library/ms190940.aspx
Plus, Henderson K (2007), SQL Server 2005 Practical Troubleshooting The Database Engine, pp51-52.
May 8, 2008 at 2:28 am
Fantastic article, Jeff.
Many thanks.
May 7, 2008 at 6:05 am
I have to agree with TheSQLGuru re: the vendor setting up the SAN...from painful past experience. If you haven't started using it yet, then you may stand a chance of...
March 27, 2008 at 12:07 pm
Whilst I don't know the answer you're looking for DBADave, I can put forward an offical reference to something mentioned earlier re: schema qualifying...
'...
A query that contains schema-qualified table names...is...
March 27, 2008 at 11:33 am
Hi Loner,
There's also some restrictions re: what Editions can participate as (witness, partner). Worth looking here for quick reference:
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
February 6, 2008 at 7:58 am
ok...I'm going to go with some assumptions here...
(1) when you talk of partitions '...Sometimes we divide our harddisk into different partitions, giving us different mapping names (G:, H:, I: etc)....
February 6, 2008 at 6:14 am
Even better, ensure you rebuild indexes and gain the benefit of a 'full scan' for the stats too... 🙂
February 6, 2008 at 5:47 am
Mark,
You might want to put this in the "SQL Server 2005 --> Data Corruption" forum as Paul Randal is often in there and may be able to help...
February 1, 2008 at 5:52 am
Hi cranfield,
Don't know if this would be of use, but you could make use of your code to autostart jobs again following a reboot. You can do this by setting...
January 31, 2008 at 10:16 am
Viewing 15 posts - 76 through 90 (of 167 total)