SQL Scripts Archives - Page 262 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Delete Backup History – Cleanup Backup History

November 11, 2008

Best Practices, Database, SQL Backup and Restore, SQL Scripts, SQL Stored Procedure

SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to…

SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB

November 10, 2008

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Scripts, SQL Server, SQL Server DBCC

Today we will see quick script which will check integrity of all the databases of SQL Server. We will learn about DBCC CHECKDB in this blog post.

SQL SERVER – Refresh Database Using T-SQL

November 7, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server DBCC, SQL Stored Procedure

Yesterday I received following questions on blog. Ashish Agarwal asked following question. Hi Pinal, Can we refresh a database (like we do by right clicking database node in object explorer and clicking on refresh) thru SQL Query? If yes, can you please tell me the query? Thanks, Ashish Agarwal Answer…

SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio

November 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, SQL Scripts, Vista

Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer does not have access to it. It is very easy to clean the list and start over.…

SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user

November 4, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

I have received following question nearly 10 times in last week though emails. Many users have received following error while connecting to the database. This error happens when database is dropped for which is default for some of the database user. When user try to login and their default database…

SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan

November 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

Stored Procedures are very important and most of the business logic of my applications are always coded in Stored Procedures. Sometime it is necessary to hide the business logic from end user due to security reasons or any other reason. Keyword WITH ENCRYPTION is used to encrypt the text of…

SQL SERVER – DECLARE Multiple Variables in One Statement

October 31, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts

Just a day ago, while I was enjoying mini vacation during festival of Diwali I met one of the .NET developer who is big fan of Oracle. While discussing he suggested that he wished SQL Server should have feature where multiple variable can be declared in one statement. I requested…