Hi Gila

1st File which used space is 30GB and it having little free space around 10MB   BUT "Enable AutoGrowth" in unchecked.
2nd File (on separate drive) which used space...

Thanks for reply.
Simple Insert/Update raising error "PRIMARY" FileGroup full......BUT secondary file having space a lot. Not sure why SQL Storage engine keep trying to allocate space in 1st file...

thanks Folks!

Issue : Error "reported a change in schema version between compile time" when queering LinkServer (Remote table).

Solution : Please set LinkServer property "Lazy Schema Validation" to FALSE

If this option is...

I think Functional DBA came in picture when the Oracle released Enterprises Line of Business Applications like Oracle Financial Suite. Proper functioning the this big application an Oracle DBA...

Is it mean Functional DBA = Production DBA + Database Developer + Business/Domain Knowledge

?

I agree with you.

SQL 2008 & before any memory allocation >8KB will be allocated by MultiPageAllocation which was came from AWE_Memory (if AWE_Enabled & PLIM True).

Now SQL 2012 any memory...

Hi,

What will happen if I configure LPIM (Lock Page in Memory) on SQL 2012 64bit?

I make the changes on my Testing SQL 2012, Yes memory allocating from AWE API....

read "SQL Server 2012 Whats New White Paper.pdf"

from

http://www.google.co.in/url?sa=t&rct=j&q=SQL+Server+2012+whats+new+white+paper&source=web&cd=1&cad=rja&ved=0CDAQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2FE%2F9%2FD%2FE9DBB1BB-89AE-4C70-AF02-AAFC29451A85%2FSQL_Server_2012_Whats_New_White_Paper.pdf&ei=jqfAUN7eOcLOrQeF24DgBQ&usg=AFQjCNETSTqM-Eyol9f041wzq7IEQ2zIIQ

Thank u Gail for your update. Yes I ware have Dec month data in "NovData" FG before spliting.

So u mean we have to split/introduce new range before new data arraving...

Post. Ok

What about Oracle App Certification or SAP Certification in respective my existing skills.?

anthony.green (7/3/2012)

---

I think the OP wants to acheive a MCM rather than he already has an MCM as I just checked the MCM list and couldn't find Ramdas in the...

Yes! MCM in SQL

Steve Jones - SSC Editor (6/1/2011)

---

I believe that log shipping should restart. Move over a full backup and then only log files since the full backup completed and log shipping...