.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Which is more efficient LIKE or LEFT()?

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server

In AdventureWorks DB, which one is more efficient?


select * from Person.Contact where LEFT(LastName,4) = 'Cole'

select * from Person.Contact where LastName like 'Cole%'


View Complete Post

More Related Resource Links

left right margin


Hiii Coders ,

I have created my website. Now what is my requirement is that on higher resolution it should be centralized means margin from both sides should be same.

How can i get it working

plz provide me some code snippet plz

thanx and regards

Drop-Right/Left submenus


 I'm currently using the CurvedMenuProjects custom control and I does almost everything I need a Menu Control to do but it doesn't swap submenu position (left/right) when the dropdown goes off the right edge of the screen.


Does anybody know if it's possible to configure the control to do this?


Any pointers on how I can get started writing the behavior into the custom control myself?




Foundations: Writing More Efficient ItemsControls


Here Charles Petzold explains several techniques for improving the performance of ItemsControls.

Charles Petzold

MSDN Magazine March 2009

Data Points: Efficient Coding With Strongly Typed DataSets


Someone once said to me that the hallmark of a good developer is the desire to spend time efficiently. Developers are continually pursuing ways to make coding easier and faster, and to reduce the number of errors.

John Papa

MSDN Magazine December 2004

SENS: System Event Notification Services and WMI Enable Flexible, Efficient Mobile Network Computing


Networked applications must deal with a host of connection problems ranging from timeouts to congestion to unavailability. If these applications can check the current connection status and, when disconnected, cache transmissions, they become more efficient. Fortunately, both the System Event Notification System (SENS) and Windows Management Instrumentation (WMI) can send notifications to keep applications informed of network status. In this article, the author explains the use of several SENS interfaces, including ISensNetwork and ISensLogon, which trigger events for connects/disconnects and logons/logoffs, respectively. The author then shows how you can subscribe to each of these events, and follows with a discussion of when you might use WMI events instead.

Aspi Havewala

MSDN Magazine August 2002

Marshalling Your Data: Efficient Data Transfer Techniques Using COM and Windows 2000


The way you choose to transfer data is vitally important in a distributed application. Windows 2000 provides several new features that allow you to transfer data more efficiently. Lightweight handlers allow you to write smart proxies that can cache results and perform buffered reads and writes, minimizing the number of network calls. Windows 2000 also allows you to use pipe interfaces to transfer large amounts of data efficiently through a read-ahead facility. This article illustrates several ways to improve data transfer in Windows 2000 using these new features. It also reports the results of transfer time tests and provides recommendations for transferred buffer sizes.

Richard Grimes

MSDN Magazine September 2000

Only 12 days left in the Code Contest!


We are having a fun coding contest to find the best solution to a fairly trivial coding problem.  Come along and show off your skills . you might just win a totally awesome Gyroscope Powerball!

Participate in the Code Contest!

What is the most efficient way to transmit XML messages in WCF?


Hi Folks,

What is the most efficient way to transmit messages in WCF?
I've done a few basic walkthroughs of WCF and upon analyzing the XML transmission I saw that they were very large by default. Containing what appears to me, as a lot of unnecessary information, for my needs.

I'm looking for a way to send the shortest messages possible.
How can I trim as much as possible from the XML?
Can I remove all the header information...

What approach to you suggest for sending the shortest messages possible using XML in WCF?


How can I align Left the text into a Button?

I've tried: Code Snippet Button button = new Button(); button.Width = 200; TextBlock textBlock = new TextBlock(); textBlock.Text = "Aligned text" textBlock.TextAlignment = TextAlignment.Left; button.Content = textBlock;   but it is not working.

Most efficient way to check whether a DataGridView contains some specific text at a specific column

Dear All,   I am looking at the most efficient way to check whether a specific column of a DataGridView contains some text. For example I have a list of firs names and I would like to check whether the text "Bob" already exists in that columns. I would like to avoid to loop through each row but what thinking of using something with "Contains".   Anybody has an idea ?   Cheers,   Kalos

How to scroll the DataGrid (horizontally) when user drags a column header far left or right?

We're working with the WPF DataGrid and I have a question about  dragging column headers: The grid lets the user rearrange the columns, by dragging the column header left or right.  So far, so good. But, sometimes we have many columns, and only the first few columns are visible; so there is a horizontal scrollbar.  In such case, if the user drags a column header to the right edge of the DataGrid window, I want the DataGrid to scroll, automatically, one column at a time.  Is there an easy way to do that? (To be clear: yes, the user can already scroll horizontally by interacting with the horizontal scrollbar, but that isn't what I'm asking about.  I'm asking if the "drag a column header left or right" gesture can cause the DataGrid to scroll left or right.) I guess I could handle various low-level events, but it seems like it shouldn't be necessary -- DataGrid has so much functionality built-in, that I'm guessing it already has the ability to scroll when the user drags the column header to the edge.  So, is there either (a) a property that I can set, to tell the DataGrid to scroll when the user drags a column header to the edge of the window;  or (b) a code example showing how to achieve this effect myself?  Thanks!

How to write query with subquery more efficient

Hello, I have this query which generates sick days. I have a sick start date and end date, and by joining it with a date table I get all sick days for each employee. But as you can see i select a number of fields, but in the subquery i select a number of fields which are the same. Is it possible to write it more efficient? Thans in advance! SELECT z .ziekmeldingID, z .hrmID, z .ZiekStartDatum, z .ZiekEindDatum, z .ZiekStartTijd, z .ZiekEindTijd, z .ZiekOpen, z .ZiekTypeID, z .ZiekRedenID, z .ZiekStart_KEY, z .ZiekEind_KEY, z .Verzuimduur, D .Datum AS ZiekDag,   CAST(CONVERT(char(8), D.Datum, 112) AS int) AS ZiekDag_KEY, z .hr301_date, z .PercentageZiek, z .PercentageHersteld FROM     (   SELECT dbo .hr300.hr300_obj AS ziekmeldingID, dbo .hr300.hr300_date_start AS ZiekStartDatum,   CASE   WHEN dbo.hr300.hr300_date_end IS NOT NULL   THEN dbo.hr300.hr300_date_end   ELSE getdate()   END AS ZiekEindDatum, dbo .hr300.hr300_time_start AS ZiekStartTijd, dbo .hr300.hr300_time_end AS ZiekEindTijd, dbo .hr300.hr300_open AS ZiekOpen, dbo .hr300.hr104_obj AS ZiekTypeID, dbo .hr300.hr038_obj AS ZiekRedenID, dbo .hr300.hr200_obj AS hrmID,   CAST(CONVERT(char(8), dbo.hr300.hr300_date_start, 112) AS int) AS ZiekStart_KEY,   CAST(CONVERT(char(8), dbo.hr300.hr300_da

Textblock and left/top alignment has different space

Hi, when i add a text the text is aligned left,top by default. At the left the text hits the edge, but at the top the text still has space left. Is this because of some special characters that need that space? I would like to show the text with left and top the same amount of space. <Window x:Class="MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" Height="350" Width="525"> <Grid> <TextBlock Background="Red" FontSize="100" FontFamily="Verdana" Padding="0" >T98}`|_*dfshjd sjlksdj dsjl djskldj lksj dlksj</TextBlock> </Grid> </Window>

How do I keep the #region/#endregion directives on the left edge, or is that possible (C#)?

Hello, How do I keep the #region/#endregion directives on the left edge, or is that possible (C#)? The #region/#endregion keep moving to the left to align with the rest of the code.  I don't want that to happen. Regards, Robert

Left Outer Join fails to return all records

I have a table tblDrop that contains 1067 records for 8/31/2010 and a table tblSoftcount that has 739 records, some with bad serial numbers. I need to match all of the records in tblDrop with those in tblSoftcount. I have a query using Left outer join that has worked for the duration of the application, but has recently stopped returing the full set of records from tblDrop. We have not changed the SQL versions on the server (compatibility level 2005). Here is the query: SELECT   v.SlotNum_ID, s.SlotNum_ID, v.PTNumber, s.PTNumber, v.DropBillAmount AS [Drop], v.ReportDate, v.DateValue     FROM tbl_Drop v LEFT OUTER JOIN tblSoftCount s ON v.SlotNum_ID = s.SlotNum_ID AND v.ReportDate = s.ReportDate WHERE   s.ReportDate = '8/31/2010' AND v.DropBillAmount <> 0 AND s.Slotnum_ID IS NULL;  

Edit Blog site - hide the left navigation bar

Hi, We want to customize the look & frrl of a blog. I don't see a page layout gallery, only master pages. Which master page is used and how may i hide the left navigation bar?

collapsing the left menu as a default

 Hi! i have a menu on the left of the page which appears in the expandable form. I want to see them as the collapsed menu based on the site map group. I have posted the site map code and the master page here. Any idea please<?xml version="1.0" encoding="utf-8" ?> <siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" > <siteMapNode url="~/Default.aspx" title="Modules" description="Modules"> <siteMapNode url="~/Modules/Hire/Hire.aspx" title="Hire" description="Hire" resourceKey="HIR"> <siteMapNode url="~/Modules/Hire/Hire_Request_Navigator.aspx" title="Booking Request" resourceKey="HIR_REQ" description="Booking Request"> <siteMapNode url="~/Modules/Hire/Hire_Request_Detail.aspx" title="Request Detail" resourceKey="0" isPhantom="true"/> </siteMapNode> <siteMapNode url="~/Modules/Hire/Hire_Booking_Navigator.aspx" title="Booking" resourceKey="HIR_BOO"> <siteMapNode url="~/Modules/Hire/Hire_Booking_Fleet_Available.aspx" title="Booking Vehicle Selection" resourceKey="0" isPhantom="true"/> <siteMapNode url="
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend