Tag Info

New answers tagged

3

Generally How much time it would take to delete such no of records ? Impossible for us to guess - way too many factors involved here, including performance of your data and log drives (a factor of which level of service you chose), your log growth rate and number of auto-growth events that occur, concurrent activity, number of indexes, existence ...


2

1) Generally How much time it would take to delete such no of records ? It depends on many factor like Is there any BEFORE/AFTER DELETE triggers Too many Indexes Cascade delete Number of rows to delete Deadlocks and blocking 2) If there is any Index on that table then is it gonna affect the delete statement ? Note: I have a non-clustered ...


2

That's a lot of NTEXT columns. You should know NTEXT is deprecated and you should consider refactoring to the newer datatypes, eg NVARCHAR(MAX). Regarding your specific problem, depending on what version and edition ( eg select @@version ) of SQL Server you are using, you could consider partitioning. Here's a simple demo of this might work for you and my ...


7

Your query is no faster with the index because SQL Server has determined that it would be more efficient to do a Clustered Index Scan, than use the IX_ActCost_ScenarioID that you have defined and perform a Key Lookup to retrieve the extra data needed. As you've only defined the index on ScenarioID, with no INCLUDE columns, each extra column you wish to ...


-1

You should look into several things: 1) Check the query plan, see if SQL Server is using the index. 2) How many records do you have in this table? If it's just a few million or even a few hundred million, then this query should be fast, if it's using the index. 3) Script out the index IX_ActCost_ScenarioID for CREATE and post its code here. See if ...


1

Try reviewing DMVs sys.dm_database_copies and sys.dm_operations_status which are Azure SQL Database-only, and meant for reviewing progress on these type of operations eg SELECT * FROM sys.dm_operation_status SELECT * FROM sys.dm_database_copies Review the state_desc and error_desc columns. Post the output here if required.


0

Microsoft has changed the procedure. What you need to do is Export/Import a Data-tier Application via a BACPAC file. Microsoft explains it here (in the section Backup Package (.bacpac): http://msdn.microsoft.com/en-us/library/ee210546.aspx Here it is in a nutshell: Use SQL Server Management Studio 2014 Right-click your local database name, then Tasks / ...



Top 50 recent answers are included