All Questions
Tagged with azure-sql-database sql-server-2016
20
questions
9
votes
2answers
602 views
SQL Server: Covering indexes including all columns?
Our team has inherited an application and associated database. The previous developers appear to have enforced a rule where every index, on every table, has an INCLUDE clause to always add every ...
4
votes
1answer
2k views
Is it possible to use cross database queries in both Azure and SQL Server 2016?
I'm working on a project that is designed to run on Microsoft's Azure platform. At present we have a few developers working locally on their own machines with the intent of being able to publish the ...
3
votes
1answer
2k views
How to enable query store on the SSMS object browser with Sql Azure?
I am following this guide: Monitoring Performance By Using the Query Store
I am using SSMS 2016 CTP3.2 and Sql Azure V12
I have enabled the query store on the database properties.
I can use the ...
3
votes
3answers
234 views
Permission error when using sys.dm_exec_input_buffer with @@SPID
When I run this blob of SQL on SQL Server 2016 or an Azure SQL DB:
--hello world
SELECT event_info
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_input_buffer(req.session_id, req....
3
votes
1answer
77 views
Determine minimal permissions required for a given SQL script or session
For security reasons I need to determine minimal permissions required for a given script or session without having to manually audit activity then work it out by hand.
I'm assuming this can be done ...
2
votes
1answer
1k views
Multi-tenant database
We are building a database for a SaaS web application. We have been told to use a multi-tenant approach and to expect over 100,000 tenants to be using the system over the next 5 years, so we're ...
2
votes
1answer
749 views
Fastest method for inserting large number of records from query between tables
I have a query that returns 14 million results that I need to store in a table, the SELECT query itself returns in a little over 2 minutes but INSERT statement takes well over 30 minutes (which is ...
1
vote
1answer
55 views
How to get EstimatedRows values from SQL Server execution plan nodes
When I execute the following code in an Azure SQL Database (v12) or SQL Server 2016 instance, I get values in the EstimatedRowsRead column, but not in the EstimatedRows column, and I'm not seeing why. ...
1
vote
1answer
446 views
SQL Server (Azure) split comma-separated string into multiple columns?
I have the following data in Azure SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8 Sep 20 2018 21:40:02 Copyright (C) 2018 Microsoft Corporation)
ID Name
1 US_Android_100x200_blue
2 ...
1
vote
1answer
630 views
Replicating on-premise SQL Server instance with hundreds of databases to an Azure SQL Managed Instance
I am wanting to replicate an entire SQL Server 2016 on-premise instance of databases (300+) to an Azure SQL Managed Instance for redundancy of a read-replica in case of on-premise downtime. It appears ...
1
vote
1answer
683 views
How can I synchronise Always Encrypted data from On-Premises to Azure SQL Database (near real time)?
Let's say I have On Premises SQL Server 2016 SP1 and Azure SQL Database.
There is no way at this point to redirect whole solution directly to Azure SQL Database and I need to have a copy of the ...
1
vote
1answer
627 views
Boolean logic with BITs and Booleans in SQL Server
How can I mix boolean logic with bitwise and/or operators in SQL Server, specifically SQL Azure Database and/or SQL Server 2016?
To demonstrate what I'm trying to do, consider the following script:
...
1
vote
1answer
51 views
Colloboration between T-SQL Table and Excel Sheet(s)
Let's say I have a T-SQL table with 20-30 columns and 2-3 millions rows (huge table). I want to allow a user to update this data directly (the solution must work for different tables). I generally ...
1
vote
0answers
27 views
Syncing On Prem SQL Server with Azure SQL
We have a SQL 2016 instance running production systems at a pretty healthy load within AWS. On top of this we host instances of production databases in Azure for PowerBI and analysis usage.
At ...
1
vote
1answer
75 views
Transfer data from the cloud to a local database
I have an SQL Server 2016 Azure database in the cloud called XCLOUD, with many tables big and small, and a local SQL Server 2016 database with the same tables and data called XLOCAL.
In all databases ...
1
vote
1answer
192 views
SQL Server local instance user login [closed]
I am working on an Azure Mobile Apps backend service, which I am trying to connect to a local SQL Server database, as described here. I have followed all the steps, except I am using SQL Server 2016 ...
0
votes
0answers
177 views
Importing BACPAC file from azure to SQL creating an empty database
Exported Data-Tier_application from an Azure database to create a BACPAC of it.
SQL editions I'm trying to use to import the BACPAC:
SQL Server 2016 express.
SQL Server 2017 Developer ...
0
votes
1answer
163 views
Intellisense Not Working in SSMS 2016 [duplicate]
I am working with an Azure SQL Server database in SSMS 2016. I have Intellisense enabled in Tools -> Options -> Text Editor -> Transact-SQL -> Intellisense, however I have never had Intellisense ...
0
votes
1answer
385 views
Importing a .bacpac from SQL Azure into a local SQL Server 2016 server gives errors
I'm trying to import a .bacpac created from SQL Azure into a SQL Server 2016 server that has no existing databases beforehand. It will run but run into issues such as:
Unhandled Exception: ...
-2
votes
1answer
72 views
Database Backup to URL fails with Device I/O Error [closed]
I'm using Ola's Maintenance Solution to backup my databases to a URL. Most of my databases backup just fine but I have one 2 TB database that continues to fail with a device I/O error. Has anyone ...
