Create a table and put it in a file

When I create a table I can create it in a filegroup, but how do I put it in a file. Example

I have two files in one filegroup called "Secondary" file A and file B.

I want to create a new table called tableA and put it in file B on filegroup Secondary.

I looked at bookes online and can't find it.

Thanks

Thomas

Hi,

It's part of the CREATE TABLE syntax.

CREATE TABLE myTable
(myID int)
ON [Secondary]

You cannot control on which file you create it because different files in a filegroup is exactly for spreading the table over multiple files.

Kind regards

create a database with 2 or more files on same drive ?

Does it help if you create a database with 2 or more data files on the same
drive ? Or is it better just to create one especially since its just one
drive ?
Hi Hassan,
If it is a single Drive, you could create a single database file.
If you have multiple disk controller then plan for creating multiple data
files one each in each controller. But if your disk I/O is less then you
could create
the file in the sigle drive.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>
|||If you can put them on separate drives you might get better performance.
Better yet, if you can separate the .LDF (log) files from the .MDF (data)
physically (separate drives) you'll see an improvement. Spreading the same
database around in separate files on the same drive won't particularly help
performance. I've seen people create separate filegroups on a single drive
in anticipation of moving them to separate drives down the road, however.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
> same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>

create a database with 2 or more files on same drive ?

Does it help if you create a database with 2 or more data files on the same
drive ? Or is it better just to create one especially since its just one
drive ?Hi Hassan,
If it is a single Drive, you could create a single database file.
If you have multiple disk controller then plan for creating multiple data
files one each in each controller. But if your disk I/O is less then you
could create
the file in the sigle drive.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>|||If you can put them on separate drives you might get better performance.
Better yet, if you can separate the .LDF (log) files from the .MDF (data)
physically (separate drives) you'll see an improvement. Spreading the same
database around in separate files on the same drive won't particularly help
performance. I've seen people create separate filegroups on a single drive
in anticipation of moving them to separate drives down the road, however.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
> same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>

create a database with 2 or more files on same drive ?

Does it help if you create a database with 2 or more data files on the same
drive ? Or is it better just to create one especially since its just one
drive ?Hi Hassan,
If it is a single Drive, you could create a single database file.
If you have multiple disk controller then plan for creating multiple data
files one each in each controller. But if your disk I/O is less then you
could create
the file in the sigle drive.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>|||If you can put them on separate drives you might get better performance.
Better yet, if you can separate the .LDF (log) files from the .MDF (data)
physically (separate drives) you'll see an improvement. Spreading the same
database around in separate files on the same drive won't particularly help
performance. I've seen people create separate filegroups on a single drive
in anticipation of moving them to separate drives down the road, however.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
> same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>sql

CR 8.5 to CR 10 in Visual C++

Hello,

I have an application in Visual C++ working with CR 8.5. To do it, I'm using crpe.h, cpre32m.lib,... but in CR10 these files don't exist.
In CR 10, the print engine is replaced by RDC.
My question is , can I use RDC without use managed code? All samples on Crystal work with managed code but I can't use in my application !!!!
How can I link my application to the new print engine?

Thanks a lot for your helpDid you ever find the answer to this question?? I have the same issue.|||See if you find solution here
http://support.businessobjects.com/|||how do i refresh crystal report data through codes|||CR.Refresh

where CR is the Crystal Reports component

Countries & Cities Tables

I need to have tables of world countries and cities to use in a user registration form, I searched the Internet for scripts,xml,excel files for countries & cities lists but I couldn't find. Can anybody tell me where to get them from?

Hello my friend,

Let me introduce you to a website I used to worked on that has plenty of this information: -

http://www.wshtravel.com/travel_guides

Kind regards

Scotty

|||

Thanks but the link is not working

|||

I think that if you will try to do something like this on your page it will be very slow and very big, so maybe just use countries. You can try to get countries fromwww.usps.com just try to send pckage to international destination and you will get drop down list with countries to which USPS delivers packages. You can also trywww.UPS.com maybe they have also cites?

Thanks

JPazgier