Viewing 15 posts - 61 through 75 (of 91 total)
We have some servers that are in a cluster like environment (Marathon Endurance Server) but most of them are not. So what I do is I backup to a local...
January 23, 2003 at 3:03 pm
Can some of you clarify something for me. Is this still an issue with SQL 2000. I have come across it many times with SQL 7 but I haven't (yet)...
January 22, 2003 at 4:06 pm
I used to use earlier version of crystal reports about 4 years ago and at the time I swore I would avoid them again at all costs.
I wasn't best pleased...
January 22, 2003 at 3:16 pm
Just right click over a table in Enterprise manager, then choose All Tasks > Export data.
(The same to import... All Tasks > Import data). You choose Text File from the...
January 22, 2003 at 3:04 pm
Strnage when I tried this using the Import wizard on SQL 7.0 (on Wins 98) it worked ok!
Surely you can change things on the 'Column Mappings and Transformations' form 'Transformations'...
January 22, 2003 at 2:56 pm
That sample row of data from the text file would really help. Are you sure that DTS doesn't think there is more then one column in the import end of...
January 22, 2003 at 9:50 am
Thats the problem with everything now 'not enough spare time'.
If only there was a stored proc for that one!
January 22, 2003 at 9:41 am
If the money is available you could do worse then take a look at Marathon Endurance Server. Once setup its just like running SQL on one machine but with assured...
January 22, 2003 at 9:31 am
I assume (dangerous I know) that if rebuilding clustered indexes caused any such problems then you would have heard about it because its such a common practise and I also...
December 16, 2002 at 6:02 am
If you do this and go to the properties of the table in EM it will say the table is on whatever filegrouo you created the new Clustered index. I...
December 16, 2002 at 5:42 am
CREATE UNIQUE CLUSTERED
INDEX [PK_Categories] ON [dbo].[Categories] ([CategoryID])
WITH
DROP_EXISTING
ON [Secondary]
[Secondary] <--- just change this to whatever filegroup
December 16, 2002 at 5:36 am
Surely if you move the CLUSTERED index to a new filegroup then SQL will move the data as well as the clustered index as the leaf level of the clustered...
December 16, 2002 at 5:33 am
If tell SQL to rebuild your clustered index you don't lose your triggers. If you did everytime you rebuilt your index you would have to rebuild your triggers. I have...
December 16, 2002 at 4:34 am
Maybe I am a bit sleepy today or something but if just rebuild the clustered index on your new filegroup why would you need to script user permissions, constraints, etc.....
December 16, 2002 at 3:44 am
Creata cursor that loops through the tables that you want to move.
Inside the loop recreate the clustered index of the table in question on your new filegroup. (The file group...
November 27, 2002 at 11:13 am
Viewing 15 posts - 61 through 75 (of 91 total)