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

SQL SERVER – Cumulative Update Package 5 for SQL Server 2005 Service Pack 2

December 19, 2007

Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in…

SQLAuthority News – RML Utilities for SQL Server

December 19, 2007

Pinal Dave

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

SQL Download

The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the most resources, and which queries are responsible for that Whether there were any plan changes for…

SQL SERVER – Get Information of Index of Tables and Indexed Columns

December 18, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

Knowledge of T-SQL inbuilt functions and store procedure can save great amount of time for developers. Following is very simple store procedure which can display name of Indexes and the columns on which indexes are created. Very handy stored Procedure. USE AdventureWorks; GO EXEC sp_helpindex 'Person.Address' GO Above SP will…

SQL SERVER – Solution – Log File Very Large – Log Full

December 16, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Log

I have been receiving following question again and again either through email or through comments on this blog. My log file is too big, what should I do? Answer to this question is in three steps. Backup the log file to any device. Truncate the log file. Shrink the log…

SQLAuthority News – Top 10 Tips for Successful Software Outsourcing

December 14, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Outsourcing Technology, Software Development

Few days ago, I wrote article about SQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource. I received quite a few emails regarding this article. I was really impressed that how much vendors care about their reputation and their client. I received so many requests…

SQL SERVER – Do Not Store Images in Database – Store Location of Images (URL)

December 13, 2007

Pinal Dave

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

Database, SQL String

Just a day ago I received phone call from my friend in Bangalore. He asked me What do I think of storing images in database and what kind of datatype he should use? I have very strong opinion about this issue. I suggest to store the location of the images…

SQL SERVER – White Papers: Migration from Oracle Sybase, or Microsoft Access to Microsoft SQL Server

December 12, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL White Papers

Guide to Migrating from Oracle to SQL Server 2005 This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2005. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration…