Viewing 15 posts - 661 through 675 (of 2,497 total)
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
You might like to look at http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20AWE%20Property for more details of how the AWE property works.
March 13, 2013 at 3:41 am
My thoughts, FWIIW...
Any type of deployment needs a business case. For some cases a virtualised solution will be the cheapest and easiest to manage, while for others a physical...
March 11, 2013 at 5:22 am
This can be done,but you need to develop your own code to do this.
Some of the best online job boards (such as the Totaljobs Group boards) use this type of...
March 11, 2013 at 5:06 am
Michael had the answer. Put the SQL Cluster offline using the cluster administrator. This will stop the SQL services.
You can then close down the cluster. Shut down...
March 11, 2013 at 4:49 am
Best Practice advice is do not mode master, model or the resource database. There are no performance or data integrity reasons to move these databases, so all you are...
March 11, 2013 at 4:44 am
What you are talking about is known as 'Transitive Predicate Closure' or 'Transitive Closure'.
SQL Server knows how to do this for certain predicate operations, but not for all of them....
February 27, 2013 at 3:38 am
I had never heard of TF 2371 until seeing your post. From looking at http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx it seems to me that TF 2371 would be useful in the following situations:
a)...
February 27, 2013 at 3:28 am
Consumers view ads as a distraction or obstruction which prevents or delays their enjoyment of content. Any other interpretation is just wishful thinking.
Totally agree!!
February 26, 2013 at 7:33 am
As always, you need to look at your RTO (Recovery Time Objective), your RPO (Recovery Point Objective) and the value to the business of lost time or data. It...
February 26, 2013 at 4:48 am
You might want to look at SQL FineBuild. This can help you simplify and standardise your command line installs of SQL Server.
February 26, 2013 at 4:38 am
All of my organisation's database servers are running in AWS and therefore virtual. We use both SQL P2P and standard transactional replication in just the same way as we...
February 26, 2013 at 4:35 am
I think targeted advertising is OK providing that the end user is made explicitly aware of what the targeting preferences are.
Taking the Orbitz example, it could be argued that targeting...
February 26, 2013 at 4:32 am
It looks like you have got all your drives mapped as separate partitions on a single Windows volume.
You need to rebuild this so that each drive letter has its own...
February 19, 2013 at 2:45 am
You need to do some capacity planning.
The areas you need to work out are: a) CPU requirement, b) Memory requirements, c) IO Requirement d) Total disk space requirement.
To...
February 18, 2013 at 5:15 am
Viewing 15 posts - 661 through 675 (of 2,497 total)