Viewing 15 posts - 1 through 15 (of 210 total)
Got the answer from some expert. This just confirms that the sql version > 7.0.
May 23, 2012 at 6:49 pm
This is not my sp. These are the replication system sps. I don't understand why the version is validated everytime...
May 23, 2012 at 3:22 pm
Another crude method
select client_name,phone
from(
select temp.client,phone
from
(select [client],max(DATEs) datephone
from contact
group by client)temp
inner join contact
on contact.client = temp.client
and contact.dates = temp.datephone)tmp
inner join client
on client.client_id = tmp.client
May 2, 2012 at 3:45 pm
another way
select sqlserver_start_time from sys.dm_os_sys_info
February 15, 2012 at 12:09 pm
Actually i tried some common dmvs but don't know how to get the value of mirroring timeout and mirroring heartbeat. I know we can change this as follows:
ALTER DATABASE <dbname>...
February 15, 2012 at 12:01 pm
can't run the script
Msg 55555, Level 16, State 1, Procedure sp_MSforeach_worker, Line 92
sp_MSforeach_worker assert failed: command too long
April 11, 2011 at 7:45 pm
The sql service must be started after msdtc is started.
March 8, 2011 at 12:50 pm
This is something really new in SQL 2008 sp2. I shall verify the BOL and let you know if i find anything.
March 7, 2011 at 6:48 pm
Tweak the query timeout
March 7, 2011 at 6:29 pm
This value 684991 is not changing. This connection used this much cpu time that time only.
March 7, 2011 at 6:28 pm
AFAIK the log files are filled up sequentially. I believe following scenario in your case.
1. There are three log files ie LF1, LF2 and LF3
2. LF1 filled up.
3. LF2 started...
March 3, 2011 at 6:12 pm
try this
BEGIN TRAN test
DELETE tablename
FROM (SELECT Column
FROM
(
SELECT column/s, row_number() over(ORDER BY getdate()) as r
...
March 3, 2011 at 5:53 pm
Even 16 TB is going to be very heavy. Please look into other stats b4 proceed with a huge data.
-Lucky
March 3, 2011 at 5:47 pm
Viewing 15 posts - 1 through 15 (of 210 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy