Month: June 2016

Connectivity – Network Related Error :

Today while connecting my  MS SQL 2012  Server after a long time , i came across an error :
A network-related or instance-specific error occurred while establishing a connectionto SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.(provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Solution : 

I checked services of my pc , by typing the “services.msc” in the run , which opens the services dialog box .Then started the services of SQL Server which were not in running state.

I was then able to connect

Best Regards,

 

Working With Indexing -Part 1

OVERVIEW :

  • An index is a database’ essential  structure and a component which makes faster , quicker and easier to find data based on more than one columns.
  • We can think of an index in database just like of searching a word in a dictionary .
  • For example : If you want to search a word : “Computer” , you have two paths to go to that word : First , go page by page in sequential word by word order , second path is : You quickly start searching through the Alphabet , like first in C then  : ->o->m->p->u->t->e->r .
  • The first path will take for example : 1 minute to reach the word , the second path will take 10 seconds to reach the word . This is the beauty of Indexing , it reduces the path to the best optimal path and saves time.