Search Results

I think I found a bug in ISNULL function

Thread by: koenwuyts, Aug 31, 2009, 14 replies, in forum: SQL Server 2008 General Developer Questions

Hi All, We just migrated from SQL 2000 to SQL 2008, and on a specific query I'm getting a strange result, I've already work out the it is related to...

RAM and I/O's and SQL Behaviour

Thread by: koenwuyts, Jul 3, 2009, 2 replies, in forum: SQL Server 2008 Performance Tuning for Hardware

Hi All, A question, will more RAM memory reduce I/O activity on the harddisk? probably relative to the amount of RAM memory. But for instance if I...

Recovery model simple, but still a huge log file

Thread by: koenwuyts, Feb 18, 2009, 5 replies, in forum: General DBA Questions

Hi all, I have a problem with one of my databases. We have set this database to "simple" recovery mode. However the log is still growing, in a week...

New SQL Server Hardware

Thread by: koenwuyts, Jul 8, 2008, 18 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, You probably see this question alot, but I need some advise about new hardware for our SQL Server which is getting slower and slower. Our...

Memory recommendation for SQL Server 2005

Thread by: koenwuyts, Aug 3, 2007, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I have about 20 database running on SQL Server 2000 standard and they have a combined size of 150GB, and do about 300t/s. Currently SQL can...

SQL2000 & Win2003

Thread by: koenwuyts, Oct 24, 2006, 9 replies, in forum: General DBA Questions

Hi All, Does anyone know how much RAM SQL Server 2000 can use when installed on a Windows Server 2003 R2? Only 2 GB are used by SQL Server....