The question is about the performance, the table should have proper index and do the maintenance periodically.
The table hints can be used, like...
try after clearing the cache...something like this
DBCC FREESYSTEMCACHE('SQL Plans')
It may be issue with editor....try to get the result in a text file and see.
There are different factors considered for this migration.
(1) Since both the applications are in the different server, the work load is distributed...
something like this ...
row_number()over(partition by number order by number) rw
20 min is quite big...did you execute the query in the SQL server itself? if not there are chances of network latency.. also put a NOLOCK hint. if...
idealy you need to look where it consume more time..check the sufficient index in the table ..check the query is using the correct plan..and a lot
Yes, if there is no space in the drive to grow, then the SQL will write it to the new file.
Database==> Task ==> Import data
Is it an interview question :)
Update is nothing but delete insert...the concern is index fragmentation. Think bit on table partition, may help to reindex a specific partition?
i tried..also mentione in the above note.
My bad...instead of mirroring I should type replication :(
Since you need to implement it in the production, sqlserver licences needed for both the...
The question is not much clear...if you want to find the data difference between source and destination table, then
select * from...
There are twio things, first needs to check the server configuration, server may need more physical memory ans see teh allocated memmory for SQL...
As per your note, the secondary database will be used for only reporting purpose, then you can go for a LogShipping method rather than mirroring. As...
You can add one more file in the same filegrup, if you do not want to create a new.
ALTER DATABASE [<DBName>]
ADD FILE ( NAME =...
I have a problem whiel creating a table in one of my database, its says,
"Msg 2714, Level 16, State 6, Line 1
There is already an object named...
If the plan is good, then might be due to the volume of data pass through the network..
Thanks Franks. Let me have try..
Separate names with a comma.