SQL Archives - Page 462 of 519 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Find Unused Indexes of Current Database

February 11, 2008

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

Simple but accurate following script will give you list of all the indexes in the database which are unused. If indexes are not used they should be dropped as Indexes reduces the performance for INSERT/UPDATE statement. Indexes are only useful when used with SELECT statement. Script to find unused Indexes.…

SQLAuthority News – RIP: Ken Henderson, 1967 – 2008

February 10, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Download

Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects away on Sunday, January 27, in Meeker, Oklahoma. Ken was an inspirational author of the SQL Server Guru’s Guide series of books. We will miss his forever. He was the author I respected the most.…

SQL SERVER – Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3

February 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, SQL Download

SQL Server Compact 3.5 SP1 Beta release for the ADO.Net Entity Framework Beta 3 enables the following scenarios: Applications can work in terms of a more application-centric conceptual model, including types with inheritance, complex members, and relationships Applications are freed from hard-coded dependencies on a particular data engine or storage…

SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified

February 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQL Data Storage, SQL Scripts

Read my article in SQL Server Magazine January 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Simple Example of WHILE Loop with BREAK and CONTINUE

February 4, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

WHILE statement sets a condition for the repeated execution of an SQL statement or statement block. Following is very simple example of WHILE Loop with BREAK and CONTINUE. USE AdventureWorks; GO DECLARE @Flag INT SET @Flag = 1 WHILE (@Flag < 10) BEGIN BEGIN PRINT @Flag SET @Flag = @Flag…

SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql)

February 3, 2008

Pinal Dave

SQL

SQL Error Messages, SQL Server, Starting SQL

Just a day ago while playing with SQL Server I suddenly faced a new kind of error, which I have never seen before. This error happens when clicked on New Query in SQL Server Management Studio. Let us learn in this blog post how we will fix the error – cannot find template file for a new query.

SQL SERVER – Find All The User Defined Functions (UDF) in a Database

February 2, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Following script is very simple script which returns all the User Defined Functions for particular database. USE AdventureWorks; GO SELECT name AS function_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%'; GO Reference : Pinal Dave (https://blog.sqlauthority.com)