How do I shrink an ldf file?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by acid?
How to optimize stored procedures in sql server?
How can you list all the columns in a database?
What is a non clustered primary key?
What are the disadvantages of primary key and foreign key in SQL?
How can u convert the Date to String?
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
How to get a list of columns in a view using "sys.columns" in ms sql server?
Why should you use or avoid select * statements?
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is the benefit of normalization?
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)