virtual database - A Unique Tool for Testers, DBA, Developers(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

It is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database backup was 40 GB in size, and, to restore it on our production server, it usually takes around 16 to 22 minutes, depending on the load server that is usually present. This range in time varies from one server to another as per the configuration of the computer. Some other issues we used to have are the following: 1. When we try to restore a large 40-GB database, we needed at least that much space on our production server. 2. Once in a while, we even had to make changes in the restored database, and use the said changed and restored database for our purpose, making it more time-consuming. read more...

1 comment |category: Database |Views: 330

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – Interview Questions & Answers Needs Your Help(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

Here, I need your help. Please your comments, suggestions, expectation or potential interview Question (along with answer) here. Your input will be very valuable. As time goes by we all learn and get better. There were few things missing at that time when those interview questions and answers were prepared, now is the time to complete the gap and make this interview questions more useful. read more...

2 comments |category: Database |Views: 307

tags: SQLAuthority pinaldave SQLServer Database SQL another

Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DA(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE March 17, 2010 by pinaldave | Edit Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE. The first one is ALTER DATABASE …ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT. read more...

add a comment |category: Database |Views: 118

tags: SQLAuthority pinaldave SQLServer Database SQL another

Force Index Scan on Table – Use No Index to Retrieve the Data – Query(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can I convert seek to scan? read more...

add a comment |category: Database |Views: 122

tags: SQLAuthority pinaldave SQLServer Database SQL another

Improve Performance by Reducing IO – Creating Covered Index(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO. read more...

add a comment |category: Database |Views: 327

tags: SQLAuthority pinaldave SQLServer Database SQL another

Rollback TRUNCATE Command in Transaction(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

Interesting Conversation on the subject. Take your side and learn along! read more...

2 comments |category: Database |Views: 241

tags: SQLAuthority pinaldave SQLServer Database SQL another

IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 3 months ago

The most interesting comment conversation is among Divya, Brian and Marko. Please read the comments of Marko for sure. It is the comment, which has triggered this post. What is your opinion and experience about this post? read more...

add a comment |category: Database |Views: 550

tags: SQLAuthority pinaldave hi Database SQL another

Some unknown facts about Update (U) lock(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

Update lock is “Waiting exclusive lock” and is used not only for UPDATE statements but also for DELETE statements. Know more facts in this post. read more...

add a comment |category: Database |Views: 3

tags: Database another

Stored Procedure Optimization Tips – Best Practices(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 3 months ago

Key Points discussed in the articles are : 1. Include SET NOCOUNT ON statement 2. Use schema name with object name 3. Do not use the prefix “sp_” in the stored procedure name 4. Use IF EXISTS (SELECT 1) instead of (SELECT *) 5. Try to avoid using SQL Server cursors whenever possible 6. Keep the Transaction as short as possible 7. Use TRY-Catch for error handling read more...

2 comments |category: Database |Views: 779

tags: SQLAuthority pinaldave SQLServer Database SQL another

SSIS Package Configuration in SQL server 2008 (www.techbubbles.com)

submitted by kalyanms1(1789) 2 years, 3 months ago

SSIS configuration wizard allows you to create configurations for packages. It also allows you to update the properties and objects of the package at run time. Package Configuration Benefits Configuration really helps the developers to smoothly move the packages from Development environment to Production environment. read more...

add a comment |category: Database |Views: 4

tags: Database another

Query Optimization - Interesting Observation of Compute Scalar before (dotnetkicks.com)

submitted by pinaldave(9662) 2 years, 3 months ago

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate February 5, 2010 by pinaldave | Edit I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by the query. Click more for further story. read more...

add a comment |category: Database |Views: 277

tags: SQLAuthority pinaldave SQLServer Database SQL another

In MS SQL Server getting Deadlock details using Traces(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

To get complete deadlock details the easiest and lighted-waighted method is using Traces#. For this purpose SQL Server have Trace # 1204, 1205. The information can be logged in Error log file using trace #3605. read more...

add a comment |category: Database |Views: 17

tags: Database another

Index improve performance by reducing blocking(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

Reduced number of comparison is not the only reason for performance improvement because of indexes. Indexes also reduce the blocking and that reduces that waiting time. read more...

add a comment |category: Database |Views: 7

tags: Database another

Life time or age of a Share Exclusive and Update lock in SQL Server(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

Age of shared lock is decided by the isolation level of session. Age of exclusive locks and update locks is always the length of outermost user defined transaction. There is no impact of isolation levels on the life time of these locks. read more...

add a comment |category: Database |Views: 3

tags: Database another

How to Convert Hex to Decimal - A simple puzzle (blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 3 months ago

How to Convert Hex to Decimal - A simple puzzle? Let us see if you have answer to this simple puzzle. read more...

1 comment |category: Database |Views: 483

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – Find Statistics Update Date – Update Statistics(blog.sqlauthority.com)

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

Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to update the statistics if query is not optimal. Please note that there are many other factors for query to not perform well; expired statistics are one of them for sure. read more...

3 comments |category: Database |Views: 193

tags: SQLAuthority pinaldave SQLServer Database SQL another