Viewing 15 posts - 1,486 through 1,500 (of 2,496 total)
Shailesh,
You seem to be farily new to the complexities of managing large SQL Server databases. Grant is giving good advice, and if you put your questions into Google you...
February 12, 2009 at 5:19 am
There are no issues in having .Net 3.5 SP1 installed on a machine running SQL Server 2005.
However, a number of people have found that installing .Net 3.5 SP1 on a...
February 12, 2009 at 5:06 am
If all the rows on a page are deleted by the DELETE command the page will be marked as empty. If all the pages in an extent are empty,...
February 12, 2009 at 5:00 am
required privilege is not held
This sounds like a Windows rights problem. Windows rights are not cluster-aware, and have to be set for each server in the cluster.
Does the proxy...
February 12, 2009 at 2:41 am
You can connect to RS from SSMS, but there is not a lot you can do. You need to use the Report Manager tool to manage RS. See...
February 11, 2009 at 3:33 am
About 4 years ago someone calculated that the theoretical maximum amount of storage you could address in a single SQL Server database exceeded the total amount of disk storage that...
February 11, 2009 at 3:30 am
There are some things that work differently when you run in Fiber mode (lightweight pooling). In SQL Server 2000, server stability was one of the things affected, but this...
February 11, 2009 at 3:17 am
The sp_changeobjectowner procedure has a gotcha. You cannot reasign ownership to an existing database user.
The solution is simple. Drop the user you want to be the new owner...
February 11, 2009 at 3:02 am
If you are having to shrink files because you are running out of disk space then you need to get more disk space. Repeated shrink and grow of database...
February 10, 2009 at 7:59 am
The problem on the Failover node is not due to a service pack.
DTS (and SSIS) are not cluster-aware. This means you have to manually install these components on all...
February 10, 2009 at 3:15 am
Repeated shrinking and growing a database file will harm your performance. You should not shrink a database file unless you know there will be a permanent reduction in the...
February 10, 2009 at 3:03 am
I completely agree with steveb's comments.
You should only shrink a database file if you know there will be a permanent reduction in the space needed.
If you think a...
February 10, 2009 at 3:00 am
You will almost certainly need to reinstall Windows to fix this problem.
SQL Server 2008 install needs Windows Installer 4.5, and Windows Installer 4.5 needs .Net 2.0 SP2. The only...
February 9, 2009 at 3:36 am
Badly fragmented disk files can cause performance issues in SQL Server. The impact will depend a lot on the underlying disk subsystem.
If your Windows disks map to...
February 6, 2009 at 2:57 am
SQL Server only works on a Microsoft operating system. There may be other considerations for running SQL Server on a mobile, but I am not an expert on how...
February 5, 2009 at 8:20 am
Viewing 15 posts - 1,486 through 1,500 (of 2,496 total)