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

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

Please anyone can explain CHECKSUM_AGG

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server


Please anyone can explain CHECKSUM_AGG. I want to know what it is doing exactly.

Use below queries to explain it.





View Complete Post

More Related Resource Links

Can someone please explain what this line of code is actually doing

I took this line of control from this post http://forums.asp.net/t/1201593.aspx I'm actually trying to do the same dynamic accordion.   MyAccordion.ItemDataBound += new EventHandler<AccordionItemEventArgs>(MyAccordion_ItemDataBound);    I converted to vb.net and this is the equivalent. MyAccordion.ItemDataBound += New EventHandler(Of AccordionItemEventArgs)(MyAccordion_ItemDataBound) when I type  that line in my code I get an error.. Error 3 'Public Event ItemDataBound(sender As Object, e As AjaxControlToolkit.AccordionItemEventArgs)' is an event, and cannot be called directly. Use a 'RaiseEvent' statement to raise an event.    and   Error 4 Delegate 'System.EventHandler(Of AjaxControlToolkit.AccordionItemEventArgs)' requires an 'AddressOf' expression or lambda  

Can someone explain this inheritance?

I am having trouble understanding the inheritance listed in http://msdn.microsoft.com/en-us/library/cc406686(office.12).aspx <%@ Page Debug="true" Language="C#" MasterPageFile="~/_admin/admin.master" Inherits="MSDN.SharePoint.Samples.WarmupJobManager, MSDN.SharePoint.Samples.SharePointWarmupJob, Version=, Culture=neutral, PublicKeyToken=7fd1d26c5854f031" %> It almost looks to me like two classes are being inherited - WarmUpJobManager AND SharepointWarmupJob. Is this correct?...or even possible?? Neither class is a partial class. Sorry I am new to this and was trying to deploy this example but the inheritance displayed here has me confused. Thanks in advance, Jake.

Can someone explain this assembly in WSP deployment behavior?

I was building a SP timer Job feature. Upon successive feature deployment and retractions using the Visual Studio environment the code changes were not being deployed. I dug around and found this in the AssemblyInfo.cs // You can specify all the values or you can default the Build and Revision Numbers // by using the '*' as shown below: // [assembly: AssemblyVersion("1.0.*")] So I changed what was the following line from [assembly: AssemblyVersion("")] to the stated [assembly: AssemblyVersion("1.0.*")] and all is well (yippee). This seems to make good sense to me. But why is it not the default build/deploy setting? Is there an IDE interface for this setting. Is it related to the the Solution Configuration or build target or an IIS reset timing or GAC cache.....anything like that?


I'm doing Select CHECKSUM_AGG(BINARY_CHECKSUM( OP.ID ) FROM objPlat OP WHERE OP.oID = O.oID table OP has 10244 rows table O has 2425 rows My number being returned ends up being negative, so I'm guessing that means it's hitting the int limit.  Is there any way to use this as a bigint or is there another way to do it? Thanks in advance

checksum_agg overflow

if i use checksum_agg(checksum(*)) from table A i had noticed that sometimes checksum_agg overflows - eg gives the same results for different sets of data   is there  a way to get better checksum - eg average?    

explain me how many functions are their in sql server with examples

explain me how many functions are their in sql server with examples ?

while trading in stock market it was chnaging dynamically how it was working explain with examples

while trading in stock market it was chnaging dynamically how it was working explain with examples

Can someone explain how SharePoint determines what to display as the Title of the document for searc

I would it expect it to be the the actual title of the documnet but instead I have noticed that it looks in the document and displays the first word or two as the title.

Can anyone explain how SQL Server performance scales with CPUs/Cores, memory, disk drives, etc?

I have experienced the situation where our application running on an expensive system with two 4 core CPUs ran slower than on a cheap machine with one dual core CPU. Both machines had similar memory capacity. In each case, the same query was being run by only one user. It would be nice to find a way to increase performance, but if adding cores doesn't help, what can a poor developer do? Customers get annoyed when they spend a truckload of money on a new server and nothing changes... Another potential problem is when customers have an expensive SAN system Sometimes the performance is much slower then on a system with conventional storage. Can anyone explain the relationship between SQL Server perfomance and hardware ?

Estimated Explain Plan does not return



I have a query which takes a very long time to complete appx 1 hour. If I run an estimated execution plan on the query, this can run for over an hour and doesn't return the plan. Any ideas why the plan should take so long. Is the only way around this to clear the cache?



Hi can u please explain me WWF taking real time scenario / live project

please explain me WWF  taking real time scenario / live project

Explain Data warehouse maintainence


Implementation of Data warehouse,Physical design: steps,considerations,physical storage,indexing,Performence Optimization,Data warehouse deployment activities, Data security, backup and recoveryconcepts, Data warehouse maintainence.

Can anyone explain me what is MVC, and what is the use of MVC and where we implement it


please any one explain me what is MVC , what is the use of mvc and what i need to learn the MVC, what are the initial requirements for the Learning and MVC is a three tier architecture or not.  please give me a clean explanation please  

Explain Plan for sp_executesql



please bear with me as I'm new to Sql Server.

I have extracted a SQL statement from a trace file using the sql profiler tool. This was for a SharePoint application. The SQL statement includes the stored procedure sp_executesql with a number of scalar variables and I was wondering how do I get the explain plan that was actually used when executing the sql.

Is there a system view I can query that gives this sort of information?

Many thanks in advance for any help.


why we use session here, what is the use of it, can you anyone explain me- i am a fresher


    protected void Page_Load(object sender, EventArgs e)
        string code = Session["Ccode"].ToString();
        string mail = Session["Cmail"].ToString();
        string name = Session["signname"].ToString();

        if (!Page.IsPostBack)
            txtfname.Text = Session["signname"].ToString();
            txtmail.Text = Session["Cmail"].ToString();


 protected void btnupdate_Click(object sender, EventArgs e)
        string code = Session["Ccode"].ToString();
        string mail = Session["Cmail"].ToString();
        SqlCommand cmd = new SqlCommand("AT_SP_UPDATE_CUSTOMERDETAILS", SQLConn);
        cmd.CommandType = CommandType.StoredProcedure;


can any one explain me, we we getting the values in session variables, please. give me  a explanation, what is the use of it, and if we dont get the value sin session variable means what wil happen,.

please explain me 

C# auto-implemented properties: please explain


 Hi all...I'm learning ASP.NET, and I have Java experience, but am obviously having to switch to C# to use ASP.NET...I am working through the MVCMusicStore tutorial, and I just need a bit of a clarification on this comment the tutorial makes. They say to declare the following class:

public class StoreIndexViewModel
public int NumberOfGenres { get; set; }
public List<string> Genres { get; set; }

Then they say: "Note: In case you're wondering, the { get; set; } notation is making use of C#'s auto-implemented properties feature. This gives us the benefits of a property without requiring us to declare a backing field." What are they taking about exactly? Like in Java I would create get_Genres, set_Genres, get_NumberOfGenres, and set_NumberOfGenres methods and declare these variables as private not public, to protect my data. But in C#, is this same basic thing? Is the data still being protected? I would appreciate any input. Thanks

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