Viewing 15 posts - 751 through 765 (of 824 total)
SQL Server can actually use multiple asynchronous I/O requests against a single file too. Now there may be some performance benefit in splitting the files across multiple I/O channels or...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 10, 2004 at 8:19 am
Yes you can run multiple CREATE INDEX statements "at the same time" on Standard Edition, however the mention of parallel index creation refers to a single CREATE statement being able...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 9, 2004 at 3:14 pm
From BOL "CREATE INDEX"
"On multiprocessor computers on SQL Server Enterprise and Developer Editions, CREATE INDEX automatically uses more processors to perform the scan and sort, in the same way as...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 9, 2004 at 1:59 pm
This feature refers to the ability of SQL Server to employ more than one processor in the creation of an index, rather than referring to the number of indexes that...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 9, 2004 at 1:55 pm
I missed the bit about them being in the Primary group. Sorry. About the only thing you can do at this point is to create another database with the files/file...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 9, 2004 at 9:37 am
Use the DBCC SHRINKFILE ('filename', EMPTYFILE) command to remove all data from the file and then use the ALTER DATABASE command to remove the file.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 9, 2004 at 9:19 am
You will need to edit the registry. HKEY_Local_Machine\SOFTWARE\Microsoft\MSSQLServer\Parameters
Change the SQLArg0 to reflect the new path and file name of the master data file.
Change the SQLArg1 to reflect the new path...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 5, 2004 at 9:16 pm
If you are getting a red x for the second step, the step was attempted and errrored out. Did you get any kind of error message when you double click...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 5, 2004 at 9:05 pm
If you are talking about SQL Server 2000 the CAL's are not sold on the basis of concurrent users. They are for either named users or named devices, so you need...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 5, 2004 at 9:01 pm
You might get some improvement if you bump up your network packet size. This will probably only net a pretty incremental gain on large data transfers, but it could also hurt smaller...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 5, 2004 at 8:52 pm
I'm afraid the only place to get that information is from the views themselves. The sysdepends and the INFOMATION_SCHEMA views are limited to a single database's objects.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 5, 2004 at 8:48 pm
I'm not sure what you mean by Linked Steps. You do need to redo any workflow definitions that were in place before you rename the steps, but I've not had...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 5, 2004 at 7:45 pm
Unfortunately the DTS packages, including all the steps are contained in a binary image in sysdtspackages so there is no way of easily retrieving the step descriptions. However, you can change the step...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 5, 2004 at 12:28 pm
That sounds very strange, the only thing I can think of that might cause that is the job definition. Open up the job that runs the transaction log backups and...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 2, 2004 at 8:46 am
By file format I assume you are asking about the file naming convention. By convention, database backup files are named using the ".bak" extension and transaction log backups use ".trn",...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
July 30, 2004 at 5:11 pm
Viewing 15 posts - 751 through 765 (of 824 total)