what is the maximum size of sql row in mssql?
Answer / gopi muluka
8060 bytes allowed per a single row in a table
| Is This Answer Correct ? | 27 Yes | 1 No |
What are logical database components? : SQL Server Architecture
What is difference between getdate and sysdatetime in sql server 2008?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Is the log file is a part of file group?
Does any body please help me what question's have asked for SSRS in the interview?
What is the purpose of data source?
explain the storage models of olap? : Sql server database administration
what is lazy writer?
when would you go for denormalization? : Sql server database administration
How do you fine the performance tunning?
What is an execution plan?
How to loop through the result set with @@fetch_status?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)