January 3, 2015 at 9:46 am
a
January 3, 2015 at 10:05 am
??
Not sure what you are looking for with so little information.
January 3, 2015 at 10:17 am
shashianireddy (1/3/2015)
how to create master tableplz give one example ...
I agree with Lynn. There's just not enough information here. What is this "master table" supposed to do or contain?
--Jeff Moden
January 4, 2015 at 3:59 am
Wild guess...
Do you mean a table that will be automatically created in each database? Then create it first in the model database on your system.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
January 4, 2015 at 6:42 am
I'm suspecting a student, and thinking he either means:
1) How do you design/create the central production data table of a VERY small database (possibly a one-table db ie Student_Name/Class_Name/Address/phone_number)? ;
or
2) How do I create tables within the Master DB?
Answers:
1) Read up on database design;
2) Don't. Why? Read Answer 1). 🙂
January 4, 2015 at 10:58 am
shashianireddy (1/3/2015)
a
Deleting an original post is a real quick way to lose friends. 😉
--Jeff Moden
January 5, 2015 at 4:41 pm
I think you guys have all been punked.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 5, 2015 at 6:11 pm
KenpoDBA (1/5/2015)
I think you guys have all been punked.
Oh noes. Not again.
Ha!
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
January 6, 2015 at 12:38 am
KenpoDBA (1/5/2015)
I think you guys have all been punked.
Heh... ok then. Small change...
Punking us is a real quick way to lose friends. 😀
--Jeff Moden
January 6, 2015 at 9:01 am
KenpoDBA (1/5/2015)
I think you guys have all been punked.
Wow, look at that picture from sooo long ago.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 6, 2015 at 9:01 am
shashianireddy (1/3/2015)
a
b
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 6, 2015 at 9:35 am
SQLRNNR (1/6/2015)
KenpoDBA (1/5/2015)
I think you guys have all been punked.Wow, look at that picture from sooo long ago.
Yeah, he was almost pretty once. Almost.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply