Answer Posted / inampudi anil chowdary
the above two answers are wrong....... the max size of tem
db by default is -1. the main usage of tempdb is.if u run
a query the data will store in tempdb from tempdb we can
get output..but max size is -1;
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is snapshot replication?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Explain multiserver query
How is table type constraint applied to a table?
What is executereader?
What do you mean by data manipulation language?
What is 1nf 2nf?
How to write character string constants or literals in ms sql server?
What is SQL Azure?
Write a query for primary key constraint with identity key word?
How to generate create view script on an existing view?
What is Federation Root Database?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is precedence constraint?