Interested to Buy Any Domain ? << Click Here >> for more details...
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
915how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
1574We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
1326
What is clustered vs nonclustered index?
Can a cursor be updated? If yes, how you can protect which columns are updated?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What are the commands used in DCL?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is the sql profiler?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Differentiate between truncate vs delete in mssql?
What are the steps you will take to improve the performance of a poor performing query?
What’s the distinction between dropping a info and taking a info offline?
What is buffer cash in sql server?
What is the use of toad or sqldbx.?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is the difference between index seek vs. Index scan?
