|
The Truth about "Cursor Busting" in SQL
2008-06-05 16:56:00 Let's say you are called in to troubleshoot a stored procedure that is performing poorly. You dive in to investigate and this is what you find: create procedure ProcessProducts as declare @Products cursor, @ProductID int set @Products = cursor for select ProductID from Products order by ProductID open @Products fetch next from @Products into @ProductID while (@@FETCH_STATUS=0) begin fetch next from @Products into @ProductID exec DoSomething @ProductID end deallocate @Products Ah ha! A cursor! It seems we have identified the bottleneck: Clearly, the performance problems are because the code is not doing things in a set-based manner, but rather by processing rows one at a time using a dreaded cursor. This cursor is opening up the Products table, looping through the rows one at a time, and calling the "DoSomething" stored procedure for each ProductID. As we all know, cursors are not the way to go when writing SQL code; ...
Move the mouse cursor out of the way with MouseAway
2008-06-04 13:29:00 Often when you type, the mouse cursor gets in your way and obscures your text. This tiny application called MouseAway was created just for solving this issue. MouseAway checks if your mouse pointer is near your keyboard pointer. If they are too close, MouseAway will move the mouse pointer away so that you can see where you type. See the animation below. MouseAway is extremely light and takes just 40KB when running. [via LifeHacker] ...
By: Instant Fundas
I cant boot to Windows xp.....black screen with blinking cursor
2008-04-25 11:16:00 Hello friends..... i was a user of old intel 845GVSR motherboard....now before some days i brought a Intel D102GGC2 (1GB DDR2) motherboard...i started it with my old seagate 250 gb Hd.....i just want to start it in Safe mode coz i know that on my...
By: Fixya.com
Change the Direction of the Cursor.
2008-04-24 12:32:00 Today’s Tip and Trick is another useful Tip and Trick and it has to do with Microsoft Excel. When you are working in a spreadsheet and you hit the Enter key, Excel by default moves the cursor below the one where you’re standing in. If you want to change the direction of the cursor you’ll ...
SQL SERVER - Is Cursor Database Object or Datatype
2008-04-19 03:30:00 It is commonly believed that cursor are Database Objects. I have always given the definition of cursor as SQL Server cursors are database objects used to manipulate data in a set on a row-by-row basis. Just a few days ago - Imran one of the active reader of blog asked me question if cursor is database ...
CursorXP, Cambia tu cursor
2008-04-15 03:46:00 ¿Cansado de la llanura flecha blanca que está el cursor? ¿Quieres añadir alguna jazz y pizzazz a su escritorio? Stardock del CursorXP es un programa que le permite usar y crear increíblemente fresco buscando ratón cursores de Windows. Para ello, aprovechando las nuevas características de los efectos visuales de Windows 2000 y Windows XP… Descarga Exclusiva ...
By: Pica Pollo Chino
How to accurately relocate the cursor in Notes for your iPhone or iPod Touc
2008-04-12 20:40:00 While typing using the Notes application on your iPhone (or jailbroken iPod Touch) sometimes you want to go back and change or correct something. But it can be tricky to ‘tap’ exactly where you want the cursor to go. Here’s a neat trick I just discovered today - tap in the general area you want ...
By: Server Tales
Find Cursor Position in a HtmlText Object (RichTextEditor, TextArea, TextFi
2008-03-26 16:12:00 In the previous article I came out with a function that calculates the position of the cursor in the htmlText which is different than the position in the normal text. Rick draw my attention in his comments to some flaws which are correct: the & and other similar special chars are not counted correctly and ...
[kaiserfive - News und mehr] Firefox- Erweiterung: Link Alert - Cursor- Vo
2008-03-20 00:00:00 Firefox- Erweiterung: Link Alert(quot;Cursor- Vorhersagequot;)Update vom 19. 03. 2008 auf Version 0. 8 Kurzbeschreibung: Diese Firefox- Extension quot;Link Alertquot; verwandelt den Mauscursor in eine Art Indikator, der sich dann je n...
By: BlogNews
Find Cursor Position in a HtmlText Object (RichTextEditor, TextArea, TextFi
2008-03-18 18:39:00 Last task I finished was something linked with templates. I needed to create a simple template engine where adding a field was a necessity. I started using RichTextEditor which is based on a TextArea so it implements htmlText property. That is an easy way having all that nice functionalities like bold, italic, font choosing, color ...
jumping mouse cursor
2008-03-17 23:15:00 my mouse cursor keeps on jumping.i cleaned the mouse thoroughly.but it didn't solve the problem.i have noticed that by keeping the connecting cable in certain positions the mouse starts working just fine.the connection between the mouse and the...
By: Fixya.com
Katmouse - Scroll windows beneath the mouse cursor
2008-03-12 14:08:00 The best programs are the ones you install, forget about and use everyday. These programs integrate so well into the environment that they become part of your work flow. Katmouse is just such a program. Simply put, it allows you to scroll the window beneath the mouse cursor, even if the window does not have input focus. It's a simple behavior that it is instantly useful and requires no memorization to use. I wish there was more to say about it but that's really it. It just works and perhaps that's the best praise anyone can give a program. Highly recommended. powered by Bloget™ - "One File, One Binary, One Blog"
By: Onion Peels
SQL SERVER - Simple Example of Cursor - Sample Cursor Part 2
2008-03-05 02:30:00 I have recently received email that I should update SQL SERVER - Simple Example of Cursor with example of AdventureWorks database. Simple Example of Cursor using AdventureWorks Database is listed here. USE AdventureWorks GO DECLARE @ProductID INT DECLARE @getProductID CURSOR SET @getProductID = CURSOR FOR ...
Cursor 10
2008-02-29 05:08:00 Once again, I have about seven projects I should be working on but am instead focused on the internet. Don’t ask me what’s so addictive about this game, but I don’t foresee myself getting any work done tonight. Thanks, internet!
By: Say No to Crack
Thoughts Control Cursor
2008-02-26 14:39:00 From The Engineer: Essex University researchers are developing a system that could give people completefreedom to move a cursor around a screen using thought alone. The research takes a novel approach to brain computer interfaces (BCI) that gives a person's electroencephalograms
MouseLight - spotlight around your cursor And ScreenLink - draw on screen
2008-02-22 19:10:00 Overview: Sometimes it's difficult to tell an audience to look at a particular area of the screen. Whether its for a product demo, presentation, screencast or a lecture, this problem still exists. MouseLight tries to eliminate this problem. MouseLight puts a "spotlight" around your cursor and dims the surrounding area which enables your audience to effortlessly follow your path of movement on the
Hand Cursor on a Label
2008-02-15 10:27:00 If you have a label and you want to show a hand cursor when the mouse is over it you have to set three properties as bellow: lbl.useHandCursor = true; lbl.mouseChildren = false; lbl.buttonMode = true; where lbl is public var lbl:Label = new Label(); Job's done!
Skipping and Shaking cursor
2008-02-15 06:10:00 My tablet was just fine for the first two months, than all of a sudden it started to get bad. The cursor, whether with pen or mouse, literally shakes and skips rapidly, and makes very jagged lines. Ive reinstalled the driver, checked the balance of...
By: Fixya.com
CSS ile kursör tiplerini de?i?tirin (CSS Cursor Type)
2008-02-08 22:01:00 Css ile web sayfan?zda kursör tipini kendinize göre de?i?tirebilirsiniz.Bunun için yaz?lmas? gereken ?u k?sac?k koddur.Örn:cursor:default(kursö-r tipi); Yanl?z bu kod ile sadece genel kursör tiplerine eri?ebilirsiniz.E?er kendi kursörünüzü kullanmak istiyorsan?z;1-Kursörünüzü bir hosting'e yüklemeniz gerekir.2-Daha sonra ?u kodla bu kursörü kullanabilirsiniz."cursor:url(k-ursör url'si)"Örne?in:Cursor:url(http-://surbas19.googlepages.com/Box-busy.ani) "KÜP KURSÖR"??te bunlarda standart kursör isimleridefaultautocrosshairpoi-ntermovee-resizenw-resizese-res-izesw-resizes-resizetexthelp
By: XML RELATED
Wanna move your cursor without mouse?
2008-02-03 23:19:00 Click Start. Click Run. Type “access.cpl”(withou-t quotes). Click on ‘mouse’ tab. Check ‘use mouse keys’. Click ok. Now make sure that num lock is on. Now try to move the cursor with the numbers on the numeric key pad. That’s Working!!!! U can even move a file with this techinque. Move the cursor on to the file which is to be moved. Hold insert on ...
By: The Cool News
Write or Draw on Your Desktop Using Your Cursor
2008-01-22 13:13:00 I was just thinking how great it could be, instead of having a Vista note gadget on my desktop, if I could just write on the desktop with the cursor. I had never heard of any application that allowed this, so I tried searching in Google and came across two of them. They aren’t exactly ...
Another Great Time Waster? Try And Shake Him Off Your Cursor?
2008-01-21 08:11:00 Crazy Rabbit addthis_url = 'http%3A%2F%2Floscuatroojos.com-%2F2008%2F01%2F21%2Fanother-gre-at-time-waster-try-and-shake-hi-m-off-your-cursor%2F'; addthis_title = 'Another+Great+Time+Waster%26%2-38230%3B+Try+And+Shake+Him+Off+-Your+Cursor%26%238230%3B'; addthis_pub = '';
By: Los Cuatro Ojos
Cursor * 10, corre corre que te pillo
2008-01-09 13:02:00 Se trata de un sencillo juego donde tienes que ir subiendo pisos de un edificio. Tu objetivo es llegar al...
The Real Cursor
2008-01-05 14:22:00 Have you ever wondered how the cursor on the screen follows your orders? Wait while animation loads. Click below in the middle of the frame to activate this funny animation and you will be able to view the poor fellas who move your screen pointer. Notice how they follow your command under the magnifying glass ...
By: memories
Cursor*10, il gioco che rivoluziona la concezione di Single Player
2008-01-04 21:47:00 Ecco un altro giochino in flash molto interessante e divertente. La concezione di gioco “single player“ che offre è totalmente diversa da quella che siamo abituati ad avere. Per la prima volta sei tu stesso che devi far collaborare tra loro più elementi per riuscire nel tuo scopo. Mi spiego in parole più semplici, allora, il gioco consiste ...
Use your head to move the cursor-Hand free mouse?
2008-01-01 14:04:00 Smartnav from naturalpoint shows you how you can use your head to move the cursor on the screen so that you can leave both your hands on the keyboard while maintaining the cursor on screen with your forehead.It uses infra-red(IR) camera to track your head movements and a tiny silverdot placed on your forehead reflect IR light back to the Smart-Nav, which sends instructions to your computer to move your mouse cursor. For mouse clicks, you need to use hotkeys on the keyboard, so it is not completely handsfree yet.See the live demo below.It is basically designed for people suffering from repetitive strain injuries,Carpal Tunnel Syndrome and to the people with physical limitations who need a mouse alternative. Want to try this,visit here
By: Freebies
Sticking Cursor control
2007-12-18 16:08:00 I can not navigate through the menu or any screen because the cursor control button seems to be disconnectd. Have had this problem since new. The only numbers I can find are inside the battery case below the bar code. They are: 0112430043974 0205...
By: Fixya.com
Cursor Run - Game
2007-12-05 03:29:00 function post(id){ if(document.getElementById(id).-style.display==""){ document.getElementById(id).sty-le.display="none";}else{documen-t.getElementById(id).style.disp-lay="";}}É, faz um tempo que não aparece algum jogo por aqui. Costumava postar jogos sempre nas sextas, mas agora com final de ano e provas na faculdade mal sobra tempo pro blog. ;~Cursor Run é simples, com o cursor do mouse tente encostar nos círculos que aparecem, antes que o cursor do jogo encoste. Pronto, falei.. simples não é?Mas não é tão fácil assim, não sei se é o sono, mas não passei do 20º round! loser!Clique na imagem, o jogo abre aqui:
By: Friage
Your Touch Can Scroll The Cursor
2007-11-21 00:00:00 Sometimes some new words denotes the invention of new things while sometimes these are just another name of some another common device. The word computer touch pad may mean two different things. It may either mean the keypad that works as it receives a touch sensation or it may be some another kind of pad ...
El cursor secreto de Microsoft Word
2007-11-11 04:24:00 Este truco funciona en cualquier versión de Microsoft Word incluyendo la 2007. Abre el Word, y presiona CTRL+ALT y la tecla de suma del teclado alfanumérico que está en la parte derecha del teclado. Si observas, aparecerá un nuevo cursor muy curioso, al cuál la verdad no le hallo forma. Si quieres cambiar el cursor al estado normal ...
Measure the distance travelled by your cursor, number of keystrokes & click
2007-11-05 17:42:00 Today a really weird kind of thought came to my mind How do I measure the distance my cursor has traveled?? or whats its speed?? and this made me search for a way to figure it our. I landed upon this tiny nifty utility which really seems to be a really awkward idea. A ...
Cursor in Text Box on Page Load
2007-11-05 17:19:00 Update the site with a feature I should of added a long time ago… the cursor starts in the search box on page load. Now you don’t have to click in the search box after the page loads. Keep on watching streaming Movies and TV-Shows!
Changing the cursor for links that open in a new window
2007-11-05 11:40:00 This is a great little tip to get Firefox to change the style of cursor for links that open in a new window, so you’ll know before clicking them. Click Start > Run, or use the search function in Vista’s Start menu and type %AppData%. Press enter. Navigate to the profile folder (Mozilla > Firefox > Profiles) If ...
By: Get PC Tips
Yahoo Messenger hates my cursor
2007-09-15 09:51:00 I can open my Yahoo Messenger, but it shuts immediately the cursor moves in to the window - yesterday it was ok, today not ok. I have uninstall...
Cursor Invisible
2007-09-13 10:35:00 How many hitz you can make when cursor goes invisible. Simple but interesting game *** Play Game ***
By: Attuworld
Cursor Kite for the geekiest
2007-08-05 22:51:00 This picture of a kite shaped like a mouse pointer looks a little photo-choppy to me but made me laugh when I saw it either way….
By: SlipperyBrick
No Cursor
2007-07-22 07:22:00 When I plug in the usb port for my wireless optical mouse it recognizes that it should be working but then I do not have cursor movement with my mouse. But the built in mouse on my laptop works fine.
By: Fixya.com
jumping mouse cursor
2007-07-11 08:57:00 my mouse cursor keeps on jumping.i cleaned the mouse thoroughly.but it didn't solve the problem.i have noticed that by keeping the connecting cable in certain positions the mouse starts working just fine.the connection between the mouse and the...
By: Fixya.com
Explicit Cursor in Firebird PSQL
2007-07-06 06:30:00 Explicit cursor is a new this in Firebird because it's only available in version 2. We can found this syntax in the release notes on Stored Procedure Language (PSQL) section. The example below is taken from that release notesDECLARE RNAME CHAR(31);DECLARE C CURSOR FOR ( SELECT RDB$RELATION_NAME FROM RDB$RELATIONS );BEGIN OPEN C; WHILE (1 = 1) DO BEGIN FETCH C INTO :RNAME; IF (ROW_COUNT = 0) THEN LEAVE; SUSPEND; END CLOSE C;END Fonte: http://firebird-with-delphi.blo-gspot.com
By: Tips Delphi
Implicit Cursor in Firebird PSQL
2007-07-06 06:30:00 Firebird has an implicit cursor, we can found the example in the example database employee.fdb, and we can find in the "DEPT_BUDGET" stored procedure, lets look into the source, the implicit cursor has the syntax:FOR [select statement] into [local variable that hold the value from select]DOBEGIN [your statement]ENDThe local variable is must defined for each of the field that selected and remember the datatype must be the sameFonte: http://firebird-with-delphi.blo-gspot.com
By: Tips Delphi
PLAY: Cursor Invisible
2007-06-28 04:19:00 The aim of this little Flash game is to shoot the plates which appear on screen. In the first few seconds of the game your cursor, initially visible, will fade from view, leaving you to rely on twitch instincts alone. It seems as if there's no point where you 'win' or level up, but you can try for a better score each time you play.Who knows, it might just be a way to improve your twitch instincts for mouse-based shooters. Let us know if you start climbing up the Deathmatch rankings after this one, eh?[Cursor Invisible]
By: Gamerpunch
PLAY: Cursor Invisible
2007-06-28 04:19:00 The aim of this little Flash game is to shoot the plates which appear on screen. In the first few seconds of the game your cursor, initially visible, will fade from view, leaving you to rely on twitch instincts alone. It seems as if there's no point where you 'win' or level up, but you can try for a better score each time you play.Who knows, it might just be a way to improve your twitch instincts for mouse-based shooters. Let us know if you start climbing up the Deathmatch rankings after this one, eh?[Cursor Invisible]
By: Gamerpunch
Cursor Invisible
2007-06-27 23:29:00 ¿Cuántos blancos serás capaz de acertar sin ver el puntero del ratón?Durante un breve instante podrás ver el lugar donde has disparado y es el único punto de referencia que tendrás hasta que dispares nuevamente.Ten cuidado, solo dispones de 1 vida.Juega Cursor Invisible
How can a cursor move in scrollable result sets?
2007-06-09 21:35:00 JDBC result sets are created with three properties: type, concurrency and holdability.The type can be one of-TYPE_FORWARD_ONLY-TYPE_SCROL-L_INSENSITIVE -TYPE_SCROLL_SENSITIVE. The concurrency can be one of-CONCUR_READ_ONLY-CONCUR_UPDA-TABLE.The holdability can be one of-HOLD_CURSORS_OVER_COMMIT-CLO-SE_CURSORS_AT_COMMIT.JDBC allows the full cross product of these. Some database like SQL 2003 prohibits the combination {TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE}, but this combination is supported by some vendors, notably Oracle.The movable cursors,moving forward and backward on a resultset is one of the new features in the JDBC 2.0 API. There are also methods that let you move the cursor to a particular row and check the position of the cursor.Statement stmt = con.createStatement(ResultSet.T-YPE_SCROLL_SENSITIVE,ResultSet.-CONCUR_READ_ONLY);ResultSet resultSet = stmt.executeQuery("SELECT FNAME, LNAME FROM EMPLOYEE");while (resultSet.next()) { . . . // iterates forward through resultSet } ...
unlock cursor/mouse
2007-06-08 10:34:00 i seem to have locked mt laptop cursor/mouse by mistake and unfortunatly lost my user guide. do you know how i can unlock my cursor/mouse? please help!! thanx, -yasmin
By: Fixya.com
Animated cursor exploit ?drive-by? attacks continue
2007-06-05 16:33:00 ESET announced today that Ani.Gen’s ‘drive-by’ attacks continued during May, placing the trojan in the number one spot of all threats detected for the second month in a row. Constituting 4.6% of all malware activity during May, the trojan exploits how Windows handles animated cursor (.ani) files and requires no action on the user’s part ...
Best cursor design ever
2007-05-29 00:00:00 http://www.1-click.jp/ design interactive people with cursor
By: Technology Blog
El mejor cursor de la historia
2007-05-27 14:22:00 Mueve el ratón y te seguirá a todas partes... Made in Japan. La dirección es: 1-click.jp
Bloquear botón derecho del ratón y Cambiar cursor
2007-05-24 01:42:00 Bloquar boton secundario del mouseEste código te servirá para evitar que usen el botón derecho del raton en tu página web, por lo tanto no podrán copiar ni seleccionar.Pegalo en Vista HTML en tu página web (Entre <html> y </html>)Cambiar el Cursor (puntero del ratón) en tu pagina webCodigo General:Ahora debes hacer lo siguientePara que funcione debes subir tus cursores al hosting donde tienes tus páginas y a este código le cambias la dirección por la del cursor tuyo. (Busca en google por Descargar cursores .cur)Ejemplo:Si tu cursor se llama cursor.cur y lo tienes en la carpeta llamada miscursores y tu web se llama www.tupagina.com, entonces la ruta sería esta:http://wwww.tuapagina.com/-miscursores/cursor.curque en el código quedaría así. Por lo tanto este ? es el código que deberías insertar en tu web.Nota: Solo es un ejemplo! debes seguir los pasos para tener tu código.Nota: Solo es un ejemplo! debes seguir los pasos para tener tu código.Cuando ya hayas subido el curso... |
|
 |
|
 |
