I found a new title called **SQL Server "Denali"** in the drop down list on MSDN, but I didn't find much information about it: - What's New (this documentation is for preview only as I see) - Top 9 New Features of SQL Server "Denali" Does anyone have more detailed information about **new features** or significant **bug fixes** in this release? I'm hoping someone has used or tested it. New Features = - Sequences - Extended FILESTREAM (thanks to Eric Humphrey ) - OFFSET & FETCH (ORDER BY Clause) - Memory Manager Changes - LAG (..) and LEAD (..) .. OVER (Partition By..Order By) clause (thanks to gbn ) - Aaron's list

I want to enable full text search in sql server the feature already checked in the installation but in sql when i make this query select serverproperty('IsFullTextInstalled') The value 0 should be 1 ? How i can fix this issue? from SQL server configuration manager it's Running , checked and from installation it's Check if i have enough permissions to run these procedures.

Is there a way to flag one row in a database table (MariaDB/MySQL mostly, but I just want to know), so that there is only one row in a table that has that flag? If I set that flag (for eg. 'active') for any other row, then the row which currently has the 'active' flag is automatically unset. The idea is to not have to manually unset the older 'active' row when there's going to be a new one. I just insert/update a row with 'active'=1 and it's automatically the only one. To clarify my intent, I'm not looking for a method of doing this manually - I'm trying to find out if there is a built-in feature in a database system, since this is a pretty common use case. Hence, the post in DBA, instead of SO. I don't even know what tags to use for this question.

I have a "Microsoft SQL Server Express 2008 R2 SP1" installation on a machine without the "Advanced Services". Now I want to install the "Full-text Search", so I downloaded the setup "SQLEXPRADV_x64_DEU.exe". The problem is, if I start the setup, select my existing sql-instance and go further to the feature-selection menu, I don't see the "Advanced Services". I just see the already installed features. Here's a screenshot (in german): I did the installation of the "Full-text Search" on about 20 different machines with existing sql-instances without problems. But on this machine, I don't know what's the problem. Hope somebody can help me! Thanks in advance!

I have already done some R&D on the same but don't have the real solution. Is there a way to obsolete the right click option "Edit Top 200 Rows" from SSMS? The goal is to prevent developers from changing data using that option. We can't just restrict their permissions. Developers are required to have the edit rights but they are lazy and we can't track the changes if they edit records with that option. (We are tracking the changes using a paid SSMS extension.)

I need some way to check the space usage and backup the transaction log of the database before it gets full when we run your IndexOptimize.sql script. Our databases are mirrored, so I cannot change their recovery model. Btw, our log files grow hundreds of Gigabytes. One possibility could be to execute custom commands after each index is processed. This custom command would be designed by the sysadmin to do any custom action, in this case to check the logical space used by the transaction log file and to do a backup log if it is greater of a percentage. Can you add an argument into your script to do this? Is there any other way to avoid this problem?

sorry for my english!
I need use this column(feature) for show features, filters for products and in some language(It depends on the country).
I have products table(innodb) and a column(json) features, the column feature is like this: {feature:{ [{"en": "System Operation", "it": "Sistema operativo", "value": "IOS 8" }, { "en": "Memory Ram", "it": "Memoria Ram", "value": "16 Gb" }, { "en": "display", "it": "schermo", "value": "5.5\"" }]} Here have just 2 language but can have 30 or 100 language.
For show feature i use foraech in php I should optimize... maybe in mysql if is possible. $language_detect = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2); if($language_detect == "it") {$lang_det = "it";} elseif($language_detect == "en") {$lang_det = "en";} elseif.. elseif... foreach($feature->feature as $row) { foreach($row as $key => $val){ if($key == '$lang_det'){ echo $key->$lang_det .' ' . $val . ' : ' ; } if($key == 'value'){ echo $val . '
' ; } } } The really first problem is: how I can make the query like this result?: [{ "en": "System Operation", "value": "IOS 8" }, { "en": "Memory Ram", "value": "16 Gb" }, { "en": "display", "value": "5.5\"" }] and second problem is: how can I search product/s with the feature/s selected? In mysql sure :) Thank you!!

Is there any point at which you become so familiar with your language/database/system that **there is no need** to test a new feature/configuration/query/etc. by contained/simulated testing before implementing it in your system (especially concerning a feature that modifies data)? Or is it *always* essential to test a new query *by simulation in a test environment*? To specify further, it is clear that it is always **safest** to test. However, is there a way to determine when the risk is so minimal that testing is not worth the effort? Another way of phrasing that: when or is it ever **professional** practice to take a measured risk to implement a feature? Also, let's assume that everything is backed-up, so, worst-case scenario, the data *could* with some effort be restored. Can someone cite specific, expert experience to address this? Please include references where appropriate/possible.

Is there a command at the CLI or in PowerShell that will list the components installed for SQL? I'm looking for something like the Feature List you can get from running the discovery report from Tools in the SQL Server Installation Center program option. I'm running SQL Server 2012 on the CORE version of Windows Server 2008 R2 Enterprise. I've searched around the Net, but haven't found anything useful.

When using a traditional installation of SQL Server one has the Installed SQL Server features discovery report. Googled and found no info if some equivalent was available for the core installation. It outputs to HTML so that is another reason why I believe it is not available (though one could still type its text). So basically, I'd like to know if there is an equivalent on the core version, or what powershell (or command line) could be run to get the same info (version, installed features)?

Just read about the release of SQL Server CE 4 and then searched all through their product website , I still cannot find a feature overview. Previous versions of SQL Server CE didn't support views, I was hoping that they removed the limitations. **My question is:** Is there a page which lists the features and limitations of SQL Server CE 4? *(Edit: I found this feature comparison for 3.5 , but not for 4.0)*

I'm new to PostgreSQL and I ran into problems using the following query: SELECT * FROM table1 WHERE ID = 1 > ERROR: column "id" does not exist LINE 2: WHERE ID = 1 where ID is a column I added via a GUI-tool.

I then found out that ID is a keyword in my current version of PSQL and should be quoted. But I can't recognize what is this ID for.
On the linked page there is the following notice: > It is important to understand before studying Table C-1 that the fact that a key word is not reserved in PostgreSQL (==true) does not mean that the feature related to the word is not implemented. So, ID is not marked as a PostgreSQL keyword and there seems to be a feature connected to it, but I can't find out which. SELECT ID itself turns into the same error message as posted above.

It is rather easy to find links describing a feature. In most cases there is no hint in which release the feature was introduced. Often the last resort is to google for the feature in combination with special releases and to compare the hit counts or something similar like old lists of new features etc.