Search Results

Search found 32604 results on 1305 pages for 'sql monitor'.

Page 70/1305 | < Previous Page | 66 67 68 69 70 71 72 73 74 75 76 77  | Next Page >

  • SQL Server Full Text Search resource consumption

    - by Sam Saffron
    When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU) Similarly when you perform full text searches, resources are consumed. How can I get a gauge over a 24 hour period of the exact amount of CPU and IO(reads/writes) that fulltext is responsible for, in relation to global SQL Server resource usage. Are there any perfmon counters, DMVs or profiler traces I can use to help answer this question?

    Read the article

  • Delete data from a SQL Server database on a full partition

    - by aleroot
    I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I can do on the database is detach, but i want to remove old data from some tables to save space ... How can I remove old data from the database if SQL Server interface doesn't allow to run queries on it ?

    Read the article

  • SQL Server Logs: missing date ranges

    - by Jeff
    I need to be able to export SQL Server logs into CSV files, which I can easily do with the export function. However in doing so I've noticed there's a range of dates missing from the SQL Server logs in Management Studio, two months actually. I'm wondering where these logs might be found, and if it's possible to reload them so I can view and then export them. They're strictly for informational purposes, but I do need them. Thanks in advance!

    Read the article

  • Batch vs SQL statement

    - by AspOnMyNet
    a) A SQL statement is a single SQL command (for example, SELECT * FROM table1 or SET NOCOUNT ON). A batch on the other hand, is a number of SQL statements sent to the server for execution as a whole unit. The statements in the batch are compiled into a single execution plan. Batches are separated by the GO command So the only difference between SQL statement and a Batch is that each SQL statement is sent to server as a separate unit and thus is compiled separately from other SQL statements, while SQL statements in a Batch are compiled together? b) I assume one of major differences between a stored procedure and a Batch is that stored procedures are precompiled while Batches aren’t? thanx

    Read the article

  • Are there any differences between SQL Server and MySQL when it comes to preventing SQL injection?

    - by Derek Adair
    I am used to developing in PHP/MySQL and have no experience developing with SQL Server. I've skimmed over the PHP MSSQL documentation and it looks similar to MySQLi in some of the methods I read about. For example, with MySQL I utilize the function mysql_real_excape_string(). Is there a similar function with PHP/SQL Server? What steps do I need to take in order to protect against SQL injection with SQL Server? What are the differences between SQL Server and MySQL pertaining to SQL injection prevention? also - is this post accurate? is the escape string character for SQL Server a single quote?

    Read the article

  • Debugging SQL in PGAdmin3 when sql contains variables

    - by Mr Shoubs
    In SQL Server I could copy sql code out of an application and paste it into SSMS, declare & assign vars that exist in the sql and run.. yay great debugging scenario. e.g. (please note I am rust and syntax may be incorrect) declare @x as varchar(10) set @x = 'abc' select * from sometable where somefield = @x I want to do something simular with postgres in pgadmin3 (or another postgres tool, anyy reccomendations?) I realise you can create pgscript, but it doesn't appear to be very good, for example, if I do the equlivent of above, it doesn't put the single quotes around the value in @x, nor does it let me by doubling them up and you don't get a table out after - only text... Currently I have a peice of sql someone has written that has 3 unique varibles in it which are used around 6 times each... So the question is how do other people debug sql this sql EFFICIENTLY, preferably in a simular fashion to my sql server days.

    Read the article

  • Displaying dual monitor screenshot in "dual fullscreen" mode

    - by ohadsc
    Suppose I take a PNG screenshot on a dual monitor system (let's assume for simplicity they are identical), The screenshot will capture both monitors. Now say I want to display that screenshot in an image viewer (windows photo viewer, xnview, etc) at fullscreen - I will then have to choose which monitor to display it on, distorting the image. Is there a way to strech it accross both monitors (aside of changing the windows display mode in the screen configuration window) ? I am using Windows 7 Thanks

    Read the article

  • Testing my new 120 Hz monitor.

    - by D Connors
    I just got a Samsung Syncmaster 2233 at a local store, and it's suppose to reach 120 Hz frequencies. I plan on using it with Nvidia 3D vision later on, but I don't have the hardware for that yet. In the mean time, I just want to test the monitor to see if it's working ok. Obviously, if I set it to 120Hz I can't notice any visual difference compared to 60Hz. So how can I test if the monitor is reaching the higher frequency? Thanks

    Read the article

  • Can i run this monitor ?

    - by akshay
    I am upto buying new Monitor for mine desktop here are some specs.and you please help me choose a better one (an which one will work)? Graphics property of system : Intel(R) 82845G Graphics Controller Memory 64 MB Memory type 2 Driver version 6.13.01.3317 Monitors i think will be good is. Monitor : http://www.google.com/products/catalog?q=viewsonic+22&cid=10503070423897692907&ei=MKj_S5OGCpOgjgSghsX2CA&sa=title&ved=0CAcQ8wIwADgA&os=tech-specs

    Read the article

  • PnP Monitor not detected after reboot

    - by Josef
    My second monitor only works when I first disconnect and then reconnect the DVI cable while Windows is running. If I reboot or sleep and wake up, it stays dark. The other Monitor works fine. I have Windows 7 64 Bit with an ATI HD 4770. Any ideas?

    Read the article

  • Best software to rotate monitor picture 90 degrees

    - by Erik Vold
    What free software, preferably open source, will allow me to rotate the output to my widescreen monitor by 90 degrees? I had some software that came with my monitor to do this, called magiv view or something.. but it conflicted with tortoise svn in the context menu so I had to stop using it. Is there anything else that I can use or do?

    Read the article

  • DVI output to VGA Monitor

    - by Nate
    Am I right in thinking a laptop's female DVI output could be used to plug into a VGA monitor using this adaptor? http://www.nextag.com/Cables-Unlimited-DVI-I-79280721/prices-html?nxtg=d8a0a240511-404B0D198D279591 This would be a 2nd external monitor on a for a laptop's docking station

    Read the article

  • DVI output to VGA Monitor

    - by Nate
    Am I right in thinking a laptop's female DVI output could be used to plug into a VGA monitor using this adaptor? http://www.nextag.com/Cables-Unlimited-DVI-I-79280721/prices-html?nxtg=d8a0a240511-404B0D198D279591 This would be a 2nd external monitor on a for a laptop's docking station

    Read the article

  • What happens if I pierce a TFT monitor?

    - by sharptooth
    What happens if I pierce a TFT monitor screen with something sharp (say a nail)? Will only the pierced region malfunction or the whole monitor screen? There's an opinion that in this case the entire screen will "flow out" (more specifically - "liquid crystals will flow out") and stop working completely. Is that truth or an urban legend?

    Read the article

  • Solution to tack things up on top or to the side of a monitor

    - by Bela
    I'm trying to find some sort of product that would either go on the top or the side of an lcd monitor and give me space to tape/push-pin/post it note things for myself. For random notes and things I want to keep track of, having them on the top/side of my monitor would keep the space on my desk itself clear, and they would be closer to my field of vision. Does something like this exist? Do I need to rig up something myself?

    Read the article

  • Configuring a monitor's contrast/brightess/colours/etc

    - by DMA57361
    I have recently bought myself a new monitor, now I'd had my previous screen well over 5 years now so I'm looking at this one thinking the picture doesn't quite look right (not bad, just different). Rather than just wait until I'm used to the new picture I'd rather get it fine tuned, then get used to it - so I can reap the maximum benefit. So, can you please suggest reliable ways of configuring an LCD monitor's brightness/contrast/colour/etc to provide the optimum possibly quality image?

    Read the article

  • Monitor not displaing windows 7 correctly

    - by rdt
    I have just got a 15" Digimate TFT LCD monitor. I'm running Windows 7. Now the icons are too big, as are the windows in both browsers and word processing software - and everything has a bit to the left cut off, so for instance I can no longer see the back button in Chrome. I've tried looking at the resolution and adjusting the monitor settings, but no luck. I've also tried updating drivers, but can't find any compatible ones.

    Read the article

  • How to dock a window to an inside edge of a dual-monitor setup

    - by Kevin M
    I have a dual monitor setup at work. I am running Windows 7 Ultimate, and I would like to take advantage of the docking feature, whereby you can drag a window to the side of the monitor and have it expand and fill to half the screen. Trouble is, I would like to drag it to the inside edge(adjoining the other screen) and it does not activate. How would I go about activating this for the inside edge?

    Read the article

  • Configuring a monitor's constract/brightess/colours/etc

    - by DMA57361
    I have recently bought myself a new monitor, now I'd had my previous screen well over 5 years now so I'm looking at this one thinking the picture doesn't quite look right (not bad, just different). Rather than just wait until I'm used to the new picture I'd rather get it fine tuned, then get used to it - so I can reap the maximum benefit. So, can you please suggest reliable ways of configuring an LCD monitor's brightness/contrast/colour/etc to provide the optimum possibly quality image?

    Read the article

  • Second portable monitor for a laptop

    - by user2630
    I'm away from my home office fairly regularly but I find it difficult to really settle to productive coding without my custom 4-screen custom built PC. My laptop (a slightly ageing HP Pavilion with a 1440 x 900 display) would really benefit from a portable monitor to plug into the vga port. Is there any suitable products out there which offer an easily luggable lightweight monitor which would fit in my laptop, offer reasonable resolution and response, and significantly enhance my screen real-estate?

    Read the article

< Previous Page | 66 67 68 69 70 71 72 73 74 75 76 77  | Next Page >