What are the different ways you can create databases in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What command is used to create a database in the sql server and how?
What is sql collation?
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 is normalization and its types?
What are cursors and when they are useful?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How is table type constraint applied to a table?
What is data source document?
What is the usage of sign function?
Can we drop user if user mapped to any logins
does physical index sort data
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
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)