Viewing 15 posts - 226 through 240 (of 2,462 total)
chandan_jha18 (9/23/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 25, 2013 at 3:36 am
Brandie Tarvin (9/24/2013)
That's an interesting link. I'm going to have to think about how it could work given that my query doesn't use the column in the WHERE clause.
Beside this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 8:38 am
Brandie Tarvin (9/24/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 8:03 am
ananda.murugesan (9/24/2013)
I got call from user side for they are not able to do DML operation
Often These maintenance tasks run at Off-Peak hours.(during nights). so avoid these kinds of...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 6:12 am
Yes .
From above pasted link
--Query to check the job history error messages if any
SELECT *
FROM [msdb].[dbo].[sysjobhistory]
WHERE [message] like '%Operating system error%'
--Query to check the Log Shipping errors
SELECT *
FROM...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 4:58 am
ananda.murugesan (9/24/2013)
During running job at that time application not able to connect the database.
What was the issue here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 4:50 am
This will help http://www.mssqltips.com/sqlservertip/2553/different-ways-to-monitor-log-shipping-for-sql-server-databases/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 4:46 am
Are you saying that every database having connection issue or any specific ?
Check the statuses of all databases
select state_desc, * from sys.databases
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 4:40 am
greg.bull (9/24/2013)
Why does this delete operation take minutes ? Why wouldn't SQL use more resources to get the job done faster ?
Can you post exec plan along with...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 4:24 am
Zeal-DBA (7/24/2013)
please let me know how to identify or calulate this parameter value for each instance.
HOw much memory currently being consumed by each instance ? that can give you rough...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 3:07 am
Perry Whittle (9/19/2013)
Using the @affinity and @throttle parameters you are able to specify which processors the backup uses and the max CPU %
Can we take help of Resource...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 3:00 am
You have kept your question at WRONG tab ..Sql Server 2005 . you soould have been used the "Sql 2012" tabs to get the hits.:-)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 2:57 am
https://www.google.co.in/?gws_rd=cr&ei=5U9BUvDsEMKHrgf_9oFo#q=sql+server+2008+memory+troubleshooting
Hit the first link .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 2:41 am
Why did you use tuning advisor ... did you experience any perfoemance issue with your code/query ?
Post that Query along with table defintion and execution plan
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 24, 2013 at 2:35 am
GilaMonster (9/20/2013)
Ignore the scan count. It's not the number of times the table has been scanned. It's not consistent.
thanks for reply.
But is this difference because of IN and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 7:17 am
Viewing 15 posts - 226 through 240 (of 2,462 total)