You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
990Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
1001How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
1075
What types of replication are supported in sql server?
How many partitions a clustered index has by default in sql server 2012?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is global temp table?
How do I determine how many instances of sql server are installed on a computer?
What are the different authentication modes in sql server?
How to connect Azure federated root database and apply federation in entity framework?
Explain iaas, paas and saas?
What is onf in normalization form?
How to delete duplicate records based on single column from a table?
How to create stored procedures with parameters in ms sql server?
Can group functions be used in the order by clause in ms sql server?
What is difference between index seek vs. Index scan?
How do you run a trace?
How do clustered indexes store data?