Viewing 15 posts - 661 through 675 (of 4,745 total)
richykong (4/19/2013)
It looks like the standard edition only supports up to 4 processors so going to a 32 proc machine probably doesn't make a difference.
the OP doesn't say...
April 20, 2013 at 1:10 pm
Now when you say " Set the log to the size it needs to be to handle your activity, set a sensible growth factor and leave it there. " I...
April 19, 2013 at 5:11 pm
ensure the sql service account has full control permissions on the E:\sqldata directory.
You will need to restart the instance for the change to take effect.
Delete the old files after successful...
April 19, 2013 at 5:03 pm
first of all there is no point repeatedly shrinking the log if it just having to grow again - and shrinking a log does not remove data from it.
From what...
April 19, 2013 at 1:36 pm
Zeal-DBA (4/18/2013)
But what if client ask to create at least one index on each table which are not even suggested by missing index DMV.
he...
April 18, 2013 at 7:26 am
how long is for ever?
One thing that report does not take into account is the no. of pages. An index with only 2 pages is not worth rebuilding or even...
April 18, 2013 at 3:51 am
prashanthreddymr (4/17/2013)
April 17, 2013 at 4:03 pm
prashanthreddymr (4/17/2013)
Is reboot of the server required after adding /3gb in the boot.ini file?SQL is consuming 2.3GB of memory
yes a reboot is required.
Where did you get the 2.3GB reading from,...
April 17, 2013 at 4:02 pm
dkschill (4/17/2013)
DBCC CHECKDB() WITH DATA_PURITY
On a recently restored test DB and it ran with no errors. Should I go ahead and schedule a production run? It...
April 17, 2013 at 3:08 pm
you can but its of minimal use to you with a physical limitation of 4GB on the server.
what makes you think you are running out of memory?
How much memory is...
April 17, 2013 at 2:24 pm
sounds like there are connections to the database preventing you restoring to it.
April 17, 2013 at 10:02 am
in my experience pausing the node causes it to fail the pre-installation checks.
removing from possible owners is the best way to go.
April 17, 2013 at 7:32 am
in failover cluster manager, select the SQL service.
right click the server name select properties. possible owners are on the advanced policies tab. Untick the passive node.
don't remove the node from...
April 17, 2013 at 5:22 am
hows this as a starter?
select * from master..sysdatabases where databasepropertyex([name], 'status') != 'online'
April 16, 2013 at 9:44 am
you can use AWE with 32bit SQL on a 64bit OS.
April 15, 2013 at 2:29 pm
Viewing 15 posts - 661 through 675 (of 4,745 total)