Viewing 15 posts - 91 through 105 (of 231 total)
Hi California,
Check the following links:
https://blogs.msdn.com/slavao/archive/2005/11/15/493066.aspx
Regards,
Ahmed
November 29, 2007 at 1:05 pm
Hi California,
http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx
If, over time, the SQLServer:Memory Manager: Total Server Memory (KB) counter is less than the SQLServer:Memory Manager: Target Server Memory (KB) counter, then this means that SQL Server has...
November 29, 2007 at 12:26 pm
Hi,
Check Thoses links
http://www.databasejournal.com/features/mssql/article.php/2203601
http://sqlserver-qa.net/blogs/perftune/archive/2007/10/25/2549.aspx
You can spend time using the profiler to be sure if it's really the proc is recompiled , each time it's called.
Regards,
Ahmed
November 29, 2007 at 8:34 am
November 29, 2007 at 8:21 am
Yes I remove "
Go to SSMS (SQL Server Managemnet Studio), rigth click on the Server click Stop then Start
November 29, 2007 at 8:03 am
Hi anujahnavi,
Stop and restart your server (Stop the service).
I corrected a bug in the previous post,
I have to go to the office.
Have a nice day.
November 29, 2007 at 5:44 am
Hi Jason,
Me too I think Lowell code is the rifht way.
Just check http://msdn2.microsoft.com/en-us/library/ms187953.aspx
Have a good day
I have to go to the office it's 07:15 local time
Regards,
Ahmed
November 29, 2007 at 5:13 am
Sorry Jason the 2 way SET and SELECT 😛
November 29, 2007 at 5:01 am
Hi Jason,
When you set a value to a variable you need to use SET 😛
November 29, 2007 at 4:49 am
Hi,
Hans the case is on which column of the table Centraal.PersoonSleutelsIntern
Regards,
Ahmed
November 29, 2007 at 4:30 am
Hi Anujahnavi,
I am sorry for the delay (little bit sick).
ALTER Trigger [dbo].[TestTrigger1]
On [dbo].[tablefortrigger]
For Insert
As
Begin
Set nocount on
Declare @msg nvarchar(255)...
November 29, 2007 at 4:17 am
Hi,
Check the following http://qa.sqlservercentral.com/Forums/Topic247899-5-1.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2127394&SiteID=1
Regards,
Ahmed
November 28, 2007 at 8:27 pm
Hi Art,
Check the following link http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/[/url]
You will find how to get into emergency mode
Regards,
Ahmed
November 28, 2007 at 7:56 pm
Hi,
I want just add my contribution.
Buffer cache hit ratio : should be maintened in the neighborhood of 90 %. Threshold>=90%
It's buffer cache hit ratio/buffer cache hit ratio base
Select
s1.counter_name as ...
November 28, 2007 at 7:51 pm
Viewing 15 posts - 91 through 105 (of 231 total)