how to find nth highest salary103 136866
About types of indexes in SQL server ?2 5616
Difference between writing SQL query and stored procedure ?15 66177
About DTS usage ?2 5882
Rate yourself in .NET and SQL ?1 6595
how to retrive only second row from table in sql server 2000?15 18436
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?1216
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)10 12979
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 9297
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 5582
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 2521
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 3832
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 6096
Is coding essential for Blue Prism?
WHAT IS THE DIFFERENE IN ACTION OF MCB,MCCB,RCCB
How to know which medium works best?
Can you enlist some commonly used network commands?
Which is latest technology in java?
Explain how does hydraulic clutches work?
working principle of direct digital controllers(DDC Panel)
what is the implemention project in sap?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
what is meant by 3rd hormonics ?
What are the core interfaces are of hibernate framework?
Can we create dynamic website in wordpress?
When a campaign is showing as pending within adwords, what is it?
How many digits are in an integer?