Anyone good with MSSQL?

[Mo]

I hate this shit, but I'd need to externalize ONE table into a second database (i.e. in a RAM drive).

Now I know both MySQL and Oracle offer this feature, but does MSSQL? And if it's possible, how? I already thought of simply ordering a plug-in (now for only $4.999,-), but I don't really think it's worth it

Thanks a lot.

[severin]

what do you want to do exactly? i mean, working with mssql is my job, but i have no idea what you want to do

you can also call me...

[severin]

it sounds like you want to have a database on a ramdrive where there's one table in it, which has been in another database previously?

if so:

create a database in the sql-manager and put the datafiles onto the ramdrive, then do:

select *
into [new_database]..tablename
from [old_database]..tablename

and voila

[Mo]

Thank fucking god for uncles.

The problem is that we never even touched a second filegroup, since we didn't need it.
But I have the whole three-day weekend to get into that...

Thanks a lot

[ChristHimself!]

netphoria: bringing families together

[severin]

Originally Posted by antipop

Thank fucking god for uncles.

The problem is that we never even touched a second filegroup, since we didn't need it.
But I have the whole three-day weekend to get into that...

Thanks a lot

ok, i've got it figured out. what your table needs is a primary key for this to work, so if it doesn't have, please add one

alter database [dbname] add filegroup ramfilegroup
go

alter database [dbname] add file (name= ramfile, filename='[path on ramdisk]') to filegroup ramfilegroup
go

alter table [tablename] drop constraint [primary key name] with (move to ramfilegroup)
go

alter table [tablename] add constraint [primary key name] PRIMARY KEY([columns of primary key])
go

[Mo]

Dankeschön

[severin]

Originally Posted by antipop

Dankeschön

bitteschön. i'm not quite sure if other indezes on the table are moved as well, so it might be a good idea to drop every constraint and index (apart from the primary key one) before you do those steps above and then re-apply them afterwards to make sure they are on the ramdisk as well

[Mo]

Woo, I did it!


God, I hate MSSQL so much.

[severin]

Originally Posted by antipop

Woo, I did it!

oder wer

and i actually like it, but i deal with it on a daily basis and do stuff with it people seldom need to do. you can be surprisingly creative with mssql

[Mo]

Hehe...

Our Belgian and Mexican customers say 'thanks' - we just halved their workflow time. Pfew.
No off to a long weekend.

[severin]

Originally Posted by antipop

Hehe...

Our Belgian and Mexican customers say 'thanks' - we just halved their workflow time. Pfew.
No off to a long weekend.

i hope you guys thought of the problems with having data on a ramdisk though..like, it being gone whenever you turn off the machine...

[Mo]

Duh...

That's not really a problem since said data is only important for five seconds, after that we don't care where it goes.

[severin]

Originally Posted by antipop

Duh...

That's not really a problem since said data is only important for five seconds, after that we don't care where it goes.

so you go through this hassle for a 5 second gain?

[Mo]

Well, actually it's running quietly in the background now, but... yeah, pretty much. If you are digitizing hundreds of CDs a day every second counts (I suppose).