147 reputation
5
bio website
location
age
visits member for 2 years, 4 months
seen Nov 10 at 12:13

Sep
12
awarded  Popular Question
Mar
8
awarded  Student
Feb
24
comment The memory usage of SQL Server keeps growing
Krunal -- The solution is to fine tune your heavily resource intensive queries.
Jan
18
comment The memory usage of SQL Server keeps growing
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Jan
18
comment The memory usage of SQL Server keeps growing
Sql server 2008 R2 SP1
Jan
18
comment The memory usage of SQL Server keeps growing
Actually I need to know in what situations sql server will release this memory to OS? Bcos in my case after reaching to the max size, the front end web application is not able to login for users
Jan
18
comment The memory usage of SQL Server keeps growing
@marc_s - Lets say if we have proper indexes and DB design, will not lead to this situation? Bcos as I am wondering irrespective of the good design/indexes the sql server uses this buffer ppol to cache the data/plans etc...as sql server is used for long, cant this buffer pool size grow to the max mem size and that time if other process needs memory then what to do?
Jan
18
comment The memory usage of SQL Server keeps growing
@Mitch Wheat -- Total of 25k Users...there could be ~1000+ users might connect at a time...and it all again depends..like based on user login
Jan
18
asked The memory usage of SQL Server keeps growing
Jun
4
comment What happens when I try to store more 8019 bytes in a SQL Server table row?
yeah you can use varchar(max).
Jun
4
answered What happens when I try to store more 8019 bytes in a SQL Server table row?
Oct
6
awarded  Teacher
Oct
6
awarded  Commentator
Oct
5
answered How can I get the actual data size per row in a SQL Server table?
Oct
5
comment How can I get the actual data size per row in a SQL Server table?
yeah its not applies for varchar I agree.Here above your query is not covering all the columns of a table
Oct
5
comment How can I get the actual data size per row in a SQL Server table?
MS SQL server allows only 8060bytes of data max to be stored in a row.Hence your row size will alwayas be <= 8060.It will never cross this.
Oct
5
answered Do I need an index on this?
Sep
3
comment Best value for fill factor in index
Go through this article. sqlmag.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/…
Sep
3
comment Create index view with self join
As of now the sql server does not support creating an index on the views containing self joins. So you can have just view but not indexed view.
Aug
6
comment SQl Server Password Change after installation
did u try loging in with administrator acc?