Interested to Buy Any Domain ? << Click Here >> for more details...
-
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)
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
1928How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
1 3216What are the differences between a sys and system user and what are the extra privileges available to the sys user?
1 5823what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
2622Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
2 7868How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
1 4026When 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(
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
1 5372How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
2 5584Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
TCS,
5 8954
Is mysql better than oracle?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How to improve query performance using index hunting?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
what is data manipulation language? : Sql dba
What does Master database contains?
How to do login in mysql with unix shell.
What does mvcc mean?
Comment,Datatypes are unlimited
what does it mean to have quoted_identifier on? : Sql dba
What is enhanced database mirroring in sql server 2008?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is the Control Flow in SSIS
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
Who is the founder of database?
