What is the difference between drop table and truncate table?
No Answer is Posted For this Question
Be the First to Post Answer
What is the sql server agent?
How to perform backup for certificates in sql server? : sql server security
Can a table be moved to different filegroup?
What sql server means?
How to copy the tables, schema and views from one sql server to another?
How to Update from select query in sql server?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
select names starts with a,b,c
8 Answers Scope International,
Define a cross join?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is db stored procedure?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Oracle (3253)
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)