Viewing 15 posts - 1,996 through 2,010 (of 2,462 total)
massimo.valtolina (3/28/2010)
the strange thing is that in another db, virtually identical, i don't have this problem.
Data Volume can be different or indexes/statistics might be out of dated. can you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 4:35 am
Sudarsan Srinivasan (3/25/2010)
ROLLBACK in CATCH block...
What else you have in CATCH box ? means any error message or error code syntax?
Bcoz that will help you/us to get the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 4:27 am
Sudarsan Srinivasan (3/25/2010)
ROLLBACK in CATCH block...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 4:25 am
EXEC sp_cpu_proc
IF (DATEPART(mi, GETDATE()) = '00')
EXEC sp_memory_proc
Add above code in job and schedule it for every 1 min.For CPU,it will work for every new hour( ex: 1 AM, 2 AM,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 3:42 am
Mani-584606 (3/29/2010)
How to know whether tempDB is heavily used by the application or not? where to check this?
You can refer this link
Sys.dm_exec_requests DMVs to find the currently active requests, their...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 3:33 am
Thanks to all for your replies, i got the point.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 3:16 am
Additionally Are you taking backup of MSDB ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 2:51 am
Did you have SP1 patch recently?
Whats values you are getting with it?
select value, value_in_use from sys.configurations where name = 'Agent XPs'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 2:50 am
Why it is treating 0 and '' (Blank) same ? in select nullif( 0, '')
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 1:51 am
Hi Vyas, can you please explain it with my sql code.?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 1:49 am
Uncle Moki (3/26/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 29, 2010 at 12:19 am
peterjonk (3/26/2010)
select max(id) from tbl_test
first of all this query never go for index seek as it doesnt contain any where clause
and second, if this table has only one...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 26, 2010 at 8:23 am
I think you should have separate account to run jobs.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 26, 2010 at 8:02 am
Your query is not showing any result as "TEST" login is not db_owner (as your query will only work for db_owner)
and you can use use youydb
go
SELECT P.name
FROM sys.database_principals AS...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 26, 2010 at 7:44 am
Thanks a lot 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 26, 2010 at 7:19 am
Viewing 15 posts - 1,996 through 2,010 (of 2,462 total)