Viewing 15 posts - 361 through 375 (of 501 total)
I have seen this before and my theory is that SQL is awaiting a response from the client but is unaware that the client connection was dropped (network issue in...
March 13, 2009 at 4:37 pm
There is a default trace running which will give you the info if it happened recently. Right click on the database, Reports, Standard Reports, Schema Changes History.
If I remember correctly...
March 13, 2009 at 4:26 pm
A rolling upgrade is to patch the passive node in a cluster, fail over to the passive node, then patch the newly passive (formerly active node) to reduce downtime.
March 3, 2009 at 5:40 pm
Go into Control Panel, then Add or Remove Programs, Click the check box at the top labeled Show updates. Find the hotfix in the list and click remove.
February 26, 2009 at 4:56 pm
George's recommendation of 1,000 pages seems to be inline with MS recommendations. Anything smaller than 1,000 pages and it's just as fast to do a table scan as use the...
February 25, 2009 at 4:10 pm
leonp (2/24/2009)
AS THE DBA, renaming a fully configured SQL Server is not advisable.
Renaming a SQL server and putting a DNS alias out there are 2 different things.
I guess...
February 24, 2009 at 5:54 pm
I would be curious to hear what the reason was for a DNS alias being a bad idea.
I have used DNS aliases several times when migrating between SQL servers. There...
February 24, 2009 at 4:26 pm
Yes, SQL 2000 and 2005 can run on the same machine. Keep in mind that the 2 instances will be sharing resources so if you have your 2000 instance memory...
February 12, 2009 at 5:06 pm
It sounds like someone created a database without the standard MS file extensions. The database will run fine without file extensions and SQL does not care what the file extensions...
February 11, 2009 at 4:47 pm
Do you have awe enabled?
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
February 9, 2009 at 5:10 pm
AndyG (2/6/2009)
adding an additional 300 GB data file, probably on a new LUN, versus expanding the current LUN's to allow for a similar growth of the existing data files.
I would...
February 6, 2009 at 5:03 pm
Users would also need the "ALTER" permission for each mirrored db.
January 26, 2009 at 10:08 am
Pause:
ALTER DATABASE your_db_name SET PARTNER SUSPEND
GO
Resume:
ALTER DATABASE your_db_name SET PARTNER RESUME
GO
Failover:
ALTER DATABASE your_db_name SET PARTNER FAILOVER
GO
January 23, 2009 at 5:22 pm
I haven't installed SP3 on an Active\Active cluster but I have on an Active\Passive cluster. Just needed to start the SP3 install on the active node, it prompted for credentials...
January 16, 2009 at 5:00 pm
I had a demo of Quest's Capacity Manager a few versions’ back. It seemed to work well and has fancy graphs and charts. However, Quest is proud of their tools...
December 10, 2008 at 5:19 pm
Viewing 15 posts - 361 through 375 (of 501 total)