After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
1621How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 15553write 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 12528Syntax 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 6605How 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 3239When 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 4602Suppose 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 7245Post New Cognizant SQL Server Interview Questions
What is the need for dmac in es?
How do I find and replace all codes in visual studio?
What are the contents of hibernate configuration file ( hibernate.cfg.xml )?
What are the different types of embedded data flow?
distribution is maximum done by a)radial b)network c) parallel d)b & c
What is the order of call of constructors in inheritiance?
Which are the companies that you would love to join other than accenture?
bba date of interview in imsciences
What is angular 7? How is it different from angularjs?
A company purchase goods Rs.2000/- & input vat received rs.100/- but at the time he sold goods 1000/- as a sales & 1000/- as a sock transfer. plz tell me how much take input claim in this case.
How polymorphism works on actionscript?
in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application
What are transients wordpress?
What is the current latest version of tableau desktop(as of sep, 25th 2017)?
Hi Friend, I am sap SD consultant & want to learn SAP SD CIN part. there are four Pricing Procedure in SAP SDJINFAC: SALES FROM FACTORYJINEXP: EXPORT SALESJINDEP: DEPOT SALEJINSTK: STOCK TRANSFER But i want to know how to configure Table /Access Sequence /Condition / Pricing procedure/Determination of Pricing proceudre/ Condition record Plz help me with the configuration path of all 4 pricing proceudre of SAP SD CIN