Viewing 15 posts - 646 through 660 (of 2,498 total)
The SQL Experss media does not include any of the pre-requisite software components needed for SQL Server. You have to deral with this yourself.
Are you checking for and installing...
April 3, 2013 at 3:28 am
SQL 2008 R2 introduces support for Second Level Adderss Translation (SLAT). If you run it on Windows 2008 R2, you should see about a 5% performance improvement over running...
April 3, 2013 at 3:19 am
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
Viewing 15 posts - 646 through 660 (of 2,498 total)