Viewing 15 posts - 8,116 through 8,130 (of 9,248 total)
Satish-219904 (4/5/2010)
I have not applied "Lock pages in memory" option yet but planning to do this along with this change. Hopefully it should increase the performance of my SQL Server.
ensure...
April 5, 2010 at 2:21 pm
Satish-219904 (4/5/2010)
How can i moitor PLE (page life expectancy)?
which monitoring tool do you use. Perfmon has a counter available for this or view it via the following query
select cntr_value...
April 5, 2010 at 2:11 pm
Saravanan T (4/5/2010)
Im rebuilding and reorganizing only the indexes which it required.
something i have seen before, ensure you dont have a maint plan with a rebuild and a reorganise...
April 5, 2010 at 2:07 pm
george sibbald (4/2/2010)
sys.master_files possibly points to a bunch of file locations that don't exist so user databases will have to be dropped and reattached.
you can also perform a restore with...
April 5, 2010 at 2:02 pm
what is the full command line you are using?
April 4, 2010 at 6:13 pm
its worth pointing out that if the deleted account is not spotted straight away, the default trace may not be helpful. Depending how busy the server is as to how...
April 4, 2010 at 8:26 am
SPNs can be a problem here too
April 4, 2010 at 5:58 am
darth.pathos (4/2/2010)
April 2, 2010 at 9:48 am
GSquared (4/2/2010)
You can grant the right to create procedures specifically.Would look like this:
GRANT CREATE PROCEDURE TO bob;
if granting the rights granularly as GSquared posted, just bear in mind that you...
April 2, 2010 at 9:33 am
Hi
cant speak for SQL 6.x or 7 but certainly from 2000 on the default of 0 is 100% thats what i have understood and read.
Yes you probably want to change...
April 2, 2010 at 9:29 am
Paul White NZ (4/2/2010)
One real-life experience was of running a 2000-only application in compatibility mode, which failed because occasional batches included the *= outer join syntax.
I too have had...
April 2, 2010 at 9:24 am
especially ensure the first thing you do after restoring or attaching the database to SQL Server 2008
is to run
DBCC UPDATEUSAGE
see the following link
http://msdn.microsoft.com/en-us/library/ms188414.aspx?ppud=4
you may have to leave the compatibility level...
April 2, 2010 at 6:39 am
paulc.byrum (3/26/2010)
SQL Server 9.0.4035 (SharePoint instance)
SQL Server 8.0.2055 (Standard edition)
SQL Server 8.0.760 (MSDE)
SQL Server 9.0.4053 (Express Edition)
The...
April 1, 2010 at 11:22 am
paulc.byrum (3/31/2010)
sqlcmd -E -d master -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
and then:
ALTER LOGIN [PBTF\Group - IT DB Admins] WITH DEFAULT_DATABASE = master
No errors running the command, but I still see Error 4064 in...
April 1, 2010 at 11:17 am
Viewing 15 posts - 8,116 through 8,130 (of 9,248 total)