Tagged Questions
2
votes
1answer
57 views
Rebuilding Unique Index with uniqueidentifier in SQL Azure never succeeds
We have a number of tables (~1M records) that have a column on them defined as: [GlobalID] [uniqueidentifier] NOT NULL that gets auto-populated with newid(). We use this ID for synchronizing data ...
1
vote
1answer
103 views
SQL Azure: Drop Constraint and Index
This may be a stupid question, but I'm not a DBA and just wanna make sure of what I'm doing before I make a mistake.
Here is my question:
When dropping Constraints, are their indexes dropped as well?
...
2
votes
2answers
348 views
Reorganize Indexes T-SQL
I'm moving a database to SQL Azure and with that I lose the maintenance plans so I am going to use a Worker Role to schedule them. When I open the properties of the Rebuild Index Task and click on ...
2
votes
1answer
204 views
Error while creating index in SQL Azure
I'm trying to create an index on table [Children] in SQL Azure but get the following error:
The operation failed because an index or statistics with name
'IX_Children_ParentID' already exists on ...
4
votes
2answers
244 views
Clustered indexing is now must - why?
Earlier, there were non-conclusive to me debates/discussions on whether to (always) engage/avoid clustered indexes.
Well, I understood that they are to be used sometimes with proper + specific ...
