Viewing 15 posts - 646 through 660 (of 2,496 total)
SP4 can be applied on top of SP2. You do not have to install SP3 first.
After you have installed SP4, you should also install the Security Update that was...
April 3, 2013 at 2:56 am
If you are designing a multi-TB database and do not understand all the design issues you need to pay to outside help. Period.
When processing a database of this size,...
April 2, 2013 at 4:19 am
I work with some non-profit organisations that use MailChimp for their mailings.
My employer sends out a few million mails per day and uses PowerMTA to process this workload.
The more mails...
April 2, 2013 at 4:13 am
The organisation I work for reckons that if its systems were down for 5 consecutive days its business would be destroyed. Maybe we would not be bankrupt, but we...
April 2, 2013 at 3:02 am
Just to make life interesting, you cannot use the .Net 3.5 install media that is included with SQL Server to install .Net 3.5 on Windows 8 or Windows 2012.
You need...
April 2, 2013 at 2:51 am
There is no 'best' method to replicate a database based on its size. There may be a 'best' method depending on what the business requirements are.
If this is a...
April 2, 2013 at 2:40 am
If you want to enable the T1118 flag in SQL Express there is nothing stopping you from doing so.
However, because SQL Express (SQL2008 upwards) has a maximum database size of...
March 28, 2013 at 3:45 am
You say you have restored the SQL 2005 ReportServer db and ReportServerTempdb to your SQL 2008 R2 system and are using those with the SQL 2008 R2 binaries.
If so, I...
March 26, 2013 at 8:21 am
If you put the maximum possible on a separate drive on a SQL install, you will end up with about 3GB on the system drive and about 800MB on your...
March 26, 2013 at 8:18 am
The majority of the disk IO is to the GAC. This always exists onthe C: drive.
In any event, the IO to the OS and SQL binaries is in single...
March 13, 2013 at 5:44 am
One aspect is that you need to do all changes that affect a SQL 2012 box from SQL 2012 Management Studio. If you use SQL 2008 R2 SSMS, then...
March 13, 2013 at 5:18 am
If this is a Primary Key, then it is by definition a unique key. You need to consider your reasons for re-ordering the columns in this key, as this...
March 13, 2013 at 4:55 am
I am not sure there is a best practice on this any more. Back in SQL 2000 and NT4 days people normally installed programs in a separate drive to...
March 13, 2013 at 4:29 am
Are you at the latest fix level? For SQL 2000 this is SP4 plus http://support.microsoft.com/kb/983811. However, I have no idea if this will solve your problem.
Try exporting the...
March 13, 2013 at 4:02 am
Viewing 15 posts - 646 through 660 (of 2,496 total)