Viewing 15 posts - 76 through 90 (of 198 total)
You would install SQL under local admin account. After the setup is finished, go in Configuration Manager, SQL Server 2005 Services, right click on sql server name -> here change...
August 23, 2007 at 5:53 am
This website provides a clean info on a datawarehouse design, just do a search using ODS as keyword;
As an example: http://www.sqlservercentral.com/columnists/vRainardi/2657.asp
I would highly recommend surrogate keys on ODS, and...
August 23, 2007 at 5:47 am
SQL Server 2005 -> Configuration tools -> SQL Server Configuration Manager -> SQL Server 2005 Services -> right click over the service you want to stop
August 23, 2007 at 5:37 am
Server name is your machine name; instance name is the same with server name when sql server is installed as a default instance and has got "computer_name\instance_name" name when sql has been...
August 22, 2007 at 11:48 pm
Read here about the security best practices for sql server services
http://www.microsoft.com/technet/prodtechnol/sql/2005/sql2005secbestpract.mspx
August 22, 2007 at 11:04 pm
As it's not clear what "pull all records out of a database" means, I can assume that you will need to run a select query and get the results in...
August 22, 2007 at 5:18 pm
The installation would take between 25-40 min, depending on your machine hardware; then you would need to patch it. If you calcelled a previous installation then you might have problems...
August 22, 2007 at 5:13 pm
You need to run the sql dev setup and install client tools only; if you would want to install the sql dev db engine as well then you have to...
August 22, 2007 at 5:09 pm
All system databases must be on a shared disk; tempdb is the most important after master and you would need to carefully set the storage for it.
August 21, 2007 at 4:08 am
Just ignore the above for now; If your view is not defined "with schema_binding" option and any table behind that view has been altered then you can run out of memory...
August 21, 2007 at 4:03 am
Do you try to impersonate a login? Is your db upgraded from sql2k?
August 21, 2007 at 3:55 am
As you're on sql2k5, you can disable and then enable the constraints:
-- Disable all table constraints
ALTER
TABLE yourTable NOCHECK...
August 19, 2007 at 11:33 pm
http://support.microsoft.com/default.aspx/kb/834846
The ppt above is very usefull to understand, based on your app transactions behaviour, whether or not your tempdb would need as many datafiles into the default filegroup as...
August 19, 2007 at 10:58 pm
I would say to check whether your db is in full recovery mode; if it is then take a tran log backup then shrink it / or shrink the index...
August 15, 2007 at 1:33 am
Viewing 15 posts - 76 through 90 (of 198 total)