Explain what is use of dbcc commands?
No Answer is Posted For this Question
Be the First to Post Answer
How to disconnect from a sql server using mssql_close()?
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
What are the aggregate and scalar functions?
How network traffic be reduced by using the stored procedure?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is compression - row-level and page-level compression?
Can a table be created inside a trigger?
How to make a column nullable?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is set nocount on and what is set nocount off?
What are joins in sql and what are the different types of joins?
Write a SQL queries on Self Join and Inner Join.
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)