Viewing 15 posts - 2,131 through 2,145 (of 2,496 total)
SQL 2005 Reporting Services is included in the normal SQL 2005 install media.
When you do the SQL 2005 install, what do you see on the displays showing the System Configuration...
March 12, 2007 at 4:47 am
SQL 2005 creates a number of local groups during the install process. BOL has the full details of this. They hold the service accounts used to run the various SQL...
March 9, 2007 at 5:56 am
There are normally no issues in SQL Server in using views, or in using a hierarchy of views. SQL Server will merge the syntax of your ultimate SQL query with...
March 9, 2007 at 5:49 am
I think the Upgrade Advisor uses the features in the RTM version of SQL 2005 as a target. It will not tell you about restrictions added in fixes since RTM. ...
March 9, 2007 at 5:41 am
You can create a database on Dev or EE edition and set up partitioning. Take a backup of the database and restore it to Standard Edition, and it should work OK. ...
March 9, 2007 at 5:35 am
I have run the normal Windows defrag tool on our non-production servers while SQL is running. The disks defrag OK, and SQL is not harmed - this is the result...
March 9, 2007 at 5:24 am
The path you specify during the install is a high-level path. SQL will add additional folders to this path as it sees fit to hold the various SQL components.
SQL2000 likes...
March 9, 2007 at 5:11 am
There are many things that can be done, but you need to start from the DW requirements documentation and potential SLAs. This should tell you more about how much data...
March 6, 2007 at 3:07 am
Chris,
I think you are wrong about AWE and PAE. PAE applies only to Windows, and enables the adressing extentions to allow Windows to access memory over the 4GB line. AWE only applies...
March 2, 2007 at 3:37 am
I have not tried this on Vista, but a common performance issue is certificate checking. By default, managed code that has a certificate will cause the OS to check those...
March 1, 2007 at 3:53 am
This works for us. The process starts with building a virtual domain and installing SQL on virtual servers. If you already have a Windows cluster, start at...
March 1, 2007 at 3:38 am
Try a Google search. I think this is a known bug. The permissions are set but the dialogue does not show them. You can maintain the permissions using GRANT, DROP,...
February 23, 2007 at 8:34 am
Tom's note reminded me... The apply of HF 2187 to the active node will only update cluster-aware components on the other node(s).
At the very least, Management Studio will not have...
February 22, 2007 at 9:14 am
Our standard is to apply HF 2187 to every SQL instance.
February 22, 2007 at 2:37 am
Viewing 15 posts - 2,131 through 2,145 (of 2,496 total)