SQL SERVER - Restore Database Without or With Backup - Everything Abou(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

The questions I received in last two weeks: “I do not have backup, is it possible to restore database to previous state?” “How can restore the database without using backup file?” “I accidentally deleted tables in my database, how can I revert back?” “How to revert the changes, I have only logs but no complete backup?” “How to rollback the database changes, my backup file is corrupted?” Answer: You need complete backup to rollback your changes. If you do not have complete backup you can not revert back. Sorry. To restore the database to previous stage if you have full backup... read more...

add a comment |category: Database |Views: 19

tags: SQL SQLAuthority pinaldave backup Database another

SQL Server Interview Questions and Answers Complete List Download(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

Question I received is do I ask the same questions in interviews which I administrate. Answer is YES. Though, I have few other questions, which I ask. All of them I came up myself and answers are unique to questions and not available on-line. Well, long story short, I have compiled list of questions in one PDF. Please download them and use them in your next interview or just for reading purpose. read more...

add a comment |category: Database |Views: 513

tags: SQL SQLAuthority pinaldave Interview SQLServer another

SQL SERVER - Insert Multiple Records Using One Insert Statement(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

How can I insert multiple values in table using only one insert? Now this is interesting question. When there are multiple records are to be inserted in the table following is the common way using T-SQL. read more...

add a comment |category: Database |Views: 302

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

Following tutorial about BPA is ran on one of my old laptop, which has SQL Server 2005 installed. The SQL Server had many issues and they all are displayed in the result. Please note this is not production server and all the errors are intentionally generated. This tutorial is explained using images, which are very easy to understand. read more...

add a comment |category: Database |Views: 9

tags: SQL SQLAuthority pinaldave Database SQLServer another