SQLServerCentral / Discuss Content Posted by Robert Pearl / Article Discussions / Article Discussions by Author

Meme Monday - All in the #SQLFamily

RSP — Mon, 13 Feb 2012 02:01:13 GMT

Comments posted to this topic are about the item [B]Meme Monday - All in the #SQLFamily[/B]

A Tale of Two Cities - SQLSaturday Goes Global..

RSP — Mon, 13 Feb 2012 01:01:58 GMT

Comments posted to this topic are about the item [B]A Tale of Two Cities - SQLSaturday Goes Global..[/B]

Local Community Events & User Groups from Around Town....

RSP — Wed, 08 Feb 2012 08:52:53 GMT

Comments posted to this topic are about the item [B]Local Community Events & User Groups from Around Town....[/B]

Meme Monday - Working with Deadlines.....

RSP — Tue, 07 Feb 2012 00:01:46 GMT

Comments posted to this topic are about the item [B]Meme Monday - Working with Deadlines.....[/B]

T-SQL Tuesday #26 - Second Chances - Correlate Missing Index with Related Query

RSP — Fri, 13 Jan 2012 02:19:31 GMT

Comments posted to this topic are about the item [B]T-SQL Tuesday #26 - Second Chances - Correlate Missing Index with Related Query[/B]

Q.How Many Weeks in the Year? A.It depends

RSP — Wed, 28 Dec 2011 00:18:20 GMT

Comments posted to this topic are about the item [B]Q.How Many Weeks in the Year? A.It depends[/B]

Twas The Week After Christmas....

RSP — Mon, 26 Dec 2011 12:11:44 GMT

Comments posted to this topic are about the item [B]Twas The Week After Christmas....[/B]

Tis The Season to be Giving...#SQLFamily

RSP — Sat, 24 Dec 2011 01:06:24 GMT

Comments posted to this topic are about the item [B]Tis The Season to be Giving...#SQLFamily[/B]

SQL Server 2005 Maintenance Mayhem

RSP — Wed, 04 Apr 2007 19:02:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/2953.asp

More SQL Server 2008 Installation Issues

RSP — Thu, 05 May 2011 00:01:27 GMT

Comments posted to this topic are about the item [B]More SQL Server 2008 Installation Issues[/B]

SQL Server 2008 Installation Issues - Issues and Workarounds

RSP — Thu, 28 Apr 2011 00:01:32 GMT

Comments posted to this topic are about the item [B]SQL Server 2008 Installation Issues - Issues and Workarounds[/B]

SSIS Package Credentials

RSP — Wed, 09 Dec 2009 20:59:24 GMT

Comments posted to this topic are about the item [B]SSIS Package Credentials[/B]

Why Use SSAS?

RSP — Fri, 19 Feb 2010 00:01:24 GMT

Comments posted to this topic are about the item [B]Why Use SSAS?[/B]

Let's Talk Ownership (and SQL Jobs)

RSP — Thu, 19 Nov 2009 00:19:46 GMT

Comments posted to this topic are about the item [B]Let's Talk Ownership (and SQL Jobs)[/B]

Full Text Search Follies

RSP — Wed, 17 Jan 2007 17:16:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/2819.asp

can't restore over the network path

abansil — Mon, 10 Mar 2008 04:20:29 GMT

The Database Engine service could not resolve the specified file location. Either the location does not exist, or the current login account does not have access to it. Verify that the file location exists, and that the login account has permissions on it.

I/O I/O - It's why my server's slow.....Examing I\O Statistics

RSP — Wed, 19 Aug 2009 05:56:06 GMT

Comments posted to this topic are about the item [B] I/O I/O - It's why my server's slow.....Examing I\O Statistics[/B]

Installing and Upgrading to SQL Server 2005

RSP — Mon, 20 Jun 2005 21:54:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/installingandupgradingtosqlserver2005.asp

An Interview with Brad McGehee - Part 2

RSP — Fri, 10 Apr 2009 00:21:01 GMT

Comments posted to this topic are about the item [B]An Interview with Brad McGehee - Part 2[/B]

An Interview with Brad McGehee - Part 1

RSP — Thu, 09 Apr 2009 00:20:42 GMT

Comments posted to this topic are about the item [B]An Interview with Brad McGehee - Part 1[/B]

Correction on the supported upgrade paths from SQL2000

jdmaloy226 — Tue, 31 Mar 2009 11:31:26 GMT

In describing the supported upgrades, the article said:[quote]Any edition from SQL Server 2000, can be upgraded to SQL2K5. These include Enterprise, Developer, Standard, Personal, and Evaluation editions. In order of precedence, low to high, Desktop can be upgraded to Express, Standard, Developer and Enterprise Editions (XSDE); [b]Personal to S,D,E;[/b] Standard to D and E, and Developer to Enterprise edition.[/quote]This isn't the case though. While running a testing scenario I attempted to upgrade SQL2000 Personal to SQL2005 Developer. The attempt failed out with a message that it wasn't a supported upgrade. On checking the upgrade information article at MSDN, it confirmed that SQL2000 Personal can be upgraded only to SQL2005 Express, Workgroup, or Standard -- not Developer or Enterprise. The other editions of SQL2000 also have much narrower upgrade paths than the article indicates.Ref -- http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

Fixed Cost IT Management

RSP — Thu, 09 Oct 2008 06:32:31 GMT

Comments posted to this topic are about the item [B]Fixed Cost IT Management[/B]

A Bit About 64-bit

RSP — Thu, 20 May 2004 13:56:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/abitabout64

Interview with Chuck Kelley - Part II

RSP — Thu, 27 Mar 2008 00:14:18 GMT

Comments posted to this topic are about the item [B]Interview with Chuck Kelley - Part II[/B]

Interview with Chuck Kelley - Part I

RSP — Wed, 26 Mar 2008 00:16:05 GMT

Comments posted to this topic are about the item [B]Interview with Chuck Kelley - Part I[/B]

Restore database

abansil — Wed, 12 Mar 2008 22:27:14 GMT

Hi!I am having issues restoring a SQL Server 2000 database to a SQL Server 2005 instance. My ultimate goal is to move over to SQL Server 2005. These are the issues I have so far with the restoration process:- When selecting the file to restore the 'Restore database' form does not allow me to drill down past one folder level (ie. c:/myfiles vs c:/myfiles/cantgethere). Is this part of the mapped drive issue you were speaking about?- I am getting an error "The Database Engine service could not resolve the specified file location. Either the location does not exist, or the current login does not have access to it." Perhaps this is part of the mapped drive issue as well?The database that I am trying to restore is very large and I do not have enough space to copy the backup locally to perform the restoration. Do you know of a workaround?I also have an issue where I am unable to install the 2005 samples. When I try to install them the system feels they are already installed. Looks like I hit a number of issues you brought out in your article.Thanks for the good info!

Can't Restore the database over the Network Path.

abansil — Mon, 10 Mar 2008 04:23:53 GMT

Visual Studio 2005 and SQL Server 2005

SQL-DBA — Fri, 11 Jan 2008 14:06:32 GMT

Anyone know the proper order to install VS 2005 and SQL 2005 on the same box?

Full-Text Follies

RSP — Wed, 17 Jan 2007 17:13:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/2818.asp

SQL Server 2005: Changing the Paradigm

RSP — Tue, 17 Oct 2006 14:15:00 GMT

Comments posted here are about the content posted at temp

On the Road...Part II

RSP — Wed, 31 Aug 2005 17:44:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/ontheroadpartii.asp

On The Road Again...Part I

RSP — Fri, 26 Aug 2005 11:10:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/ontheroadagainparti.asp

SQL Server 2005 Roadshows

RSP — Fri, 06 May 2005 17:55:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/sqlserver2005roadshows.asp

A Report from the NY Database Professionals Council

RSP — Wed, 12 Jan 2005 13:44:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rpearl/areportfromthenydatabaseprofessionalscouncil.asp