November 21, 2011 at 5:47 am
Dear all
i have some doubts in sql server
plz try to give the ideas or answers
1.How many tables a database have?
2.. How many colums a database have?
3. Can we physically create check point?
4.What are the causes of agent failures? Where you look for errors if your agent fails?
Thanks 2 all
satvinder singh
November 21, 2011 at 5:49 am
Sounds like an interview question.
Why do you need to know this and why couldn't you find the answers in google?
November 21, 2011 at 6:16 am
Have you tried searching on google?
There's no way you can't find the answers there...
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
November 21, 2011 at 11:15 am
1 & 2 are in the Books Online.
3. Yes. For more details see the Books Online.
4. There is an error log associated with the Agent. You can get errors there that are applicable only to the Agent. Again, you can get more details in the Books Online. Common problems... No such thing. An agent job can be anything. Define what you mean better.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 26, 2011 at 12:54 pm
Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?) Therefore, I'll try to answer here.
1.
The number of tables specifically is not limited, but there is a limit on Database Objects.
Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647.
2.
1024
3.
Yes, this is done by issuing CHECKPOINT command
4.
SQL Server Agent errors are in the error log located under SQL Server Agent --> Error Logs
November 27, 2011 at 3:09 am
Oksana March (11/26/2011)
Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?) Therefore, I'll try to answer here....
There are three main reasons I point to google or BOL if the answer can easily be found there:
1) I don't consider this forum as a "spoon-feeder" to save just a minute or two for doing a basic google search. Especially if the question(s) indicate either a homework or an interview situation.
2) A person dealing with SQL Server should know how to use BOL and google (if needed). The sooner in the training process, the better. Those two sources are usually immediately available, whereas an answer in a forum may take a while.
3) The person asking the question usually is "rewarded" for the answer in one way or the other (a grade for the homework, a job offer as a result of the interview, or even the monthly pay if already employed). From my point of view, each "reward" should be based on some personal effort related to the subject, whereas "effort" is more than copy the original question into a forum...
Edit: the situation is different when the question is something like "I found the following answer using google but I don't understand a specific part of it: < the more detailed question >".
November 27, 2011 at 5:29 am
Oksana March (11/26/2011)
Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?) Therefore, I'll try to answer here.1.
The number of tables specifically is not limited, but there is a limit on Database Objects.
Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647.
2.
1024
3.
Yes, this is done by issuing CHECKPOINT command
4.
SQL Server Agent errors are in the error log located under SQL Server Agent --> Error Logs
When someone is asking fundamental questions that are clearly and easily found in Books Online, I'd say that they don't that is an option and therefore getting that piece of information is a good thing. I could be wrong, but I think of it as teaching someone to fish versus handing them a fish.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 27, 2011 at 11:11 pm
satvinder.atwal (11/21/2011)
3. Can we physically create check point?
No. Checkpoint is an action. It happens. Checkpoint is not an object.
You can manully initate it.
But you cannot "physically create" it.
November 28, 2011 at 7:00 am
Lutz great reply.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 28, 2011 at 7:30 am
Oksana March (11/26/2011)
Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?)
Lutzm +1
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply