143 reputation
6
bio website
location
age
visits member for 3 years, 3 months
seen Nov 5 at 9:00

Aug
16
comment Does the order of columns in a non-clustered ColumnStore index matter?
This question is about a non-clustered index vs the suggested question which is about a clustered index. Also, the issue about SSMS isn't addressed in the suggested question.
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
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
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.
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.