SQL Tips and Tricks Archives - Page 420 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Top 10 Strategic Technologies for 2009

March 30, 2009

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

Best Practices, Software Development, SQL Download

Gartner, Inc. analysts highlighted the top 10 technologies and trends that will be strategic for most organizations. Factors that denote significant impact include a high potential for disruption to IT or the business, the need for a major dollar investment, or the risk of being late to adopt. The top…

SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database

March 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL TempDB

Recently, one of my regular blog readers emailed me with a question concerning the following error: Msg 2714, Level 16, State 6, Line 4 There is already an object named ‘#temp’ in the database. This reader has been encountering the above-mentioned error, and he is curious to know the reason…

SQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download

March 28, 2009

Pinal Dave

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

Database, DBA, SQL Download

SQL Server 2008 new brochure is available for download. Microsoft® SQL Server® 2008 provides a trusted, productive, and intelligent data platform that enables you to: Run your most demanding mission-critical applications. Reduce time and cost of development and management of applications. Deliver actionable insight to your entire organization. Your Data,…

SQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today

March 27, 2009

Pinal Dave

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

Database, DBA, MVP, Poll, SQL User Group

I have published a poll on website few days ago for favorite database of SQLAuthority.com readers. The best comment will win USB drive. The poll will close on April 1, 2009. Looking at the poll result, it seems that Oracle has gained a lot over SQL Server from last time…

SQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009

March 27, 2009

Pinal Dave

Personal, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, MVP, MVP Summit 2009

Microsoft MVP Award Blog and Microsoft South Asian MVP Blog has published my video interview online. My interview was conducted by Abhishek Kant – Microsoft MVP Lead and Technology Blogger. I am thankful to Abhishek Kant for conducting my interview, Abhishek Baxi for publishing on South Asian Blog and Jas…

SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.

March 26, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Advanced Option, SQL Error Messages, SQL Scripts

I received another email describing error received due to my executing script from my previous article . Error : Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option ‘optimize for ad hoc workloads’ does not exist, or it may be an advanced option. Let us quickly…

SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master

March 26, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Activity Monitor, SQL Error Messages, , SQL Scripts

I have received comment from Radha Goswami on my previous blog article SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users. Radha is facing following error when she is tring to grant permission to login. Error: Msg 4621, Level 16, State 10, Line…