Doing it on the parameter value (@firstName) isn't so harmful, but applying functions to columns in joins and where clauses means that you'll end up, at best, scanning the entire index and applying a predicate, and at worst scanning the entire index and havin...
Is there any way for us to disable access to the database in old machine ? Can we detach both MDF and LDF files ? Your advice is sought. All replies (2) Thursday, January 27, 2011 4:53 AM ✅Answered |1 vote How about setting it offline? ALTER DATABASE databaseName SET OFFLINE...
Give us a feel for the kind of person that you are, and we'll write a description of you in the tone we think you'd take if you bothered to write it yourself Fake Identity ID Random Name Generator - Generate a random character with a fake name for games, novels, or alter ego ...
To execute a client SQL query, a kunlun-server instance goes through standard PostgreSQL query processing steps --- it parses the client SQL query, optimizes it and as an extension for remote data(data stored in kunlun-storage shards), we developed extra plan nodes which form one or more ...
I think that we need the function as follows: CREATE OR ALTER FUNCTION dbo.convert_unixtime_to_utc_datetime ( @source_unix_time AS BIGINT ) RETURNS DATETIME2 BEGIN DECLARE @remaining_unix_time AS BIGINT = @source_unix_time DECLARE @max_int_value AS BIGINT = 2147483647 DECLARE ...
“Unable to enlist in the transaction” with Oracle linked server from MS SQL Server [<Name of Missing Index, sysname,>] in non clustered index [Execute SQL Task] Error: The value type (__ComObject) can only be converted to variables of type Object. [ODBC Driver Manager] Data source na...
(SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did ...
'+CHAR(13) from sys.tables t where type='u' select @sql = @sql + 'ALTER INDEX ' + i.[name] + ' ON [' + t.[name] + '] REBUILD;'+CHAR(13) from sys.key_constraints i join sys.tables t on i.parent_object_id=t.object_id where i.type='PK' exec dbo.sp_executesql @...
5. On SQLServer1, Test a select query on the Synonym like “ Select * from syn_name” This should return the same results that you got in Step2 6. Now on SQLServer2 rebuild an index on the table “Address” alter index PK_Address_AddressID on address rebuil...
In support, we frequently have customers who call us and want to find out why a particular query doesn’t use parallelism. Recently, we had a user who wanted to know why his index rebuild didn’t use parallelism. In some cases, NonParallelPlanReason in query plan tells you the...