Viewing 15 posts - 901 through 915 (of 2,496 total)
i'd ask for an install document. no doubt you will need to setup logins, agent jobs, deploy scripts etc...... ?
I completely agree. If you do anything without having read...
June 6, 2011 at 4:09 am
It is bad practice for a SQL Agent proxy account to be a local administrator. The aim should always be to minimise the rights granted to a proxy account.
You...
June 6, 2011 at 3:05 am
I do not know if error message 29512 is deliberately displaying the account name in the form account@domain or merely showing the account in the form in which it has...
June 1, 2011 at 6:45 am
I think there are 2 things you should do.
1) Set a maximum memory value for SQL Server. If you do not do this then buffer pool memory can swamp...
May 31, 2011 at 3:48 am
Thanks Gail :cool:. Just after I clicked Post I realised I had got this wrong. I have gone back and fixed my posts.
May 25, 2011 at 2:48 am
didn't want the OP to think RowVersion is a DateTime
Due to a stange decision in the history of SQL Server, the data type known as DateTime Timestamp does not...
May 25, 2011 at 2:40 am
To avoid doubt, Agile does not mean deliver whatever state it is in. There is a lot of rigour around Agile so that you only deliver what is working,...
May 24, 2011 at 7:56 am
I have worked in commercial IT since 1974 and have seen many approaches to getting applications delivered. The agile methodology using Scrum (and its variations) is by far the...
May 24, 2011 at 4:03 am
I have put this information in the FineBuild reference manual. The best download if you just want this information can be found at http://sqlserverfinebuild.codeplex.com/releases/view/65785
May 23, 2011 at 4:57 am
The SQL Server service account never needs to be a local admin. Many people make it a local admin because they don't want to spend the time to look...
May 23, 2011 at 4:15 am
Row versioning and version store are different things.
Row Versioning is what happens to rows. Every change to a row changes the row version Id.
Row versioning has been...
May 23, 2011 at 4:03 am
My approach would be to do a standard side by side build and test of the new server.
When it comes time to put the new server live, go...
May 18, 2011 at 6:45 am
If you have a SSRS report that has a multi-value parameter and you want to pass the selected values to a stored procedure in the form 'valuea,valueb,valuec' you can do...
May 18, 2011 at 6:31 am
I also think that uninstall of an old SQL cluster and install of a new SQL cluster on the same Windows OS is not a safe option for a production...
May 18, 2011 at 6:23 am
Viewing 15 posts - 901 through 915 (of 2,496 total)