Viewing 15 posts - 211 through 225 (of 485 total)
Do it in Enterprise manager and generate the script.
Basically you have to rename the table. recreate the table in the new filegroup and then copy the data.
Simon Sabin
Co-author of SQL...
November 15, 2002 at 4:49 pm
in 6.5 I think you can do it in code but not through EM.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 15, 2002 at 4:47 pm
Follow up article http://theregister.co.uk/content/28/28109.html
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 15, 2002 at 6:19 am
You have to create each new thread, calls by default aren't asynchronous. I do not now the specifics but thats the basics.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 14, 2002 at 11:17 am
This is direct from BOL
Specifies some text to search for in column. Variables cannot be used for the search condition.
looks like a contradiction in BOL
Simon Sabin
Co-author of SQL Server 2000...
November 14, 2002 at 11:16 am
This is a common misknowmer that table variables are in-memory structures. The data is actually written to disk. The benefit is that the scope and locking involved in using them....
November 14, 2002 at 5:45 am
You can use this SP
DROP PROCEDURE dbo.sp_ServerStatus
go
CREATE PROCEDURE dbo.sp_ServerStatus
/*******************************************************************************
Written By : Simon Sabin
Date : 14 November 2002
...
November 14, 2002 at 5:12 am
It would be great if you could categorise stored procedures into folders. So that in EM you have Stored Procedures Then a System folder and a User folder and you...
November 14, 2002 at 3:57 am
Ensure each FK has an index on it.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 14, 2002 at 3:06 am
If its not too large can you post it
Do you have diferent collations, sort orders on the servers this might affect things. Do the servers have the same memory, processor?
Simon...
November 14, 2002 at 2:49 am
Having mulitple files in a filegroup does not provide any redundancy. It allows the query engine to issue i/o request on each file in a query. Therefore the more files...
November 14, 2002 at 2:47 am
Put them on a raid drive. No other way I know of protecting them
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 14, 2002 at 2:46 am
Put them on a raid drive. No other way I know of protecting them
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 14, 2002 at 2:46 am
Yes, if you want to be able to use your existing master whether from the original files or from backup the directory structures must be the same.
Simon Sabin
Co-author of SQL...
November 14, 2002 at 2:41 am
Just caught onto this
The error [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
Is because the DTC service on the remote...
November 13, 2002 at 4:37 pm
Viewing 15 posts - 211 through 225 (of 485 total)