5
votes
3answers
188 views

Rebuilding an entire Microsoft SQL Server Database

Is there a suggested way to rebuild an entire SQL Server database from another database in SQL Server 2012 SP2? Let me explain... we have a database that we are trying to enable partial containment ...
2
votes
2answers
233 views

Canceling SQL Server Support [closed]

I need your advice. Our company is about to cancel the SQL Server support. I have this instinct feeling this is a very bad idea. No more SQL Server updates, I know, but even when that is reason ...
4
votes
2answers
877 views

Why did Microsoft kill “English Query” on SQL Server?

Given the popularity of the natural language user interface Siri, which was acquired by Apple for $200 million, I've wondered if anyone knows why Microsoft killed "English Query" on SQL Server.
5
votes
1answer
454 views

The use of NOT logic in relation to indexes

According to Microsoft's book on database development Exam 70-433: Microsoft SQL Server 2008 Database Development: Neither leading wildcard characters not NOT logic allow the query optimizer to ...