Viewing 15 posts - 1,021 through 1,035 (of 2,462 total)
try this
select
t1.resource_type,
db_name(resource_database_id)as db_name,
t1.resource_associated_entity_id,
t1.request_mode as lock_requested,
t1.request_session_id as spid_of_waiter ,
t2.wait_duration_ms,
(select text from sys.dm_exec_requests as r --- get sql for waiter
cross apply sys.dm_exec_sql_text(r.sql_handle)
where r.session_id = t1.request_session_id)...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 28, 2011 at 12:29 am
If your mdf file is full then shrinking is out of the question and is not even applicable for discussion since you can't shrink a full file.
can u suggest me...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 28, 2011 at 12:21 am
tempdb with size 200 gb .it seems that server might be production or higher region-ed.so restart should be avoided. are you managing tempdb well like multiple files on multiple disks...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 11:54 pm
Shrinking a Data File brings considerable percentage of Logical Fragmentation and I don’t recommend it.
i would recommend you to study how to manage data files.
anyways Shrinking database can be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 11:40 pm
Some shots you need to try
1. Either free some space or change the disk drive where the backup log is being created.
2. How much estimated size would be of...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 11:29 pm
i am bit confused why only testing mail went well if properties/settings are not good enough.
anyways try below
To set up SQL Server Agent Mail to use Database Mail
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 11:15 pm
ashwinboinala (12/27/2011)
i have entered id values1
2
3
4
5
6
i dont really find any relevance to first insert these id values . you can populate the destination table irrespective of this column...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 11:11 pm
i don't get exactly what you are try to get here. please elaborate additionally please give same data with create and insert script to get quicker result.see my signature below
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 10:59 pm
karthikeyan-444867 (12/27/2011)
Thats what my first thought (using cursor) on this requirement.
Try with LOOP logic
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 3:43 am
"catch" works when logic/code under "Try" get failed.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2011 at 12:02 am
Which table you are talking about ? T table cant have data until we have PK satisfied data. and by design error table population also wrong as every time Sp...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2011 at 6:34 am
see below code
alter proc p1
as
begin
BEGIN TRY
truncate table error_log
BEGIN TRAN
insert into t
select 1
union all
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2011 at 4:06 am
Babar Javaid (12/20/2011)
1. The main reason is that my client's requirement is that I have to delete the data from database older than specific retention period (say 30 days)
IF this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2011 at 12:46 am
Try this
--########## Common Significant Wait types with BOL explanations ##################--------------
-- *** Network Related Waits ***
-- ASYNC_NETWORK_IO Occurs on network writes when the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2011 at 12:27 am
See if below link helps you
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ see the reply written by "vince" on May 22, 2009 at 7:48 pm
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 25, 2011 at 11:52 pm
Viewing 15 posts - 1,021 through 1,035 (of 2,462 total)