Viewing 15 posts - 1,171 through 1,185 (of 2,496 total)
See Brad McGehee's post at http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx this has some good background material.
October 8, 2009 at 3:12 am
As a minimum, you need to set NTFS security on the Filestream storage location so that only the SQL Server service account can delete files.
If you are not going to...
October 7, 2009 at 4:15 am
What you are doing is putting the string 'C:\test.doc' into the column DATA. You need to put the document into this column.
October 7, 2009 at 2:12 am
Running x64 means that Task Manager will always mis-represent the amount of memory used by SQL.
October 6, 2009 at 3:55 am
If you have AWE turned on, then any memory allocated by the AWE API is termed a 'private memory space' by Windows, and is not shown in Task Manager.
In SQL...
October 6, 2009 at 3:21 am
You may find SQL Server FineBuild useful. The Reference manual has about 50 pages of post-install configuration work that is worth doing.
The aims to get you going with a...
October 6, 2009 at 3:12 am
George has the right solution for removing an unwanted log file. Use Shrinkfile with the Emptyfile option. You will only be able to empty the log file that...
October 5, 2009 at 2:40 am
I also agree with Jeff. When you get files into the GB range then Filestream is the only way to go.
Google 'To Blob or not to Blob', a good...
October 5, 2009 at 2:32 am
I agree that a restore process that does not work is not worth having.
My main pioint is that we should not assume that because method A has proven...
October 2, 2009 at 8:16 am
Gail is right. If you have very little space on your server you have a problem. Doing repeated shrink operations is a bit like trying to empty the...
October 2, 2009 at 3:51 am
2GB ram is very little memory to run SQL Server. If this is a production machine I recommend you get more memory as it is relatively cheap.
My recommemdation is...
October 2, 2009 at 3:43 am
If your server has 6GB memory, then probably the best option is to use both the /PAE and /3GB switches in boot.ini, and turn on AWE in SQL Server.
If you...
October 2, 2009 at 3:31 am
It is easy to take a feature present in one DBMS that does not exist in another and say that the first is the better system. All of the...
October 1, 2009 at 3:28 am
You will find that applying maintenance for SQL Server 2005 and 2008 will use a LOT of space on the sytem drive. Most of this goes into the Global...
September 30, 2009 at 9:01 am
If you can edit files yourself, then it is not a trust issue. Have you tried logging on with the SQL service account and accessing the share. This...
September 30, 2009 at 7:07 am
Viewing 15 posts - 1,171 through 1,185 (of 2,496 total)