how to find nth highest salary103 123453
About types of indexes in SQL server ?2 4972
Difference between writing SQL query and stored procedure ?15 61833
About DTS usage ?2 5099
Rate yourself in .NET and SQL ?1 5570
how to retrive only second row from table in sql server 2000?15 16046
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?872
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)10 11276
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 7273
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 4763
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 1996
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 3277
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 5401
how to convert analog RC filter to FIR filter
what is cost unit n what is cost sheet?
Basic motor transformer generator
what do .sbl and .sbh represent?
iam preparing for rrb section engineer post in electrical branch.suggest the right textbook for my reference.fromwhere i will get the previous q.papers?
I use 20 nos led tube 4feet, in pathway 100mtr approximate, so what size cable i use for lighting
IIS Migration ?
What is a good test? Wy do we need testing write test steps for triangle write test steps for ATM How a tester should approach a devloper about non accepted defect? What is test coverage assurance and give an example Draw and expain V model and how it is helpfull in software development
Basic principle of ESI?
What causes crankcase explosion?
Hi All, Can any one please send me the difference between informatica 7i and 8i versions, Thanks in advance. vinod
what is the importance of Phytochrome pigment?
query optmization techniques and quwry analyser+projects+ppts
do you have some of interview Questions in power and genrator section in general whith answers
Define and distinguish between flexible and floating exchange rate system. What kind of exchange rate system does china have?