Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 61

Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).

0
votes
For questions like these you need to include the query plan and relevant table structure (what keys and indexes are in place) to get a good answer that is specifically relevant. I recommend that you u …
answered Oct 10 '16 by David Spillett
2
votes
As you note the plan shows many index scans[1], a couple of the indexes multiple times such as Facilities.IX_CustomerID. That will be why is it spinning the CPU resource: those indexes will be in the …
answered Apr 27 '18 by David Spillett
3
votes
It sounds like you are using the email address as a key, which is not good practise. Anything that can change is not a good candidate to be a key value which includes email addresses and phone numbers …
answered Jul 16 by David Spillett
3
votes
Is it faster... It depends on a great many things so there is no single correct straight answer to this: What proportion of the target rows are you needing to delete, update or insert anew, if …
answered May 8 by David Spillett
0
votes
There isn't a clean way that I know of. You could try set them all incrementally then see what the final value is. That will return the current maximum: DECLARE @SQL NVARCHAR(MAX) SET @SQL = 'ALTER D …
answered Nov 6 by David Spillett
6
votes
Rather than export, manually edit, and rerun, you could try do the job directly in the database with something like: DECLARE C CURSOR FOR SELECT sm.definition, so.type FROM sys.obje …
answered Jul 5 '18 by David Spillett
2
votes
You can't copy direct from AzureSQL to on-prem SQL (even on-prem SQL running in an Azure VM) that way. To copy the database manually you need to export it via SSMS (or the relevant command line tool) …
answered Nov 2 '17 by David Spillett
1
vote
The backups that form that restore option are not something you have direct access to. The data for your logical SQL server's active databases are locally replicated to if a node dies you get switched …
answered Oct 16 '17 by David Spillett
2
votes
If the indexes are fragmenting that quickly due to massive amounts of activity affecting arbitrary user-provided values then they may be little you can do. If the indexes that are fragmenting badly a …
answered Dec 5 '17 by David Spillett
2
votes
Unfortunately this is not a simple matter. There is much black art and experience involved because you are dealing with a few different but strongly coupled matters. First you are trying to decide if …
answered Nov 14 '18 by David Spillett
8
votes
I've done this on specific indexes before now, to aid oft-run heavy queries. Effectively what they have done is create multiple clustered indexes: when any of those indexes is used to find rows no ext …
answered Mar 8 by David Spillett