Viewing 15 posts - 601 through 615 (of 2,496 total)
This probably needs to be raised as a problem with Microsoft.
SQL 2005 is out of support, so you will only get some help from them if you can show the...
June 17, 2013 at 3:23 am
Direct http access to SQL Server was deprecated a few releases ago and does not exist in SQL 2012. I would advise you look for an alternative solution that...
June 17, 2013 at 3:21 am
sounds as simple as "merge replication" or "log shipping".
More like log shipping than merge replication, certainly in terms of complexity and effort.
June 10, 2013 at 8:43 am
There are other ways of tackling this issue, but they do not exist yet for SQL Server.
Back in the late 1990's a number DB2 shops stopped taking full backups of...
June 10, 2013 at 3:36 am
This link might help you work out and fix some of your issues: http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management
June 3, 2013 at 3:43 am
The risk of extended downtime grows with the age of the software.
1) The more changes you put on your VM host the greater the risk of an old...
June 3, 2013 at 3:32 am
If you are buying a new license or have your existing licenses under Service Assurance, then you are bound by the SQL 2012 licensing rules regardless of which version of...
June 3, 2013 at 3:20 am
It is now very rare for a SAN to assign a LUN from contiguous disk space. Most SANS work with some form of track vector mapping. You should...
May 29, 2013 at 7:32 am
Test your intended process using a sandbox server before doing it with real data. This will help you find anything you have missed.
My personal preferance is to build a...
May 29, 2013 at 7:20 am
Using the Cloud can significantly speed up the server provisioning cycle.
It used to take about 3 months for us to move from proposal to in-use server, but after...
May 28, 2013 at 4:05 am
http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management covers some Windows settings for memory use.
As other people have said, you also need to consider AV and Firewall settings, amongst other things. For example, on Windows 2012,...
May 28, 2013 at 3:44 am
Personally, I like to write report SQL within a Stored Procedure, and just call the SP within the report.
This allows me to test that the correct data is...
May 28, 2013 at 3:38 am
It is easy for people to look at what might make their own job easier, but if you get paid for your work you need to look at what gives...
May 28, 2013 at 3:34 am
It is supported, but as a guy called Paul once said 'All things are possible, but not all things are advisable'.
There are no data integrity or performance reasons for moving...
May 20, 2013 at 6:18 am
Microsoft have made a problem for themselves with the Virtualisation Tax (aka Software Assurance) you have to pay when running SQL Server in the Cloud.
I must stress this...
May 20, 2013 at 5:25 am
Viewing 15 posts - 601 through 615 (of 2,496 total)