143 reputation
6
bio website
location
age
visits member for 2 years, 10 months
seen Jun 25 at 10:36

Feb
22
comment RAID0 vs multiple files in file group
The question is about multiple files in one filegroup, this link has the info about the stripping: technet.microsoft.com/en-us/library/…. I understand when there will be an advantage when splitting indexes/tables across multiple filegroups, that's not what I'm considering. The sad truth is that I had only a couple thousand $ to set up a server and I'm getting by with a not-that-good RAID controller.
Feb
22
revised RAID0 vs multiple files in file group
tags
Feb
22
asked RAID0 vs multiple files in file group
Dec
15
awarded  Teacher
Mar
21
awarded  Popular Question
Feb
9
comment How much memory is needed to keep a table cached? (SQL Server 2008)
I eventually upgraded the RAM of the server and did a test. I posted the results as an answer below.
Feb
8
answered How much memory is needed to keep a table cached? (SQL Server 2008)
Feb
8
comment How much memory is needed to keep a table cached? (SQL Server 2008)
I upgraded the server RAM and "ballpark the size of the table on disk as the amount of memory" is absolutely correct. See my answer below.
Feb
8
awarded  Scholar
Feb
8
awarded  Supporter
Feb
8
accepted How much memory is needed to keep a table cached? (SQL Server 2008)
Sep
15
awarded  Editor
Sep
15
revised How much memory is needed to keep a table cached? (SQL Server 2008)
added 1063 characters in body
Sep
15
awarded  Student
Sep
15
comment How much memory is needed to keep a table cached? (SQL Server 2008)
I'll try: SET STATISTICS IO ON and report back. More info: The queries are 100% selects. Each query takes several minutes. The server also runs the small app which does the querying and dumps results into Excel, but I doubt this affects server performance.
Sep
14
asked How much memory is needed to keep a table cached? (SQL Server 2008)