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?
747how 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?
1394We 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?
1145
How you can find out if an index is useful to the optimizer?
What is the use of partition by in sql server?
Define magic tables in sql server?
Can you get second highest salary from the table?
What is the difference between dbcc indexdefrag and dbcc reindex?
What extended events?
whats the maximum size of view state??
Is it possible to have clustered index on separate drive from original table location?
Write a sql query to display the current date?
If a table does not have a unique index, can a cursor be opened on it?
How to find the version of sql server? : sql server database administration
What is a constant or literal in ms sql server?
What is the importance of three tier architecture?
Do you know what are the differences between lost updates and uncommitted dependencies?
How you can get the list of largest tables in a database?
