Give main differences between "Truncate" and "Delete".
No Answer is Posted For this Question
Be the First to Post Answer
Where in ms sql server is ’100’ equal to ‘0’?
What factors you will consider calculating the storage requirement for that view?
What is query optimization process?
What is stored in the mssqlsystemresource database? : sql server database administration
explain the storage models of olap? : Sql server database administration
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are the authentication modes in SQL Server?
In which tcp/ip port does sql server run? Can it be changed?
What is a View ? Can we insert, Update and delete a view?
Some queries related to SQL
What is ddl and dml commands?
How many primary keys are possible in a table?
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)