Search Results

Search found 28930 results on 1158 pages for 'sql ce'.

Page 862/1158 | < Previous Page | 858 859 860 861 862 863 864 865 866 867 868 869  | Next Page >

• Nouvelle version majeure du plugin PHP Documentation pour Google Chrome, elle intègre l'auto-complétion

  Vous connaissez surement le plugin Documentation PHP pour Google Chrome ? Pour rappel, c'est une extension qui permet de rechercher une fonction directement dans le manuel de PHP depuis Google Chrome. En ce jour de l'an, une nouvelle version majeure vient de voir le jour. Elle intègre les 2 fonctionnalités suivantes : La recherche contextuelle : Permet de lancer une recherche depuis une page web en faisant un clique-droit sur un nom de fonction. L'auto-complétion : Permet de simplifier la recherche dans la documentation php en suggérant des noms de fonctions lors de la saisie. Une extension bien pratique pour les développeurs PHP.

  Read the article

• Rules of Holes #5: Seek Help to Get Out of the Hole

  - by ArnieRowland

  You are moving along, doing good work, maintaining a steady pace. All seems to be going well for you. Then BAM!, a Hole just grabbed you. How the heck did that happen? What went wrong? How did you fall into a Hole? Definitely, you will want to do a post-mortem and try to tease out what misteps led you into the Hole. Certainly you will want to use this opportunity to enhance your Hole avoidance skills. But your first priority is to get out of this Hole right NOW.. Consider the Fifth Rule of Holes...(read more)

  Read the article

• Connect Digest : 2012-07-06

  - by AaronBertrand

  I've filed a few Connect items recently that I think are important. In #752210 , I complain that the documentation for DDL triggers suggests that they can prevent certain DDL from being run, which is not the case at all. http://connect.microsoft.com/SQLServer/feedback/details/752210/doc-ddl-trigger-topic-suggests-that-rollbacks-run-before-action In #745796 , I complain that scripting datetime data in Management Studio yields output that contains a binary representation instead of a human-readable...(read more)

  Read the article

• Windows Not Sleeping All Night

  - by John Paul Cook

  Having a computer wake up when you don’t want it to wastes electricity and drains the battery on mobile devices. My desktop had been waking up at night, so I assumed it was some network traffic on my home network. I unchecked Allow this device to wake the computer on my network adapters . Figure 1. Network adapter Power Management tab. That didn’t solve the problem. I included the screen capture in Figure 1 because it could be part of the solution for someone else. To identify the root cause instead...(read more)

  Read the article

• 24 Hours of PASS next week, pre-con preview style

  - by drsql

  I will be doing my Characteristics of a Great Relational Database , which is a session that I haven’t done since last PASS. When I was asked about doing this Summit Preview version of 24 hours of PASS, I decided that I would do this session, largely because it is kind of light and fun, but also because it is either going to be the basis of the end section of my pre-con at the summit or it is going to be the section of the pre-con we don’t get to because we are so involved in working out designs that...(read more)

  Read the article

• High memory utilization by sqlservr.exe process

  - by abdul samad

  Sub:High memory utilization by sqlservr.exe process. When I look into task manager --processes or by using perfmon memory counters(Sqlserver:memory manager:Target server memory and Total server memory) I am getting high memory utilization by sqlservr.exe process nearly 8 GB (Target server memory counter) and 7.95 GB (Total server memory). and when I restart the MSSQLSERVER service it again shoots up to the same size. I am getting this issue quite frequently. Please help me out in identifying why sql server is using so much memory and how to find out what query , stored procedure etc is making sql server use that much memory. * I am not using any triggers or cursors in my code. Thanks

  Read the article

• Sortie de VirtualBox 3.1.6, une mise à jour mineure qui montre l'implication d'Oracle dans la soluti

  Mise à jour du 30/03/10 Mise à jour mineure pour VirtualBox La version 3.1.6 montre cependant l'implication d'Oracle dans la solution de virtualisation de Sun VirtualBox 3.1.6 vient de sortir. Rien de bien nouveau au programme si ce n'est une stabilité légèrement améliorée et la correction de plusieurs bugs. La virtualisation des distributions Linux a également été au centre des efforts des équipes de développement. Bref, il s'agit d'une mise à jour mineure. Mais qui envoie un message majeure. La solution de virtualisation de Sun continue de bénéficier du support du nouveau propriétaire de la soc...

  Read the article

• Execution plan warnings–All that glitters is not gold

  - by Dave Ballantyne

  In a previous post, I showed you the new execution plan warnings related to implicit and explicit warnings.  Pretty much as soon as i hit ’post’,  I noticed something rather odd happening. This statement : select top(10) SalesOrderHeader.SalesOrderID, SalesOrderNumberfrom Sales.SalesOrderHeaderjoin Sales.SalesOrderDetail on SalesOrderHeader.SalesOrderID = SalesOrderDetail.SalesOrderID   Throws the “Type conversion may affect cardinality estimation” warning.     Ive done no such conversion in my statement why would that be ?  Well, SalesOrderNumber is a computed column , “(isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID],0),N'*** ERROR ***'))”,  so thats where the conversion is.   Wait!!! Am i saying that every type conversion will throw the warning ?  Thankfully, no.  It only appears for columns that are used in predicates ,even if the predicate / join condition is fine ,  and the column is indexed ( and/or , presumably has statistics).    Hopefully , this wont lead to to many wild goose chases, but is definitely something to bear in mind.  If you want to see this fixed then upvote my connect item here.

  Read the article

• La multiplication anarchique des applications est un problème majeur pour 74 % des DSI, les applications sous-utilisées aussi, d'après HP

  La multiplication anarchique des applications est un problème majeur Pour 74% des DSI, les applications sous-utilisées aussi, d'après HP HP vient de publier une étude qui montre que la multiplication anarchique des applications est un problème majeur des organisations européennes. Un problème qui accapare, pour la maintenance, des ressources qui pourraient être mieux consacrées et allouées à l'innovation. Deuxième conclusion de ce rapport, un DSI européen sur deux estime être empêché par les métiers de conduire des initiatives de modernisation des applications, par crainte des risques associés au changement. D'après cette étude, les portefeuilles applicatifs sont en...

  Read the article

• PowerPivot FILTER condition optimizations

  - by Marco Russo (SQLBI)

  In the comments of a recent post from Alberto Ferrari there was an interesting note about different performance related to the order of conditions in a FILTER call. I investigated about that and Jeffrey Wang has been so nice to give me some info about actual implementation that I can share on a blog post. First of all, an important disclaimer: PowerPivot is intended to make life easier, not requiring the user to think how to write the order of elements in a formula just to get better performance....(read more)

  Read the article

• TechEd 2010 Day Four: Learning how to help others learn

  - by BuckWoody

  I do quite a few presentations, and teach at the University of Washington, and also teach other classes. But I'm always learning from others how to help others learn. At events like TechEd I have access to some of the best speakers around, so I try to find out what they do that works. I attended a great session by allen White, in which he demonstrated a set of PowerShell scripts. He said that Dan Jones of the Microsoft Manageability team told him while he demonstrated a script he needed to provide some visual way to represent the process. Allen used one of the oldest visualizations around - a flowchart. It was the first time I'd seen one used to illustrate a PowerShell script, and it was very effective. I'm totally stealing the idea. All of us are teachers - we help others on our team understand what we're up to. Make sure you make notes for what you find effective in dealing with you, and then meld that into your own way of teaching. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

  Read the article

• Ouverture officielle du forum d'entraide sur la programmation des systèmes embarqués

  Nous avons le plaisir de vous annoncer la création du forum programmation système embarqué. Le but de ce forum est de regrouper les sujets liés à l'embarqué et aux problématiques bas niveau. Il s'agit donc globalement de la frontière logiciel / matériel pour laquelle il est bien souvent difficile de savoir où poser sa question sur DVP. Voici donc une liste non exhaustive de sujets que nous pouvons traiter : Développement sur microcontrôleurs (PIC, ATMEL, Arduino, ...) (MPLAB - AVR-GCC / AVR Dude) Développement sur processeurs ARM, Intel, MIPS, Power PC, ... Développement sur DSP Développement sur FPGA / VHDL Utilisation de cartes de développement ARM (Beagle Board, Fox Board, Panda Board, ...) Développement Linux e...

  Read the article

• Am I the only one this anal / obsessive about code? [closed]

  - by Chris

  While writing a shared lock class for sql server for a web app tonight, I found myself writing in the code style below as I always do: private bool acquired; private bool disposed; private TimeSpan timeout; private string connectionString; private Guid instance = Guid.NewGuid(); private Thread autoRenewThread; Basically, whenever I'm declaring a group of variables or writing a sql statement or any coding activity involving multiple related lines, I always try to arrange them where possible so that they form a bell curve (imagine rotating the text 90deg CCW). As an example of something that peeves the hell out of me, consider the following alternative: private bool acquired; private bool disposed; private string connectionString; private Thread autoRenewThread; private Guid instance = Guid.NewGuid(); private TimeSpan timeout; In the above example, declarations are grouped (arbitrarily) so that the primitive types appear at the top. When viewing the code in Visual Studio, primitive types are a different color than non-primitives, so the grouping makes sense visually, if for no other reason. But I don't like it because the right margin is less of an aesthetic curve. I've always chalked this up to being OCD or something, but at least in my mind, the code is "prettier". Am I the only one?

  Read the article

• How to change password schema for Dovecot user authentication for an already existing mail server

  - by deb_lrnr

  Hello, I have an email server setup on Debian Lenny with Postfix, Dovecot, SASL and MySQL. Currently, the password scheme in my dovecot-sql.conf file is set to: CRYPT default_pass_scheme = CRYPT I would like to globally change the scheme to something stronger like SSHA, or MD5-CRYPT and re-hash all passwords with SSHA. What is the best way to do this? The Dovecot wiki mentions how passwords that don't follow the default scheme defined in dovecot-sql.conf can be prefixed with "{ssha}password", but I couldn't see anything regarding changing an already-existing scheme to a new one for all passwords that are already in the database. Thanks for your help!

  Read the article

• Why is my query soooooo slow?

  - by geekrutherford

  A stored procedure used in our production environment recently became so slow it cause the calling web service to begin timing out. When running the stored procedure in Query Analyzer it took nearly 3 minutes to complete.   The stored procedure itself does little more than create a small bit of dynamic SQL which calls a view with a where clause at the end.   At first the thought was that the query used within the view needed to be optimized. The query is quite long and therefore easy to jump to this conclusion.   Fortunately, after bringing the issue to the attention of a coworker they asked "is there a where clause, and if so, is there an index on the column(s) in it?" I had no idea and quickly said as much. A quick check on the table/column utilized in the where clause indicated indeed there was no index.   Before adding the index, and after admitting I am no SQL wiz, I checked the internet for info on the difference between clustered and non-clustered indexes. I found the following site quite helpful OdeToCode. After adding the non-clustered index on the column, the query that used to take nearly 3 minutes now takes 10 seconds! Ah, if only I'd thought to do this ahead of time!

  Read the article

• Fuite d'une vidéo de Windows Phone 8.1, l'OS apportera un nouveau centre de notifications, des changements de l'IU et le support du quad-core

  Fuite d'une vidéo de Windows Phone 8.1 la mise à jour apportera un nouveau centre de notifications, des changements pour l'IU et le support des puces quad-coreMicrosoft va apporter à ses produits une série de mises à jour majeures connue sur le nom de « Blue ».Si Windows 8.1, la mise à jour pour Windows 8 a été confirmée et quelques nouveautés pour l'OS ont été dévoilées, le floue règne encore sur la mise à jour pour l'OS mobile Windows Phone 8.1.Une fuite d'une vidéo d'un smartphone Nokia 920 lève le voile sur les améliorations qu'apportera l'OS, notamment en ce qui concerne l'interface utilisateur et le centre de notifications.L'écran de démarrage de l'OS dans la vidéo présente un nou...

  Read the article

• Le parti pirate vogue vers les législatives, et propose une campagne "libre et open-source", voterez-vous pour le parti en juin ?

  Le parti pirate vogue vers les législatives À un moment où tout le monde à les yeux rivés vers les élections présidentielles, les pirates regardent déjà plus loin vers l'horizon et scrutent les élections législatives de juin prochain. Leur objectif ? Obtenir leur premier siège à l'Assemblée nationale. Mais en premier lieu, le but du parti est de faire connaître leurs idées et d'amener des débats souvent ignorés par les autres partis. Siéger à l'Assemblée nationale serait l'idéal pour se faire entendre de la sphère politique. Mais, et c'est tout aussi important, les idées doivent aussi être entendues par les citoyens. C'est aussi dans ce but que les pirates ont mis en ligne un

  Read the article

• Les certifications bêtas de .NET 4.0 sont disponibles, elles seront gratuites entre le 5 et le 30 Av

  Les certifications bêtas de .NET 4.0 sont disponibles Elles seront gratuites entre le 5 et le 30 Avril Un petit billet pour vous informer de la disponibilité des nouvelles certifications sur la version 4 du Framework .NET. Et la cerise sur le gâteau : entre le 5 et le 30 Avril, c'est gratuit ! Ce sont des certification en version bêta, mais pas d'inquiétude : en cas de succès, elle seront aussi valides que la version finale. Ces certifications ne sont toutefois disponibles qu'en Anglais pour le moment. Exam 71-511, TS: Windows Applications Development with Microsoft .NET Framework...

  Read the article

• StreamInsight Now Available Through Microsoft Update

  - by Roman Schindlauer

  We are pleased to announce that StreamInsight v1.1 is now available for automatic download and install via Microsoft Update globally. In order to enable agile deployment of StreamInsight solutions, you have asked of us a steady cadence of releases with incremental, but highly impactful features and product improvements. Following our StreamInsight 1.0 launch in Spring 2010, we offered StreamInsight 1.1 in Fall 2010 with implicit compatibility and an upgraded setup to support side by side installs. With this setup, your applications will automatically point to the latest runtime, but you still have the choice to point your application back to a 1.0 runtime if you choose to do so. As the next step, in order to enable timely delivery of our releases to you, we are pleased to announce the support for automatic download and install of StreamInsight 1.1 release via Microsoft Update starting this week. If you have a computer: that is subscribed to Microsoft Update (different from Windows Update) has StreamInsight 1.0 installed, and does not yet have StreamInsight 1.1 installed, Microsoft Update will automatically download and install the corresponding StreamInsight 1.1 update side by side with your existing StreamInsight 1.0 installation – across all supported 32-bit and 64-bit Windows operating systems, across 11 supported languages, and across StreamInsight client and server SKUs. This is also supported in WSUS environments, if all your updates are managed from a corporate server (please talk to the WSUS administrator in your enterprise). As an example, if you have SI Client 1.0 DEU and SI Server 1.0 ENU installed on the same computer, Microsoft Update will selectively download and side-by-side install just the SI Client 1.1 DEU and SI Server 1.1 ENU releases. Going forward, Microsoft Update will be our preferred mode of delivery – in addition to support for our download sites, and media based distribution where appropriate. Regards, The StreamInsight Team

  Read the article

• SIMD Extensions for the Database Storage Engine

  - by jchang

  For the last 15 years, Intel and AMD have been progressively adding special purpose extensions to their processor architectures. The extensions mostly pertain to vector operations with Single Instruction, Multiple Data (SIMD) concept. The motivation was that achieving significant performance improvement over each successive generation for the general purpose elements had become extraordinarily difficult. On the other hand, SIMD performance could be significantly improved with special purpose registers...(read more)

  Read the article

• Dreaded SQLs

  - by lavanyadeepak

  Dreaded SQLs We used to think that a SQL statement without a where clause is only dangerous right since running that on a server TSQL is just going to impact the entire table like waving the magic wand. For that reason we should cultivate the habit first to write the statement as select and then to modify the select portion as update. Within the T-SQL Window, I would normally prefer the following first: select * from employee where empid in (4,5) and then once I am satisfied with the results, I would go ahead with the following change: --select * delete from employee where empid in (4,5) Today I just discovered another coding horror. This would typically be applicable in a stored procedure and with respect to variable nomenclature. It is always desirable to have a suitable nomenclature for parameters distinct from the column names and internal variables. This would help quicker debugging of the stored procedures besides enhancing the readability. Else in a quick bout of enthusiasm a statement like   if (@CustomerID = @CustomerID) [when the latter is intended to denote the column name and there is a superflous @ prepended], zeroing in on the problem would be little tricky. Had there been a still powerful nomenclature rules then debugging would have been more straight-forward and simpler right?

  Read the article

• La Libye coupe ses accès Internet, certains craignent l'indisponibilité des URL réduites de bit.ly

  La Libye coupe ses accès Internet, certains craignent l'indisponibilité des URL réduites de bit.ly On ne rigole plus en Libye. Le pays, soulevé depuis quelques jours par les opposants au régime politique en place, est de plus en plus agité. Face à cela, le pouvoir libyen craint de voir arriver la même issue qu'en Egypte. Aussi, depuis vendredi, le réseau social Facebook n'est plus accessible dans le pays. Mais ce n'est pas tout. Muammar Kadhafi a également demandé une coupure de l'Internet local, et le dirigeant ne s'adresse plus aux médias. Puis, la Toile a été accessible par intermittences : quelques fois, les sites sont lents, d'autres fois, ils sont inaccessibles. Apparemment, une embellie aurait...

  Read the article

• setting up a private network using linksys router

  - by user287745

  scenerio:- a database server running sql server 2005 and sql server management studio 2005 express editions a web server running IIS 5.0v using windows xp pro. two other computer having windows xp and windows 98 i have a linksys router which i use to access point for wireless (laptop) there are 5 sockets behind it four for clients and one for internet. i would like to setup a LAN- something like a private hosting area with two clients. would should i do? where to connect what and what would the changes in settnigs be. right now it uses dhcp or something to assign ips. where will the webserver be attached to the internet socket? where will the db server be attached? any guide, links, help thank you

  Read the article

• The EXECUTE permission was denied on the object

  - by Derek Dieter

  This error is pretty self explanatory. If you are here, I’m sure you simply want to know how to correct it, so here goes. The user context in which you are executing does not have the rights to execute the procedure or function. So first, in order to find out which user you are, [...]

  Read the article

• Ikoula : 500 serveurs virtuels dédiés offerts, disponibles sur deux configurations et incluent MySQL et SQLServer

  Ikoula : 500 serveurs virtuels dédiés offerts Disponibles sur deux configurations et incluent MySQL et SQLServer Ikoula, leader du Cloud Computing en France propose une promotion limitée sur son offre de serveurs virtuels dédiés. 500 Flex'Servers sont en effet offerts aux premiers inscrits à cette promotion valable jusqu'au 31 janvier prochain, et ce durant 3 mois et sans engagement de durée. [IMG]http://idelways.developpez.com/news/images/flex_image.gif[/IMG] Construits sur une architecture haut de gamme (Dell, Cisco, ...) robuste et performante, les Flex'Servers de iKoula s'adaptent potentiellement à tous les besoins. Le nombre de pro...

  Read the article

< Previous Page | 858 859 860 861 862 863 864 865 866 867 868 869  | Next Page >