Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

 

News:



Author Topic: Microsoft SQL Server Management Studio  (Read 1866 times)

youngboy

  • *
  • Posts: 5
    • View Profile
Microsoft SQL Server Management Studio
« on: September 19, 2011, 10:11:08 AM »
There are two programs I open when I sit down to program. One is Visual Studio <whatever version> and the other is Microsoft SQL Server Management Studio, hereinafter known as SMS, I hate to type.

I chose Arvixe because they offer unlimited databases AND remote access. I use SMS all the time as I'm sure you do also to manage your db's.

What I found was that SMS checks permissions on all the db's on that server whenever you expand that node in explorer. As more and more people add db's to the server the wait for this was becoming VERY long. So how can you shorten this time down so you can get to work?

It's actually quite simple.

First open SMS and log into your account.
Second from 'View' choose 'Object Explorer Details'

THIS IS GOING TO TAKE A WHILE DON'T PANIC!

Once it gets done showing you all the various bits of info on EACH db we are going to turn everything but the name field off. This is where you pick up the speed. Don't worry, everything you do in SMS is still available.

Right click on the header field where it says name etc. A dropdown list will appear with various fields checked.

UNCHECK everything but name.

Close Object Explorer Details

Now expand your db's. If you did everything correctly they should open almost immediately and you can start your day without the long wait.

Cheers

brycea

Re: Microsoft SQL Server Management Studio
« Reply #1 on: September 19, 2011, 06:42:20 PM »
I tried this, it's great thanks.

youngboy

  • *
  • Posts: 5
    • View Profile
Re: Microsoft SQL Server Management Studio
« Reply #2 on: September 20, 2011, 06:32:46 PM »
You're welcome

 

Web Hosting

Linux Hosting
ASP .NET Hosting
Business Hosting
Reseller Hosting
Dedicated Servers

Server Alerts
Acceptable Use Policy
Terms of Service
Privacy Policy

Affiliate Program
Site Map

Blog Hosting

WordPress Hosting
ExpressionEngine Hosting
Movable Type Hosting
Habari Hosting
Textpattern Hosting


CMS Hosting

Joomla Hosting
Drupal Hosting
MODX Hosting
Concrete5 Hosting
Xoops Hosting
Ecommerce Hosting

nopCommerce Hosting
OpenCart Hosting
Magento Hosting
osCommerce Hosting
Tomato Cart Hosting


Video Sharing Software Hosting

ClipBucket Hosting
PHPMotion Hosting
ClipShare Hosting
osTube Hosting
vShare Hosting
Forum Hosting

XenForo Hosting
vBulletin Hosting
MyBB Hosting
phpBB Hosting
Simple Machines Hosting


Social Network and Community Website Hosting

SocialEngine Hosting
Elgg Hosting
Dolphin Hosting
phpfox Hosting
OxWall Hosting
Copyright © 2003-2014 Arvixe, LLC. All trademarks are property of their legal owner.