All Questions

Filter by
Sorted by
Tagged with
3
votes
2answers
121 views

SQL Server CPU Issues

We've inherited some SQL server 2014 databases, they are running on Azure IaaS. We're getting complaints about performance and trying to get a grip on it. We're starting to look at CPU performance, ...
3
votes
2answers
3k views

Set column to only accept negative values

Is there anyway to change a column data type so that it will accept only negative values? It's SQL Server 2014 Azure.
0
votes
1answer
307 views

Connecting Remote Shares via Powershell

I had a big problem which I just happened to solve, but it's a permissions issue I don't quite understand. Unfortunately I'm in a tight bind and no amount of googling in the past week has really ...
2
votes
1answer
5k views

Backup SQL Server to Google Drive

I have Microsoft SQL Server 2014 on an Azure VM (Windows Server 2012 R2) with one database. Is it possible to configure an automatic backup to my Google Drive folder? Maybe a special tool or ...
1
vote
0answers
1k views

FILESTREAM shared folder can not be accessed using listener name

I have AlwaysOn configured in SQL Server 2014 and enabled Filestream in both nodes (node 1 and node2) as shown here: Enable and Configure FILESTREAM (MSDN Library) I have named the shared folder ...
4
votes
2answers
4k views

PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on

I have an Azure VM with Windows Server 2012 R2 and SQL Server 2014 Enterprise Edition. I have enabled IFI (added SQL Server user NTSERVICE\MSSQLSERVER to "Perform Volume Maintenance Tasks"). I have ...
1
vote
1answer
1k views

Azure TempDB and Log files

I'm setting up an Azure D11 SQL Server to be used for a data warehouse. I can only attach 4 data disks and have done so, now I need to determine how to configure them and split the DB files. I'm ...
2
votes
1answer
1k views

What is limiting the batch requests per sec

We have a newly created Azure SQL Server 2014 instance. The specs for the server are as follows Pretty bare bones, I know. Since this is just a testing server, we have opted to set up the data files ...
1
vote
1answer
152 views

Do I need a separate server for Quorum?

We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: Primary Replica and Secondary Replica. The question is, do we need a separate server for Quorum? ...
1
vote
1answer
825 views

SQL Server VM in Azure with In Memory

I am running azure and considering deploying a SQL Server 2014 instance due to the in memory feature, however, I was looking through the documentation and couldn't seem to find how to configure In-...