January 29, 2011 at 3:55 pm
Creating a table in a single file
January 29, 2011 at 4:27 pm
January 29, 2011 at 4:44 pm
prassu.ibm (1/29/2011)
Creating a table in a single file
define "file"...
...is it the file where you store your ddl script?
...is it file as in filegroup?
...etc, etc, etc...
...what is it?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 29, 2011 at 10:50 pm
My question is how to create a table in a single file
January 30, 2011 at 12:33 am
the solution is easy, just make sure you're not overloading your db with to much files.
Create a filegroup and add a file to it.
Then create the table specifying that filegroup as target.
What are you going to do with the tables indexes ?
Keep in mind a clustered actually holds the data pages, so pay attention you specify the filegroup when creating the clustering index.
What's your goal for putting the table in a single file ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 30, 2011 at 12:48 am
prassu.ibm (1/29/2011)
My question is how to create a table in a single file
Two questions:
1) Why do you think it isn't?
2) We are discussing Microsoft SQL Server as your RDBMS here, right?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply