.NET (Core and Framework)

3-Oct-10 23:06

Rahul Say hiiiii wrote:
I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc.

Profile the query to see what's going on behind the scenes. It sounds like you have missing indexes there and that the query is performing table scans.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Re: Decrease Query execution time.

Abhinav S4-Oct-10 6:31

Abhinav S

4-Oct-10 6:31

Try to check if making use of a temp table is better than the subquery.
BTW, this is a .Net forum.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick

Visit the Hindi forum here.

Message Removed

2-Oct-10 17:30

about proxy and source control

2-Oct-10 17:30

Message Removed

Cross post

Not Active3-Oct-10 7:07

Not Active

3-Oct-10 7:07

Don't cross post

I know the language. I've read a book. - _Madmatt

NetQuestions2-Oct-10 17:12

2-Oct-10 17:12

Hi,

I read from msdn how VSTS 2010 provides inbuilt support for proxies to enable caching of source controlled files in remote locations so that clients can be configured to retrieve the source controlled files from the proxy and not the main server.

But I could not get to find any document which explains how to build a proxy server.

One important question on prox i have is the behavior in working.

normally while coding, a developer takes the latest version on to his desktop. While using proxy also is it the same or the client machine is always connected to the proxy and changes are made in the proxy? I guess is that behavior should not change and proxy is just a cache or temporary storage to reduce a lot of db calls to the main TFS server.

My understanding of data flow is Main TFS server -> Proxy Server -> Client machine.

regards,
netquestions

modified on Saturday, October 2, 2010 11:36 PM

Re: about proxy and source control [modified]

dan!sh 2-Oct-10 23:19

dan!sh

2-Oct-10 23:19

If you have a proxy server in place, the developer working will be using the proxy server. The merging/synchronization of the proxy and the TFS server will be done as per the set up.

This[^] shows how to set up the proxy.

NetQuestions3-Oct-10 20:31

3-Oct-10 20:31

Hi Danish,

Important!!! proxy is about caching. so it means that actual source control is in TFS server only.

Danish, I had been through that page you have shared in the reply. But isn't it about how Visual Studio
client can take advantage of Team Foundation Server Proxy.

How do I create a proxy server?

Is it possible to move out the source control totally to a different computer /machine?

I am a bit confused now. Are proxies created on client machine itself?

Regards,
NetQuestons

modified on Monday, October 4, 2010 4:03 AM

Pete O'Hanlon4-Oct-10 0:11

4-Oct-10 0:11

Rather than trying to gain knowledge of TFS by posting questions piecemeal here on CP, I'd suggest that you need to buy a book on the subject and read that. This[^] book is a good place to start.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

NetQuestions4-Oct-10 22:40

4-Oct-10 22:40

Hi Pete, I am trying to understand by reading msdn library.

Yes, there is some difficulty in understanding.

thanks for the reference.

Regards,
NetQuestions.

Pete O'Hanlon4-Oct-10 23:02

4-Oct-10 23:02

NetQuestions wrote:
I am trying to understand by reading msdn library

There's your problem right there. As the MSDN is web based, it offers you numerous ways to traverse through the documentation, which means that it's difficult to get a deep understanding because it tends to take you to places that don't immediately tie back to the concept you've just been looking at.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

About framework supporting expression

NetQuestions30-Sep-10 23:04

Re: About framework supporting expression

30-Sep-10 23:04

Hi ,

i am not sure if my understanding of this one is correct.

i have read that expression blend helps create graphical interfaces, helps with animation, video playbacks and works well with WPF and silverlight.

having made this statement what is then so special about expression being a part of TFS.

In the techinical architecture of TFS, along with word, excel, visual studio, microsoft project ... even expression is being identified as a client plug in!!! what does that mean? i thought we already were able to work with blend on wpf applications and silverlight applications.

what is different here?

Regards,
Netquestions

Pete O'Hanlon30-Sep-10 23:56

30-Sep-10 23:56

The important thing to understand is that Blend produces XAML which, ultimately, converts into source code - in fact, it's declarative source code. This means that it needs to be plugged into a source control system in the same way that you would with a standard .cs file. By linking Blend to TFS, you get the advantages that changes to the UI can be tracked/rolledback in exactly the same way as changes to the business logic.

I hope this helps to explain it.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Re: About framework supporting expression

NetQuestions2-Oct-10 17:03

Re: About framework supporting expression

2-Oct-10 17:03

yes, now i got the point.

visual studio is connected to tfs with the view of source control and the underlying database.

a project created in visual studio can be opened in expression blend to improve upon the interface and provide good graphics.

but the fact is after enhancing the windows or web applications the changes and newly created files have to be saved back to TFS db
and source controlled.

so expression blend by plugging into TFS, takes the latest version from TFS and saves the modification back to TFS.

regards,
netquestions

Abhinav S2-Oct-10 23:35

Abhinav S

2-Oct-10 23:35

This post[^] might help you.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick

Visit the Hindi forum here.

Filter Outlook 2003 inbox folder using C# and DASL query

julio.cotroneo28-Sep-10 22:20

julio.cotroneo

28-Sep-10 22:20

I have a Windows Service which manages an OutLook 2003 inbox. The service filter the mailitems using dasl queries, and the problem comes when unexpectedly goes out of order. The filter returns now null instead of Microsoft.Office.Interop.Outlook._MailItem.

Here is the dasl query i use to filter the inbox:

@SQL=(urn:schemas:httpmail:displayto like '%Altamira%' AND urn:schemas:httpmail:textdescription <> 'Mesena' AND urn:schemas:httpmail:textdescription <> 'Aportucasa') OR (urn:schemas:httpmail:displayto like '%altamira%' AND urn:schemas:httpmail:textdescription <> 'Mesena' AND urn:schemas:httpmail:textdescription <> 'Aportucasa')

And this is the code i use to filter the _mailitem the filter function returns:

Microsoft.Office.Interop.Outlook.Items oMailItems = outlookNS.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderInbox).Items;

oMailItems.Sort("[ReceivedTime]", false);

Microsoft.Office.Interop.Outlook._MailItem oMailItem = oMailItems.Find(sFilter) as Microsoft.Office.Interop.Outlook._MailItem;

while (oMailItem != null)

{

if (DoMailActions(oMailItem))

TrataMailProcesado(oMailItem, backupbox);

oMailItem = oMailItems.FindNext() as Microsoft.Office.Interop.Outlook._MailItem;

}

(This code works in a machine that, i, crashed last week, so i figure out that is a configuration problem. But i don't know which one.)

If i use the filter option in Outlook 2003 and i try the dasl query then works perfectly, so.... i don't know what's wrong.

Any replies are welcome.

Julio

Is the SqlConnection constructor method thread safe?

Leo Tohill28-Sep-10 7:27

Re: Is the SqlConnection constructor method thread safe?

28-Sep-10 7:27

I’m trying to get the answer to this question (subject line). The doc on SqlConnection says

“Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.”

Which leads me to believe that the constructor is not thread safe. Just wondering if anybody sees this differently.

- Leo

Luc Pattyn28-Sep-10 7:38

Luc Pattyn

28-Sep-10 7:38

IMO constructors aren't thread-safe, nothing is unless special precautions are taken, and then it gets documented as in "Any public static ...". However, how could this be relevant for constructors, assuming they don't modify their optional parameters?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: Is the SqlConnection constructor method thread safe?

Leo Tohill28-Sep-10 7:57

Re: Is the SqlConnection constructor method thread safe?

28-Sep-10 7:57

A constructor for sure could be thread-unsafe.

Imagine a class foo like this:

public class foo
{
  private static Dictionary<foo> allInstances = new Dictionary<foo> ();
  public foo()
  {
      allInstances.Add(this);
  }
}

That .Add would not be safe. Unless for some reason .Net will not simultaneously create two instances of the same class at the same time. But I doubt that.

Luc Pattyn28-Sep-10 8:07

Luc Pattyn

28-Sep-10 8:07

Thanks, I know how things become thread-unsafe. Big Grin | :-D

.NET does not mind two or more constructors running concurrently.

The SqlConnection constructor gets reflectored like so:

public SqlConnection()
{
    this.ObjectID = Interlocked.Increment(ref _objectTypeCount);
    GC.SuppressFinalize(this);
    this._innerConnection = DbConnectionClosedNeverOpened.SingletonInstance;
}

and DbConnectionClosedNeverOpened looks like a typical singleton implementation.

Are you just curious, or are you having a particular problem? If so, you might have to expand on it (including .NET verion) in order to get a more effective answer.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: Is the SqlConnection constructor method thread safe?

Leo Tohill28-Sep-10 8:18

Re: Is the SqlConnection constructor method thread safe?

28-Sep-10 8:18

Not just curious... I want to know if I need to synchronize execution of new SqlConnection(). With threading issues, it's hard to know if you done it wrong, since it may only fail when conditions are just so.

I doubt that the .net version matters, but let's say 3.5.

Luc Pattyn28-Sep-10 8:16

Luc Pattyn

28-Sep-10 8:16

After some more reflection, I think constructors should always be thread-safe by default (i.e. if they aren't, it should be documented explicitly), and I expect .NET Framework classes to adhere to such rule. The MSDN statement "Any instance members are not guaranteed to be thread safe." IMO applies to the safety with respect to the current object, i.e. don't have two threads call methods on the same object at the same time.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: Is the SqlConnection constructor method thread safe?

Leo Tohill28-Sep-10 8:20

TFS installation [modified]

28-Sep-10 8:20

That sounds reasonable. Thanks.

NetQuestions27-Sep-10 3:19