Viewing 15 posts - 586 through 600 (of 643 total)
ananda.murugesan (12/1/2011)
Server A:
Version - SQL SERVER 2000 with SP4.
Database size- 600 GB
OS - Windows server 2003 Enterprise edition.
Server B:
Version - SQL SERVER 2008 with SP3 - 64 bit
OS - Windows...
December 1, 2011 at 11:02 pm
solomon.jernas (12/1/2011)
I want install MS sql server 2008 Failovercluster on two nodes. How do i proceed?please tell steps ?
Thanks
Jeri
There are so many step-by-step articles available on the net. Study...
December 1, 2011 at 10:40 pm
MasterDB (11/28/2011)
One of my server is running slow. i ran profiler, with that i came to know DatabaseMail-DatabaseMail90-ID<2588>(Application name) and object name Sp_readrequest is taking more than 3 minutes...
December 1, 2011 at 6:02 am
ryan.reinaldi (11/30/2011)
Hi Sujeet thanks for the reply, I think my upgrade strategies will be an In-Place Upgrade, so what will happen if do that kind of strategy.Thanks 🙂
In-place upgrade is...
December 1, 2011 at 12:21 am
ryan.reinaldi (11/30/2011)
November 30, 2011 at 11:18 pm
You got late by some seconds referring to this thread 🙂
lol right 😀
November 30, 2011 at 4:47 am
Yes, you made the right decision :-). Although, SecurityAdmin itself is equivalent to sysadmin with few minor exceptions. If you are that much concerned, you must read this article from...
November 30, 2011 at 4:39 am
Hi Duran,
Have you altered the SQL Script also which is executing within the job steps to point to this new SQL Server (I assume you have created a new linked...
November 30, 2011 at 4:05 am
mamidimahesh (11/29/2011)
I get this when I execute a SQL Job.Thanks,
Mahesh Mamidi
I hope your issue has been resolved :-). If not, please provide us the information about the query that you...
November 30, 2011 at 1:12 am
Banana-823045 (11/29/2011)
Dev (11/29/2011)
That's the beauty of MSDN articles. They are well organized. :hehe:
I'm appreciating this now! I'm in an odd position because I'm doing my darnedest to soak...
November 29, 2011 at 9:41 pm
Banana-823045 (11/25/2011)
From this page, the securityadmin fixed role does not have CONTROL SERVER and ALTER ANY LOGINS is the only permission granted...
November 29, 2011 at 5:39 am
Hi Gail,
It was really a nice series to learn about the indexes. However, I have one confusion here, so you may guide me :hehe:
Unlike the clustered index nonclustered indexes...
November 29, 2011 at 5:18 am
mamidimahesh (11/29/2011)
Could not connect to server '<<ServerName>>' because 'sa'...
November 29, 2011 at 2:42 am
captcooldaddy (11/28/2011)
November 29, 2011 at 2:33 am
You can find long running queries by executing below SQL code. You can find it on Pinal Dave's blog here:
http://blog.sqlauthority.com/2009/01/02/sql-server-2008-2005-find-longest-running-query-tsql/
&
http://blog.sqlauthority.com/2009/01/23/sql-server-2008-2005-find-longest-running-query-tsql-part-2/
I strongly suggest that you read both the articles before...
November 29, 2011 at 2:10 am
Viewing 15 posts - 586 through 600 (of 643 total)