As per this MSDN , yes its not supported .

http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspx

But there is a tweak 🙂

Copy DatabaseMail90.exe, DatabaseMailEngine.dll and DatabaseMailProtocols.dll into the MSSQL\Binn directory and execute below mentioned...

IO does not crash a page but an incomplete IO does .

Actually , an OS page is divided into 512 byte sectors .

Every sector has to be written completely .If...

I disagree with you Ed (apologize in advance).

As per you if file 1 is 100 MB and file 2 is 50 MB [the ratio is 2:1], file 2 will grow...

AWE allocated will show you at many places in 2005 in dbcc memorystatus .As I sad use perfmon for clarity .

Regards

Yes , when the failover occurs the backups will fail as your principal will be mirror and viceversa .You need to have the same jobs configured on the mirror as...

It should work :

Once you failover to the other server with 2 GB Ram this setting should be ignored .

Basically /PAE will give eyes to the OS to be able...

Nice one Jack ....

Cheers

If you keep the auto-growth on then engine will follow the proportional fill algorithm .However the moment one of the file hits its limit then it will use the other...

used meforeach table as well :

-------------------------------

1)

Need to create this SP in all the user databases

----------------------------------------------------

create procedure rebuild_index

as exec sp_msforeachtable 'dbcc dbreindex("?"," ",100)'

2)

EXEC master..sp_MSForeachdb 'USE...

Gail is correct .......its not able to open the MDF file ..

Check the SQL Server error logs for the actual error and copy here ..

It could br due to OS...

Cache is inside the buffer Pool ..its a subset .

After all the practicals i found that if you create a new NDF with same zide as of old MDF and both the files are in same filegroup it will...

try BCDEdit.exe or Bootmgr.exe

for short ,when you create a table you need to select the partition scheme and file groups.In partiton scheme you will mention partition function .

Now the clustered index has the...

I would suggest create different filegroups first

and then create new files in those filegroups .make sure you use new physical disks if cost is not a constraint else you...