how to find nth highest salary103 129967
About types of indexes in SQL server ?2 5331
Difference between writing SQL query and stored procedure ?15 64583
About DTS usage ?2 5575
Rate yourself in .NET and SQL ?1 6120
how to retrive only second row from table in sql server 2000?15 17315
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?1080
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)10 12190
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 8365
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 5258
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 2275
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 3591
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 5850
What are the parameters of project system?
Is adsense free to use?
What are the defects in exhaust valve?
When purchasing a stock what charges are payable?
How to run custom mysql query in magento?
How will you convince a prospect who has knowledge of a better product than what you have to offer?
What is the transaction for recording bdc ? : abap bdc
What are the dimensions of the risks?
What is an abstract class c#?
How camel handles multiple parameter binding in bean method?
Suppose you have created a menu and a page and given user access to that page, which of the tables gets affected on this?
How many messages are sent across the network for processing topic messages? : BEA Weblogic
If I have more than one version of one assemblies, then how will I use old version (how/where to specify version number?) In my application?
What is a pseudo selector?
In a network that contains two servers and twenty workstations, where is the best place to install an anti-virus program?