Viewing 15 posts - 406 through 420 (of 447 total)
The most easiest way to generate script of user objects in SQL Server I think is just to select the objects and right click -> copy and paste it into...
SQL DBA.
February 22, 2008 at 1:53 pm
Shark Energy (2/13/2008)
Ok folks nothing to see here. Move along....(I'm a fool)
Basically I misread the sizes. I'm a fool! Ignore me and this. I'm not normally an idiot.
It happens sometimes....
SQL DBA.
February 13, 2008 at 3:00 pm
Dana Bibeault (2/13/2008)
So you are suggesting that we create 4x200GB files in the SAN LUN that the systems group created. How about 2x400GB?The LUN is 800GB.
Depends. In first...
SQL DBA.
February 13, 2008 at 12:37 pm
Ramon Jimenez (2/13/2008)
You can always leave database with SQL Server 2000 compatibility level
I tried this and had lot of problems in full text search indexes when SQL server 2000 database...
SQL DBA.
February 13, 2008 at 12:32 pm
My best and safest bet would be to backup 2000 database and restore it on 2005 and change the compatibility mode, transfer logins using script given in this link, map...
SQL DBA.
February 13, 2008 at 12:31 pm
Rule of thumb, never include datafile folder to virus scanning. Exclude data files and transaction log file folder from the scan and see if you get the same error.
SQL DBA.
February 13, 2008 at 12:22 pm
400 GB definitely is a big size. We have 3 x 150 GB files but have no issues with it and forth we created last week. Having multiple files...
SQL DBA.
February 13, 2008 at 12:20 pm
make him the member of targetserversrole in msdb database. Check more for targetserversrole in BOL.
SQL DBA.
February 8, 2008 at 1:16 pm
Depends. As a SQL guy, I will recommend SQL Server 2005 Std. edition as you are asking for free or one license.
I had a database which has transaction volume...
SQL DBA.
February 8, 2008 at 1:13 pm
Yes and no. DBCC DBREINDEX does update statistics when executed, but it executes sp_updatestats and updates a sample of statistics on table/index.
But to get the best result for performance...
SQL DBA.
February 8, 2008 at 1:06 pm
No, it won't. SQL Server stores index information of each table separately.
SQL DBA.
February 8, 2008 at 1:02 pm
sp_attach_single_file_db @dbname= 'dbname' ,@physname= 'physical_name'
but, make sure database got only one .mdf file or say datafile. This command doesnot work with multiple data files.
SQL DBA.
February 8, 2008 at 1:00 pm
try this.
sp_attach_single_file_db @dbname= 'dbname' ,@physname= 'physical_name'
but, make sure database got only one .mdf file or say datafile. This command doesnot work with multiple data files.
SQL DBA.
February 8, 2008 at 12:56 pm
Most of my servers have these services running on the same server without any issue. Database, Reporting, and SSIS. We don't have Analysis installed.
SQL DBA.
February 1, 2008 at 1:23 pm
Both instances are working good but we don't have any SSIS packages on both servers, so can't say how integration services would behave.
SQL DBA.
February 1, 2008 at 1:20 pm
Viewing 15 posts - 406 through 420 (of 447 total)