Viewing 15 posts - 12,286 through 12,300 (of 49,558 total)
george sibbald (7/19/2013)
as the message says it is an advanced settingsp_CONFIGURE 'show advanced options',1
RECONFIGURE
GO
sp_CONFIGURE ‘optimize for ad hoc workloads’,1
RECONFIGURE
GO
Optimise for ad-hoc was only added...
July 22, 2013 at 6:28 am
Data is always read to the buffer pool. PageIOLatches happen when data is needed and is not in the buffer pool, hence has to be read from disk into the...
July 22, 2013 at 6:19 am
Jeff Moden (7/21/2013)
You can simply change back to the FULL recovery mode if in Bulk Logged ....
You can, but a log backup right before or after the switch is...
July 21, 2013 at 3:37 pm
Oh, and ditch the nolock
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
July 21, 2013 at 3:32 pm
SQL_Surfer (7/21/2013)
Thanks Gail. Should I expect 10GB growth everytime I rebuild the index?
No, you should expect the file to grow if there's not enough free space for new indexes to...
July 21, 2013 at 9:55 am
SQL_Surfer (7/21/2013)
Any idea why DB grows to 10GB more after index maintenance?
Because SQL had to rebuild the indexes somewhere, if there wasn't space for the new indexes, the...
July 21, 2013 at 9:42 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 21, 2013 at 7:30 am
July 21, 2013 at 2:29 am
index_id of 0 and name of NULL means it's a heap, a table without a clustered index. You can't rebuild a heap.
And in case anyone posts the 'create a clustered...
July 20, 2013 at 11:50 am
balasaukri (7/20/2013)
4. Shrinking the files in PRIMARY will reflect in SECONDARY in LS/ Mirroring. So shrink the log file in Primary.
Attempting to shrink a full log is just a waste...
July 20, 2013 at 3:33 am
rajeshn29.dba (7/20/2013)
Hi All1.In mirroring If I add data file in primary server will it reflect in mirror server or not?
If yes can you pls explain me?
Yes, it'll be reflected just...
July 20, 2013 at 3:32 am
neefjakkals (7/19/2013)
I can restore my .bak file without errors. I can attach the mdf files i copied off the old drive without errors.
Why restore then attach?
Surely you want...
July 19, 2013 at 1:32 pm
There's nothing in there of any use.
What, exactly are you doing? What is the exact outcome, with error messages.
July 19, 2013 at 1:01 pm
No idea without an actual error message.
How are you attaching the DB? And, if you're restoring from backup, shouldn't that be restore not attach?
July 19, 2013 at 12:42 pm
Viewing 15 posts - 12,286 through 12,300 (of 49,558 total)