After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
898How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 11386write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car
12 7376Syntax 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 4817How 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 2042When 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 3315Suppose 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 5478Post New Cognizant SQL Server Interview Questions
how to upgrade the weblogic server licence?
Differnce between negative Pahse SequenceFunction and unbalance Function?
residential buildings,mixing of concrete,structural,construction material,site handling.
Terminate Activity
How to stop the evergreen renewal contracts types?
What are the questions we need while we go company for analysis to implementation SAP? What we need to know generally? How can we define we need abab for improvement?
What part of BPO do you like and dislike?
Give an account on Reliable cytotoxicity experiments ?
it is possible to measurement of tension of slipring induction motor(SRIM)carbon brushes, any maesuring instruments are available in the markets.
what is recruitment,objective,function,process,duties,kinds etc
Difference between PP and PI.
How you give clearance to a spare feeder.
IP based EPABX system
Write a function which accepts a sentence as input parameter.Each word in that sentence is to be reversed. Space should be there between each words.Return the sentence with reversed words to main function and produce the required output. for eg:- i/p: jack jill jung kill o/p: kcaj llij gnuj llik
Hi I have done my bachelors in mechatronics engineering and PG diploma in industrial automation having 2 years of experience as electrical & instrumentation engineer in a ltd company I need to know for what all technical certification can I go for
- C (3)
- OOPS (2)
- C++ General (1)
- PHP (1)
- Programming Languages AllOther (3)
- JavaScript (1)
- VB Script (1)
- JSP (2)
- AJAX (1)
- Networking Administration (1)
- Networking AllOther (2)
- Visual Basic (1)
- C Sharp (3)
- ASP.NET (13)
- ADO.NET (1)
- IIS (1)
- Crystal Reports (1)
- BizTalk (1)
- Dot Net Framework (1)
- Exchange Server (1)
- Oracle General (10)
- Database Management (1)
- Forms Reports (1) SQL Server (16)
- MySQL (2)
- Sybase (1)
- DB Architecture (1)
- DB Administration (2)
- SQL PLSQL (5)
- Windows General (2)
- Unix Commands (1)
- Solaris General (1)
- Solaris AllOther (1)
- Data Structures (1)
- WinRunner (1)
- Load Runner (5)
- QTP (7)
- Test Director (3)
- Selenium (2)
- Automation Testing AllOther (1)
- Manual Testing (21)
- QA Concepts (1)
- Test Cases (6)
- Testing AllOther (2)
- COBOL (3)
- JCL (11)
- DB2 (3)
- ADABAS (1)
- VSAM (2)
- IBM MainFrame AllOther (1)
- DB400 (2)
- IBM AS400 AllOther (3)
- Core Java (16)
- Advanced Java (2)
- Servlets (3)
- JDBC (1)
- J2EE (1)
- Java Related AllOther (1)
- MQSeries (1)
- XML XSLT RSS (1)
- SOAP (3)
- Teradata (4)
- Business Objects (5)
- Cognos (7)
- Informatica (34)
- Crystal Enterprise Suite (1)
- Ab Initio (3)
- Data Stage (4)
- SAS (10)
- Micro Strategy (1)
- ETL (3)
- HR Questions (7)
- OOAD (1)
- Project Management (1)
- SAP Basis (1)
- SAP ABAP (9)
- SAP SD (7)
- SAP MM (2)
- SAP PP (20)
- SAP FI CO (17)
- SAP CRM (1)
- SAP Business Warehouse (4)
- SAP Security (2)
- PeopleSoft Administration (1)
- CRM General (1)
- Siebel (1)
- Oracle Apps Financial (10)
- Client Server General (1)
- WebMethods (1)
- JCAPS (1)
- EAI AllOther (2)
- Enhancement Design & Development (1)
- Program Management (1)
- Pharmacy (1)
- Civil Engineering (1)
- Electrical Engineering (9)
- Electronics Communications (3)
- Bio Engineering (1)
- Engineering AllOther (2)
- Banking Finance (1)
- Human Resources (1)
- Infrastructure Management (1)
- Audit (3)
- CompanyAffairs CS (3)
- Taxation (1)
- Accounting General (8)
- Accounting AllOther (15)
- Call Centre AllOther (64)
- BSRB Clerical (2)
- Group II History (1)
- General Knowledge_Current Affairs (3)
- Tourism Hotel AllOther (1)
- Funny Interview Questions (1)
- Everything Else AllOther (2)
- English (1)
- General Aptitude (18)
- Puzzles (1)
- Placement Papers (3)
- CISA Certification (1)
- Oracle Certifications (2)
- Certifications AllOther (1)
- H1B Visa (1)
- C Code (2)
- C++ Code (1)
- J2EE Code (1)
- C Sharp Code (1)
- IIT JEE (1)
- MySQL Errors (1)
