Degree Of Seperation

Jul 28, 2006

Hi,
how can I efficiently find out the shortest connection in the following scenario:
there's a table which has two colums, both of the same type.
two items in the same row means that they are connected. (there is no direction of the connection so that a connection shows up in both ways in a table for query performance issues)
ie. item1 is connected with item2 and item2 is connected with item3, then the table looks like:

row1: item1 , item2
row2: item2 , item1

row3: item2 , item3
row4: item3 , item2

so the connection item1 to item3 would be item1 - item2 - item3.
degree of seperation is 2 in this case. how can I implement this in general with sql?
making an exhaustive search would cost too much time. thanks for any hints!

View 1 Replies


ADVERTISEMENT

Max Degree Parallelism

Dec 15, 2006

hi,i've set 'max degree of parallelism' to 1 because some sql request hanged.Now when i connect, how can i set the parallelism to 4 for a session.Is there a command like this :'alter session set max degree of parallelism 4' ?ThanksPaul

View 6 Replies View Related

Max Degree Of Parallelism Value

Sep 2, 2015

I have SQL Server Version:-

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)   Jun 28 2012 08:36:30   Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
 
This is just an UAT server which has OS and hardware detail below:-

OS :- Windows Server 2008 R2 Standard
SP:- SP1
Processor :- Intel(R) Xeon(R) CPU  X5650 @2.67GHz 2.66 GHz
RAM : - 4 GB
Bit - 64 bit

I want to set the value to max degree of parallelism, what value should i configure for the same?

Below is the snap property of SQL instance >> Processor

View 3 Replies View Related

Calculation Of A Degree Of Similarity Of Phrases

May 19, 2004

Hi!
i make The Extended stored procedure for MS SQL Server which
Calculation of a degree of similarity of phrases.

Purpose:
One of the most complex and important problems for the developer and the operator of a database is maintenance of uniqueness names in the most important references of system.
Offered function can be used in SQL inquiry as criterion of sorting of the directory according to similarity with a required phrase.

Features:
· incredibly high speed of data processing
· Unique algorithm analyzing similarity of phrases even at significant divergences in required phrases
· is not required installation of additional libraries to each client - library DLL must benn installed only on a server.
· Result is all the table sorted in decreasing order phonetic similarity (probably use of operator TOP for sample only the limited quantity of the most similar variants)
· Use of user server function supposes use in Stored procedures, Views and any SQL expressions
· Spends a minimum of server memory

--------------------------------------------------------------------------
If the decision of the given problem is interesting to you and there is an opportunity desire and an opportunity to test http://kozin1.narod.ru (http://kozin1.narod.ru/newsite/index.html?english.htm)
Dll and sample scripts in rar archive (2,5 KB)
I thank in advance

View 2 Replies View Related

Degree Sign In SQL Server Database Field

Apr 16, 2008

Hi,
I want to put a Degree sign in a SQL server field. Can anyone tell me how to do this please (preferably on the data entry screen rather than by coding it in, as I need it freqently).
Many thanks.

View 4 Replies View Related

SQL Server 2008 :: Relation Between Max Degree Of Parallelism And Number Of CPU Cores

Jun 12, 2015

I have got a question on max degree of parallelism and CPU cores.

If max degree of parallelism = 1, this signifies that sql will use serial execution plan (unless u change it in query level with MAXDOP hint). In serial plan, will the query use all CPU cores (say in my server I have 16 core processors)?

If in serial execution plan only one thread works, then what the other threads doing ? Idle (I may have a defined max server worker thread = 32767(by default)

Unable to create a relationship between this parameters.

View 3 Replies View Related

SQL Server 2012 :: MAX Degree Of Parallelism Option Not Working In Resource Governor?

May 29, 2014

I am running a query on SQL 2012 Server with the Resource governer setup for my account to have Max DOP option set to 1.

The query still runs in about 1 minute and the execution plan still considers parallelism.

When I explicitly mention the OPTION (MAXDOP 1) , the query runs in 6 seconds.

How can i tell by querying DMV's whether my query is using parallelism or not?

View 2 Replies View Related

Seperation Of Log File And Database File

May 7, 2007

Hi,

I have the database file and log file for all the databases in SQL server in the same drive. I want to seperate both the log and data file into different drives. What is the best way to do it? Is there any script that could be run.

Please help.

Thanks !

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved