Question : I have a table that looks something like this in a SQL server database in Azure: CREATE TABLE […]
Tag: azure-sql-database
Joining table from Linked Server is very slow
Question : I have a production SQL server and a linked server (Azure SQL Database) I join two tables to […]
Merging the sysdb database (a dependency due to conversion from Oracle) into my SQL Server 2014 Express Database
Question : I am looking to convert my SQL Server 2014 Express Database to Azure SQL Database. My SQL Server […]
How to GRANT Permission on many views? Azure SQL
Question : We have to grant permissions to alter 6 Views to one user. Is there any way to do […]
Why is my index not being used in a SELECT TOP?
Question : Here’s the run-down: I’m doing a select query. Every column in the WHERE and ORDER BY clauses are […]
Reporting services 2008 reports connection to azure sql database
Question : Due to the end of support of sql server 2008 R2 we are planning to move the database […]
Azure SQL Read-Only table Indexing
Question : I’m trying to work out the best indexing strategy for a slightly weird pattern I’m forced to use […]
What are the reasons you would not migrate a SQL Server Instance to SQL Azure?
Question : I have some servers and some databases on SQL Azure and as much as I like this idea, […]
What permission needs to be added to see the Security folder in Azure SQL?
Question : I have the Security folder, and I am trying to setup other Users with the same permissions that […]
Why does PK constraint require a separate index when I already have a suitable unique clustered index?
Question : This is part of table definition from here: CREATE TABLE [dbo].[JobItems] ( [ItemId] UNIQUEIDENTIFIER NOT NULL, — lots […]