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?
780how 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?
1420We 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?
1176
why would you use sql agent? : Sql server database administration
What are the restraints imposed on the table design by a merge replication?
What are the steps you must follow to hide sql server instances?
Explain what are the different index configurations a table can have?
How to change the name of a database user?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are the different types of lock modes in sql server 2000?
What is a rownum?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What are the advantages of stored procedure in sql server?
Difference between Inner vs outer joins?
How many full-text indexes can a table have?
What are extended events in sql server?
What is query cost in sql server?
How to get the number of affected rows?
