Viewing 15 posts - 1,426 through 1,440 (of 2,496 total)
Asking for 3.5 GB for each instance is probably more memory than is available. You will need to experiment with values between 3GB and 3.5 GB to see what...
March 17, 2009 at 6:01 am
You will need to have the /PAE and /3GB switch in boot.ini and AWE active on SQL Server in order to get the memory use you want.
I think most of...
March 17, 2009 at 4:19 am
Things are being put into tempdb because SQL Server needs to put them there. The trick is finding out what is triggering this behaviour. Did the hardware also...
March 17, 2009 at 4:10 am
At my old place the system DBs were on different disks to the user DBs. The user DB disks were replicated but the system DB disks were not.
Each server had...
March 16, 2009 at 6:57 am
It is worth looking at what patches are being applied. You can normally patch Windows on a server by server basis without risk to this type of environment. ...
March 16, 2009 at 6:02 am
This sounds like a relatively high-risk approach to your company's storage requirements. Document your concerns. Try to give required read and write I-Os per second, average and peak...
March 16, 2009 at 5:48 am
The underlying application sounds a good candidate for sparse columns in SQL Server 2008.
March 16, 2009 at 5:41 am
You can write a custom iFilter to limit the scope of Full Test search.
The job of the iFilter is to take the original document and strip away the documnt formatting...
March 16, 2009 at 4:50 am
The best advice is to go for 64-bit and SQL Server 2008 on Windows 2008. This will give you an operating platform that will stay current technology for the...
March 16, 2009 at 4:40 am
My old place used this approach, and it worked fine.
The full setup they had was:
1) Server 1 in DC1 in UK, all drives attached to SAN1
2) SAN 1 replicating SQL...
March 16, 2009 at 4:33 am
I cannot answer your RS query, but I can give some general advice about in-place upgrades from SQL 2000 to SQL 2005.
A significant number of upgrades will fail during the...
March 12, 2009 at 8:27 am
You can run your DTS packages unchanged on SQL Server 2008. There are a lot of advantages to be gained from migrating them to SSIS, but I'll leave those...
March 10, 2009 at 4:18 am
See the post from Piotr Rodak at http://www.sqlservercentral.com/Forums/Topic541937-146-1.aspx
I was going to write something similar, but Piotr has said just about all you need. Work out what users you...
March 10, 2009 at 4:06 am
If you want to give access to SQL Server for a group of users, the best way is to get the users added to a Windows group and then give...
March 10, 2009 at 3:56 am
You can access your Filestream data via T-SQL. However, you can also read your Filestream data directly via a C# (etc) program, without any need to pass the data...
March 9, 2009 at 10:25 am
Viewing 15 posts - 1,426 through 1,440 (of 2,496 total)