HI Gial

I am planning to cache this on Java, this is the requriment, Basically i need to check wether...

Hi Gila

I found a work around, but iam facing error, the work around is

select * from OpenRowset (...

Hi Mana

Use BCP this is the best option if there are large number of rows,...

Hi Nili

Try giving more fill factor, fill factor affects scan as well, since it has to scan more pages, i...

Hi Lynn

If i am right, u are using a VPN tunnel to link to datacentre, check the VPN tunnel, is there...

i tought of that as well Jacob, i am using a HP server, there is a monitoring system used by HP Servers and i am having a warm spare on...

Hi Sri

What version of SQL are u using and please provide ur server details(both DB and reporting), so we can...

Thanks Jacob / Steve

Yes this are Lun's with seperate disks, and i have tried RAID1 earlier...

HI All

I have migrated all our machines into VM ware (Produciton, testing and developement) and its been running fine for last 8...

HI Pong

I had the same problem with one of my servers, i checked all codes, there was a new SP that started...

Thats what i do for some operations Eric, but there is still a problem in accessing data, say last week i had a problem to copy 100K rows into a...

Hi Jamie

You can use the XP to get drive and space information and the put that into a job on SQL server,...

From what point the size is growing, mdf or ldf, since log files grows with differential backups, and check the recovery mode, change it to simple and then shrink the...

Is there any article that we can read to understand how linked server works on 2005, hope we can get some answers from that, and try to improve performance

I am facing the same problem as well, i got a small number of records and when i can retrive the records from a linked server using Joins, it takes...