Viewing 15 posts - 35,056 through 35,070 (of 49,552 total)
It's the syscolumns view in the master database. syscolumns used to be a table in SQL 2000 it's now a view and it's one of the meta-data views. There's a...
December 30, 2009 at 1:38 am
golden-1131024 (12/30/2009)
Index creation is a workaround, is there any advice to have both performance improvement but with less db size increment?
A workaround?
Indexing is the key to good performance. No indexes,...
December 30, 2009 at 1:32 am
It's probably the checkpoint process. As I said, don't worry about it. The system processes have all sorts of wait types in 2005 and above and they're supposed to have...
December 30, 2009 at 1:29 am
Microsoft gives an immense amount of software away for free.
Just a couple of examples: the express versions of SQL Server and Visual Studio and all the Windows Live apps, Virtual...
December 29, 2009 at 12:36 pm
That said...
Check with whoever's responsible for the backups and ask whether or not there are any differential backups been run. If there are, to avoid messing up the recovery chain,...
December 29, 2009 at 12:29 pm
edtraviles (12/29/2009)
December 29, 2009 at 12:23 pm
I am out of ideas.
Nothing needed on a cluster other than remote DAC. I have done it before, no problems at all.
Way out idea. Does the cluster have a...
December 29, 2009 at 12:22 pm
edtraviles (12/29/2009)
I presume I use 'Add...' to specify a new path and filename for the one-off backup, highlight it when I run the backup, and leave the existing alone(?),
No. If...
December 29, 2009 at 10:39 am
Hit your favourite search engine and search for clustering best practices on technet.microsoft.com. There are pages and pages (and I mean that quite literally) on it.
December 29, 2009 at 10:37 am
GSquared (12/29/2009)
December 29, 2009 at 10:34 am
You're 100% sure that remote DAC is enabled?
EXEC sp_configure 'remote admin connections'
December 29, 2009 at 9:11 am
So that means that restart-recovery is in process. Give it time and the DB will either come online or it will go suspect.
Error log?
December 29, 2009 at 8:20 am
Willian Funes (12/29/2009)
December 29, 2009 at 8:13 am
Willian Funes (12/29/2009)
Hi, the instruction "select * from sys.databases" work fine and I get all DB
Yes, it will work. sys.databases is in master. The reason for asking you to query...
December 29, 2009 at 8:10 am
Viewing 15 posts - 35,056 through 35,070 (of 49,552 total)