Search results for query: *

Thank a lot for your help, that worked nicely! Andshr

Thanks a lot. It does find the latest file, great! But complains that: cannot stat 'filenametocopy': No such file or directory. Funny, it does find filenametocopy right, maybe it's smth with single quotation marks?

Hi: I have a simple task - to copy, in Linux, the latest xml from one folder to another folder (or ftp to another server). Can't find the command to pick up the latest file. Can UNIX gurus help poor Windows guy?

Thanks a lot, we are looking at this possibility...

Hi; We have SQL 2000 Standard Edition running on Windows 2000 Service Pack 4. It doesn’t allow SQL to use all available 4 Gb of RAM, only 2 Gb. Can anyone help to find out which version of Windows 2003 would let SQL to grab 4 Gb of memory?

Hi: Can we install Windows 2000 Advanced Server on top of Windows 2000 Server Serice Pack 4? Or this calls for OS reinstall?

Hi: A Performance Monitor of our SQL Server 2000 PhysicalDisk % Disk Read Time is too high (>100) showing I/O problem (on reads, it seems). Would it help to double RAM from 2 Gb to 4Gb to lighten up reads from a disk? All memory counters, on the other hand, seem to show that buffer has enough...

Thank you all for your answers. Our 12 Gb database is heavily and intelligently indexed. But although our main tables have no more than 1mln records, our stored procedures have 5-8 inner joins in average. We also create temp tables often within sp – do we suffocate tempdb? What values of...

Hi: Would changing (WITH PAGELOCK) to (WITH ROWLOCK) hint in SQL Server 2000 UPDATE/DELETE statements help to reduce concurrent locking? Can UPDATE in general be more granular than a page level lock?

Hi: During working hours, many of our SQL 2000 stored procedures run 3-5 times longer than on idle server. Sometimes you can see blocking, but more often not. CPU at 60-80%. Buffer cache hit ratio –99.98%. Would having 8 virtual CPU’s instead of 4 real ones (provided we’d upgrade to Windows...