How to create database with physical files specified in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is cursors?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
Explain the concepts and capabilities of sql server?
What are the differences between substr and charindex in sql server.
what is index seek and index scan?
What is the server name for sql management studio?
Difeerence between ssis 2005 and ssis2008?
Explain external key management in sql server 2008
What are cursors?
How would we use distinct statement? What is its use?
How to store and query spatial data?
What do you understand by triggers?
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)