SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 
        
Home       Members    Calendar    Who's On


12»»

The SQL Internals Viewer Expand / Collapse
Author
Message
Posted Monday, August 20, 2007 4:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 23, 2009 3:39 AM
Points: 4, Visits: 106
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/dgould/3200.asp
Post #392277
Posted Monday, August 27, 2007 7:33 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:24 AM
Points: 6,144, Visits: 1,568
One word: OUTSTANDING!


* Noel
Post #393990
Posted Monday, August 27, 2007 7:35 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 18, 2009 3:47 PM
Points: 594, Visits: 9,504

This looks really good...now, I need to understand what infomation I have here...still looking.

THANKS!

 

C



--Cory Ellingson

Post #393991
Posted Monday, August 27, 2007 8:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 21, 2009 1:55 PM
Points: 60, Visits: 25

Looks great.

When I try to connect to a remote db, I get this error:
Any one know why?

TITLE: Connect to server
------------------------------

Invalid object name 'sys.database_files'. (Microsoft SQL Server, Error: 208)

 

Post #394002
Posted Monday, August 27, 2007 8:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 23, 2009 11:57 PM
Points: 64, Visits: 16
I'll be checking this app out.  It looks great!



--------------------------
Zach

Odds_And_Ends Blog
Post #394015
Posted Monday, August 27, 2007 8:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 23, 2009 3:39 AM
Points: 4, Visits: 106

Donavon,

What version of SQL Server are you trying to connect to? The tool only works with SQL Server 2005/2008.

Danny

Post #394021
Posted Monday, August 27, 2007 10:07 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, December 08, 2008 8:42 AM
Points: 775, Visits: 214

This is sweet. No more DBCC Page commands for me!

As an aside, does Kalen Delaney know about this tool yet? She might find it quite interesting, since she's person that many of us learned the internals from in the first place.

Post #394070
Posted Monday, August 27, 2007 10:46 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, September 30, 2009 12:03 PM
Points: 777, Visits: 198
This is awesome.

Great tool. I'm adding this to my shortlist of must have SQL Server tools.
Post #394076
Posted Monday, August 27, 2007 10:49 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 12:37 PM
Points: 929, Visits: 304

A couple of changes that I'd like to see made in the tool in a future release:

  1. The application is listed as ".Net SqlClient Data Provider". Would prefer to see it's actual application name listed when I do an sp_who2.
  2. The distribution database is listed as a user database rather than a system database. I would like to see it listed as a system database.

 

I received the following error:

TITLE: SQL Internals Viewer
------------------------------

An unhandled exception has occurred.

Please report this error to issues@sqlinternalsviewer.com to help improve this application.

------------------------------
ADDITIONAL INFORMATION:

Index was outside the bounds of the array. (SqlInternalsViewer)

------------------------------
Program Location:

   at SqlInternalsViewer.UI.AllocationUnitsLayer.GenerateLayers(Database database, BackgroundWorker worker)
   at SqlInternalsViewer.ApplicationForm.AllocUnitbackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

 





Practical Uses of PatIndex
Check/Set Default File Paths with TSQL
UDF to strip HTML style tags from text
Calculate Easter for any year
Dynamic defrag of all indexes
Post #394078
Posted Tuesday, August 28, 2007 9:58 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, November 12, 2009 2:29 AM
Points: 852, Visits: 1,742
Is this a Vista-only app? I don't have 2005 online right now to play with it yet, I was wondering because the window control boxes are different.

-----
Regards,
Wayne West

The Cheap DBA and the Arizona SQL Server User Group
Post #394366
« Prev Topic | Next Topic »

12»»

Permissions Expand / Collapse