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..
Understood. The table is quite huge, almost 5 Billion records, and the index created unusual empty space, it grabbed almost 600 gb extra space from...
Can someone suggest how to reduce the data file unused space which was increased after the reindex processes. Do not want to shrink the file since it...
I would like to know how the TFS database backups are scheduled by default? When i checked in SQL server agent job, there is no job scheduled...
I don't think i can get like "IF EXISTS (...." it gives IF NOT EXISTS (
Separate names with a comma.