Buffer Cache hit ratio is 99.866 Page life expectancy says 201860. Am I reading that wrong?
I did notice later in the day that Windows showed over 6GB of RAM used, and the sqlservr.exe process still showed about 140MB. I figured something...
Hello, We recently upgraded both our hardware and our SQL software. Our old server had a single quad-core processor, 4GB of RAM, Server 2003 32 bit,...
You mean the Microsoft tool that doesn't come with SQL 2005 Express or were you referring to something else?
Thanks for the replies. I actually downloaded this one a while ago: http://sqlprofiler.googlepages.com/ I was having trouble figuring out which...
Are there any good alternatives to the profiler that comes with SQL server? With Visual Studio, you get the Express Edition of SQL, so you don't have...
So, which SQL data type is the equivalent of a double in .NET?
We are using SQL 2005, but compatibility mode is for SQL 2000 for this particular database. I suppose that could make a difference. I wish I knew...
Hello, In my database, I have some float fields and our application inserted some rows with "infinity" as the value for these columns. Now we have...
Separate names with a comma.
