how to find nth highest salary103 127219
About types of indexes in SQL server ?2 5222
Difference between writing SQL query and stored procedure ?15 63669
About DTS usage ?2 5406
Rate yourself in .NET and SQL ?1 5954
how to retrive only second row from table in sql server 2000?15 16852
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?1010
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)10 11785
write 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 car12 7895
Syntax 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 5077
How 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 2184
When 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...
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 3497
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 5742
what is interlock system and why we use of this?
How do I reconnect a project after the shared workspace file loses the project location?
What is EDI?difference between EDI & ALE IDOC?
Hi, My name is Dinesh.I want to prepare for ISTQB certification , So can anyone please email me the syllabus of it and what is criteria for giving exam.Please email me answers at: email@example.com
how to pass interest on security entries and salary payable entries in tally and how to maintain e-commerce company account please revert me ASAP its needful for me
what is power prompt in cognos ep7series?what is the use of this?
what is the fuction of asstt. rigman drilling
how can i get old question papers and solved problems of vtu university karnataka...... if u know plz do reply
Explain how the rings on a tree trunk can tell you the age of the tree and What is that branch of botany called?
what is the venturi effect in buildings? what is green house concept?different types of dams? which dam is economical arch dam or gravity dam. what are the conditions favourible to both of them?
What do you know about E- commerce?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
what are the various off the job training methods?
What is a prompt box?
Q1.what will be career path as a HR in the particular company?