Viewing 15 posts - 1,321 through 1,335 (of 2,496 total)
Personally, I would break this down as follows:
1) SQL Server install
2) Transfer any required logins, etc from the old to the new machine via scripts
3) Transfer the user databases from...
June 3, 2009 at 4:35 am
That's not a particularly good idea
Take note of what Gail says. What is the ultimate goal you are trying to achieve?
If your goal is to have the same set...
June 3, 2009 at 2:58 am
i know eat up my free space and they are not in used(orphaned).
How do you know the objects in tempdb are not in use?
If you can prove they...
June 3, 2009 at 2:45 am
If you divide your database into multiple filegroups this will force SQL Server to use multiple I/O streams to access your data.
SQL can use multiple streams on a single table...
June 3, 2009 at 2:37 am
Each time you call xp_cmdshell you create a CMD environment. When xp_cmdshell ends this environment is destroyed. This means that each of your xp_cmdshell statements runs in complete...
June 2, 2009 at 3:47 am
There are a few things to consider.
1) What Windows rights does your SQL Server service account have. Check with BOL for what is needed. I cannot remember for...
June 2, 2009 at 3:42 am
Ther are some specialist forums dealing with Capacity Planning and Capacity Management topics. Google should help you find these.
The main thing you need to focus on at the start...
June 2, 2009 at 3:31 am
Take a look at SQL Server 2008 FineBuild.
The reference manual shows the GUI steps for doing the configuration, and points to the section in the scripts that does...
June 2, 2009 at 3:18 am
What information is given in the SQL Server Errorlog?
June 2, 2009 at 3:16 am
If you are installing on a machine attached to a domain and you cannot use a domain account when you do a SQL Server install, this means either:
a) You do...
June 1, 2009 at 4:52 am
Sp2 can use 64gig of ram
True for SQL Server database engine, because the database engine is AWE-aware. Even then, SQL Server is unlikely to get above 55 GB of...
June 1, 2009 at 2:38 am
regardless of the amount of actual memory that is installed on the computer
The /3GB switch can only be used if the machine has less than 16 GB memory. On...
May 29, 2009 at 3:56 am
The OP is asking how to get 32-bit Analysis Services using more than 2GB memory.
This is not possible. SSAS is not PAE-aware so it cannot make use of this...
May 29, 2009 at 2:36 am
SQL Server FineBuild can help you by providing a totally scripted install. This can be run manualy on multiple servers or deployed using a tool such as Altiris.
The link...
May 29, 2009 at 2:26 am
Have a look in SQL Server Books Online (BOL) in the section 'tempdb databases'. This will tell you more about what tempdb is used for.
After you have read this,...
May 28, 2009 at 3:21 am
Viewing 15 posts - 1,321 through 1,335 (of 2,496 total)