Search Results

Search found 21433 results on 858 pages for 'query execution plans'.

Page 307/858 | < Previous Page | 303 304 305 306 307 308 309 310 311 312 313 314  | Next Page >

  • TSQL Challenge 31 - Managing multiple overlapping date intervals.

    This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession

    Read the article

  • Information I need to know as a Java Developer [on hold]

    - by Woy
    I'm a java developer. I'm trying to get more knowledge to become a better programmer. I've listed a number of technologies to learn. Instead of what I've listed, what technologies would you suggest to learn as well for a Junior Java Developer? I realize, there's a lot of things to study. Java: - how a garbage collector works - resource management - network programming - TCP/IP HTTP - transactions, - consistency: interfaces, classes collections, hash codes, algorithms, comp. complexity concurrent programming: synchronizing, semafores steam management metability: thread-safety byte code manipulations, reflections, Aspect-Oriented Programming as base to understand frameworks such as Spring etc. Web stack: servlets, filters, socket programming Libraries: JDK, GWT, Apache Commons, Joda-Time, Dependency Injections: Spring, Nano Tools: IDE: very good knowledge - debugger - profiler - web analyzers: Wireshark, firebugs - unit testing SQL/Databases: Basics SELECTing columns from a table Aggregates Part 1: COUNT, SUM, MAX/MIN Aggregates Part 2: DISTINCT, GROUP BY, HAVING + Intermediate JOINs, ANSI-89 and ANSI-92 syntax + UNION vs UNION ALL x NULL handling: COALESCE & Native NULL handling Subqueries: IN, EXISTS, and inline views Subqueries: Correlated ITH syntax: Subquery Factoring/CTE Views Advanced Topics Functions, Stored Procedures, Packages Pivoting data: CASE & PIVOT syntax Hierarchical Queries Cursors: Implicit and Explicit Triggers Dynamic SQL Materialized Views Query Optimization: Indexes Query Optimization: Explain Plans Query Optimization: Profiling Data Modelling: Normal Forms, 1 through 3 Data Modelling: Primary & Foreign Keys Data Modelling: Table Constraints Data Modelling: Link/Corrollary Tables Full Text Searching XML Isolation Levels Entity Relationship Diagrams (ERDs), Logical and Physical Transactions: COMMIT, ROLLBACK, Error Handling

    Read the article

  • Oracle's ODF Plug-in Pricing: What's up with That?

    <b>Standards Blog:</b> "It does leave open one tantalizing question though, that's harder to read: does the decision to charge for the plug-in indicate that Oracle is taking its ODF-compliant office suite unit seriously as a money maker, and plans to put serious resources behind it..."

    Read the article

  • Microsoft Promises Plenty of Surprises for E3 2010, with Project Natal Headlining the Show

    With the E3 Expo 2 1 just around the corner there is plenty of buzz circling around what Microsoft will bring to the table. This tech-driven three-day event takes place this year on June 15 16 and 17 at the Los Angeles Convention Center. Fans of Microsoft as well as their competitors will likely be waiting with anticipation as to what Microsoft plans to introduce to the world.... Microsoft BPOS - $10 Per User Per Month* *Includes a 12-month subscription. Minimum 5 seats required.

    Read the article

  • Microsoft`s SkyDrive Abandons Silverlight

    SkyDrive Microsoft s cloud storage service has just received a hefty makeover that has its users as well as Silverlight developers talking. SkyDrive s site is new and improved and is successful in providing a better user experience but the changes may have some Silverlight developers feeling a bit worried when it comes to Microsoft s future plans for their beloved framework.... Display the VeriSign seal And increase sales by an average of 24%. Start your trial today

    Read the article

  • When will the Unity Greeter begin to look like the propositions from the Design Team?

    - by Marcappuccino
    The Canonical Design Team gave a rather beautiful login screen mockup for the unity greeter. These designs, in my opinion far exceed the current UI that we have for Quantal (which I think is worse, apart from remote login), and I was led to beleive that these were the official guidelines for the greeter. Are there plans to implement these designs into the Unity Greeter? The proposal is here: https://docs.google.com/a/canonical.com/document/d/1ypvxcSmwNKKMZawit-0r6uLnbTxoA-XoyB0ZNCKNMSg/edit?pli=1 The mockups are here: https://docs.google.com/a/canonical.com/file/d/0BzP7juF4TDpQS3JCWmtHTmR6OVk/edit?pli=1

    Read the article

  • Using a PowerShell Script to delete old files for SQL Server

    Many clients are using custom stored procedures or third party tools to backup databases in production environments instead of using database maintenance plans. One of the things that you need to do is to maintain the number of backup files that exist on disk, so you don't run out of disk space. There are several techniques for deleting old files, but in this tip I show how this can be done using PowerShell.

    Read the article

  • Real Time Search and Applications

    Several companies want to improve their real time search practice. The most popular search engine Google also has plans to improvise on this area and has launched a real time search. But what exactly does this buzzword mean?

    Read the article

  • AMD to Introduce Netbook Chip in 2011

    <b>Hardware Central:</b> "Advanced Micro Devices plans to release a processor in its "Fusion" line that will be positioned for the netbook market, putting it in competition with the Intel Atom, and, to a lesser degree, the ARM processor."

    Read the article

  • An SEO Service Provider is a Must For Content Creation

    Anyone who plans on making any search engine optimizing (SEO) changes to their website should consider hiring an Internet marketing company who will know precisely how to create keywords that will attract a lot of traffic to your website. This will, in turn, increase your sales. Of course, you will need to be happy with these keywords before the person whom you hire will create highly effective, original, and unique content for your website.

    Read the article

  • Dental SEO Bolsters the Popularity of Dental Care Insurance Coverage

    The benefits of dental insurance have been even more stressed upon by the well-known icons on television, who constantly seem to have flashing white flawless pearly whites. These types of teeth are caused by proper care, expensive dental consideration and therefore the need for costly group dental insurance plans offered by insurance providers that decrease in number by the day.

    Read the article

  • Enterprise Planning - Part 2

    Today's networked and fast-changing economy challenges traditional spreadsheets and department-oriented planning mechanisms. To be competitive, effective planning needs to connect the organizational value chain in an integrated manner. In this podcast hear about how Oracle's Enterprise Business Planning solutions are enabling organizations to link their strategic, financial, and operational plans to achieve both vertical and horizontal alignment.

    Read the article

  • Shuttleworth: Linaro: Accelerating Linux on ARM

    <b>LWN.net:</b> "Mark Shuttleworth posts his thoughts about Linaro. Canonical will be working closely with the project, which has plans for six-month release cycles like Ubuntu. Linaro will also be using some Ubuntu infrastructure such as LaunchPad"

    Read the article

  • Intel lance un concours de création d'applications pour sa caméra 3D RealSense, avec plus d'un million de dollars US à se partager

    Intel lance un concours de création d'applications pour sa caméra 3D RealSense, avec plus d'un million de dollars US à se partager Mise à jour du 18/08/2014Intel annonce l'édition 2014 de son concours Perceptual Computing App Challenge articulé autour de sa technologie RealSense. Pour rappel, sa caméra 3D RealSense a été présentée comme étant son premier produit « d'informatique perceptuelle » et embarque entre autre un système de reconnaisse faciale, vocale, la suppression des arrières plans,...

    Read the article

  • [LINQ] Master &ndash; Detail Same Record(II)

    - by JTorrecilla
    In my previous post, I introduced my problem, but I didn’t explain the problem with Entity Framework When you try the solution indicated you will take the following error: LINQ to Entities don’t recognize the method 'System.String Join(System.String, System.Collections.Generic.IEnumerable`1[System.String])’ of the method, and this method can’t be translated into a stored expression. The query that produces that error was: 1: var consulta = (from TCabecera cab in 2: contexto_local.TCabecera 3: let Detalle = (from TDetalle detalle 4: in cab.TDetalle 5: select detalle.Nombre) 6: let Nombres = string.Join(",",Detalle ) 7: select new 8: { 9: cab.Campo1, 10: cab.Campo2, 11: Nombres 12: }).ToList(); 13: grid.DataSource=consulta;   Why is this error happening? This error happens when the query couldn’t be translated into T-SQL. Solutions? To quit that error, we need to execute the query on 2 steps: 1: var consulta = (from TCabecera cab in 2: contexto_local.TCabecera 3: let Detalle = (from TDetalle detalle 4: in cab.TDetalle 5: select detalle.Nombre) 6: select new 7: { 8: cab.Campo1, 9: cab.Campo2, 10: Detalle 11: }).ToList(); 12: var consulta2 = (from dato in consulta 13: let Nombes = string.Join(",",dato.Detalle) 14: select new 15: { 16: dato.Campo1, 17: dato.Campo2, 18: Nombres 19: }; 20: grid.DataSource=consulta2.ToList(); Curiously This problem happens with Entity Framework but, the same problem can’t be reproduced on LINQ – To – SQL, that it works fine in one unique step. Hope It’s helpful Best Regards

    Read the article

  • Boost Your SEO Campaign With Link Building

    Search engine optimization experts often emphasize the significance of link building in increasing your website's popularity. If you have been paying a lot of attention to your SEO plans of late, integration of sound link building will make a world of a difference in your website's traffic volumes. What you have to understand is that popular search engines only show web pages from sites which according to their criteria are more important.

    Read the article

  • Best approach for tracking dependent state

    - by Pace
    Let's pretend I work on a project tracking application. The application is a database backed, server hosted, web application. In this application there are Projects which have many Activities which have many Tasks. A Task has two date fields an originalDueDate and a projectedDueDate. In addition, there are dynamic fields on the Activities and the Projects which indicate whether the Activity or Project is behind schedule based on the projected due dates of the child tasks and various other variables such as remaining buffer time, etc. There are a number of things that can cause the projectedDueDate to change. For example, an employee working on the project may (via a server request) enter in a shipping delay. Alternatively, a site may (via a server request) enter in an unexpected closure. When any of these things occur I need to not only update the projectedDueDate of the Task but also trigger the corresponding Project and Activity to update as well. What is the best way to do this? I've thought of the observer pattern but I don't keep a single copy of all these objects in memory. When a request comes in, I query the Task in from the database, at that point there is no associated Activity in memory that would be a listener. I could remove the ability to query for Tasks and force the application to query first by Project, then by Activity (in context of Project), then by task (in context of Activity) adding the observer relationships at each step but I'm not sure if that is the best way. I could setup a database event listening system so when a Task modified event is dispatched I have a handler which queries for the Activity at that point. I could simply setup a two-way relationship between Task and Activity so that the Task knows about the parent Activity and when the Task updates his state the Task grabs his parent and updates state. Right now I'm stuck considering all the options and am wondering if any single approach (doesn't have to be a listed approach) is jumping out at others as the best approach.

    Read the article

  • Microsoft Patch Tuesday Promises Critical Updates

    Microsoft revealed some plans last week for its upcoming Patch Tuesday release that should keep IT professionals busy. The latest Patch Tuesday falls on June 14 and it will bring with it 16 bulletins from Microsoft focused on fixing 34 vulnerabilities that stretch across several of the company s products.... Microsoft? Windows Azure Host, Scale, and Manage Web Apps In The Cloud. Learn More About Azure.

    Read the article

  • Need help for array when no checkbox is selected [closed]

    - by darlene
    Hi guys I have created a form that has checkboxes, the code works great when a checkbox is selcted however when no checkboxes are selected I get errors such as "Undefined index: onemon in and Warning: Invalid argument supplied for foreach()" Please help:) FORM 1. Had a cold, fever or headache? input type="checkbox" name="onemon[]" value="q1" if(isset($_GET['onemon']) && $_GET['onemon']= "q1") 2. Had dental extractions or teeth cleaning? input type="checkbox" name="onemon[]" value="q2" if(isset($_GET['onemon']) && $_GET['onemon']= "q2") 3. Had minor outpatient sugery? input type="checkbox" name="onemon[]" value="q3" if(isset($_GET['onemon']) && $_GET['onemon']= "q3") 4. Had any vaccines? input type="checkbox" name="onemon[]" value="q4" if(isset($_GET['onemon']) && $_GET['onemon']= "q4") PHP $date = date('Y-m-d'); $onemon = $_POST ['onemon']; { $con = mysql_connect("localhost","root","") or die ("Could not connect to DB Server"); $db_selected = mysql_select_db("nbtsdb", $con) or die("Could not locate the DB"); // You have to loop through the array of checked box values ... $ques=""; foreach($onemon as $entry){ $ques .= $entry.","; } //$addPersonalSql holds the insert SQL query string $query = "INSERT INTO defferal(defid, intdate, onemonth) VALUES('','$date','$ques')"; $addMemberSql = $query or die ("Unable to Insert Data into defferal Table"); mysql_query($addMemberSql); }

    Read the article

  • Patch Tuesday Fixes, Valentine`s Scams

    Microsoft plans to release nine bulletins on Tuesday that cover 21 vulnerabilities across its wide portfolio of products. Of the nine bulletins, four have been tagged with the software giant's critical rating, meaning they should be given the utmost importance with regard to the overall patching process exercised by users and organizations. The four critical updates address vulnerabilities in Microsoft's Internet Explorer browser, its Windows operating system, and Silverlight. As for the remaining five updates, Microsoft has labeled them as being important. Those will cover issues foun...

    Read the article

  • Intel to Unleash Atom-ic Power at Computex

    <b>Hardware Central:</b> "Intel plans to introduce a series of new Atom processors at the opening of the giant Computex show in Taipei this week, as well as offer a preview a number of other offerings. But Atom will be the star of the show."

    Read the article

< Previous Page | 303 304 305 306 307 308 309 310 311 312 313 314  | Next Page >