SQL Server Archives - Page 39 of 393 - SQL Authority with Pinal Dave

SQL SERVER – The Basics of the Execute Package Task – Notes from the Field #067

February 12, 2015

Notes from the Field, SQL Backup and Restore, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. In this episode of the Notes from the…

SQL SERVER – Script to Find Leap Year

February 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

A leap year has 366 days. A leap year has 29 days for February month. Suppose you want to find if year is Leap year or not, you can use many methods. But this is one of the simplest methods. In our example I have passed the year 2000 as…

SQL SERVER – Error: Fix for Error Msg 3906 – Failed to update database because the database is read-only

February 10, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some error messages are a great source of troubleshooting when things go wrong. I always request my blog readers to read what the error messages are conveying. Most of the solutions are very much documented as part of the message. I must agree that over the years the error messages…

Interview Question of the Week #006 – Is Shrinking Database Good or Bad?

February 8, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Shrinking Database

Here is the most debated Interview Question – Is Shrinking Database Good or Bad? I will try to answer this in a single statement – “Shrinking Database is bad practice for performance as it increases fragmentation. It should be used in rare cases of running out of space on drive.” I believe above…

SQL SERVER – What are the Different Ways to Script Procedure with T-SQL

February 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Ever wondered how a simple task can be done multiple ways. You can script a stored procedure in many ways. You can use SSMS tool and use Generate Script option. However, if you want to do it in T-SQL, there are four ways. Let us create this simple procedure CREATE…

SQL SERVER – How to fix the SQL Server Error 8657 or 8658?

February 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

It is sometimes very difficult to troubleshoot error which are relating to memory. In a recent query from one of my customer DBA, he sent me an error message which read like the ones below: Error: 8657, Severity: 17, Could not get the memory grant of %I64d KB because it…

SQL SERVER – Script – When/Who did Auto Grow for the Database?

February 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

What happens when you try to copy a large file from different hard disks? The operating system tries to see if the destination location has enough space available for the copy to be successful. If we don’t have enough space, then it is second to human nature to make space…