842 reputation
511
bio website
location
age
visits member for 4 years, 10 months
seen Dec 17 at 15:57

A SQL Server DBA around Washington DC Metro Area.


Nov
25
awarded  Caucus
Sep
24
awarded  Autobiographer
Feb
24
awarded  Yearling
Feb
24
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
14
asked “The update is already installed on this system” message when trying to apply hotfixes
Feb
29
comment SQL Server 2008 R2 memory leak
Here is a useful blog: sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/…
Feb
24
awarded  Yearling
Feb
8
answered sql script mssql express 2008 windows 2008 server R2 x64
Jan
27
answered How to clear stale Server Name entries in the Sql Server Management Studio Connection Dialog?
Oct
10
comment Error opening SQL Script
I run into this issue a while back. use Textpad, UltraEdit or JuJuEdit; they handle large files well.
Oct
10
comment AWE turned on but still not using memory
As @DavidSchwartz said try upgrading to x64 of SQL Server.
Oct
6
comment AWE turned on but still not using memory
I agree with David. What edition SQL Server are you running? Can you post back the result of this query: SELECT SERVERPROPERTY('Edition') AS 'Edition'
Oct
6
answered AWE turned on but still not using memory
May
10
answered What is maximum memory supported for Microsoft SQL Server Standard Edition (64-bit)
May
10
comment Connect to SQL Server using Windows Group Authentication
@Kenny You can read about Authentication and Authorization from this link(you may need to sign up): searchsqlserver.techtarget.com/news/1102093/…
Apr
21
answered I have a blocking transaction, but no statement is shown
Apr
21
answered Giving a user database permissions in SQL Server Management Studio
Apr
21
revised Creating a small .bak file without indexes or excessive log
added 110 characters in body