Answer Posted / samrat sen
Actual size is 8196 bytes.But Sql Server allows only 8060
bytes of data per row.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
In which tcp/ip port does sql server run? Can it be changed?
What is importing utility?
Which Model uses the SET concept
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is the dbcc command and why is it used?
Explain the difference between control flow and data flow?
What is database replication? What are the different types of replication you can set up in sql server?
List all the types of user-defined functions?
What are the advantages of the mirroring?
What are xml indexes?
Can we use pragma autonomous_transaction in trigger?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Difference between Sql server reporting services and Crystal reports?
Can a function call a stored procedure in sql server?