[SQL 2012] AWE on SQL SERVER 2012 and Windows Server 2008 Data Center? |
- AWE on SQL SERVER 2012 and Windows Server 2008 Data Center?
- Blob data handling - best option?
- SSDT - Apply Different Security per Target Environment
| AWE on SQL SERVER 2012 and Windows Server 2008 Data Center? Posted: 20 Mar 2013 02:58 AM PDT We have SQL Server 2012 Enterprise 64-bit installed on a Windows Server 2008 Data Center 64-bit. For some reason AWE is allocating all the unused memory from the OS. It's my understanding that AWE was depricated from 2012, which would make sense since I can't find anywhere to disable it in the SQL config. Is there some other way that AWE would be installed and enabled? Some other applicaion? 2008 is not installed and this is a fresh install with 2012, not an upgrade.Any thought you have would be appreciated.Thanks. |
| Blob data handling - best option? Posted: 19 Mar 2013 07:31 PM PDT HiI am a programmer and need to do the following.Currently we are using SQL Server 2000 and we are handling lots of resume/cv in .DOC and PDF formats. we use some 3rd party tools to extracts the contents of the file and store it in NTEXT column which is full-text indexed. Now we are planning to go with SQL Server 2012 Standard and i would like to get some advice on this scenario. 1. I dont want to use the text extracter (3rd party tools). Should i store the files as single BLOB and full-text index on it. This is main point as we search these very often to find the best matched candidate for a job requirement. Are is there any other best method to handle this situation? Thanks. |
| SSDT - Apply Different Security per Target Environment Posted: 19 Mar 2013 09:19 PM PDT HiHopefully the title makes my request obvious but just to elaborate. I am using SQL Server Data Tools for a SQL 2012 database and have set up 3 publish.xml files in order to publish the database to 3 different environments.I want to be able to alter the security that is applied to the DB post deployment depending on the environment I am targetting. Any pointers on how to do this?ThanksBen |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment