Viewing 15 posts - 1,081 through 1,095 (of 49,571 total)
July 23, 2017 at 10:34 am
July 23, 2017 at 8:01 am
Yes, query sys.dm_tran_active_transactions.
However, that just tells you that the transaction exists, which should be for a very short time and so is more useful for debugging than seeing...
July 23, 2017 at 6:03 am
Please ask the people telling you that what those 'other' costs are.
Starting today, SQL Server 2014 Developer Edition is now a free download...
July 23, 2017 at 5:59 am
You get one thread per file in the DB (I think), and one per backup file, so if you want more threads, you stripe the backup.
Why do you...
July 23, 2017 at 5:57 am
If CheckDB's returning that, it's probably a fatal error.
Do you have a clean backup of this database?
July 21, 2017 at 2:24 pm
Something to try...
Linked servers have estimation problems if the linked server isn't using a sysadmin account (which it shouldn't be)
Try inserting the data you need from the...
July 21, 2017 at 4:42 am
Can you post both execution plans please? Actual plans, not estimated.
July 21, 2017 at 3:53 am
July 21, 2017 at 3:22 am
I would advise leaving it alone and not trying to reuse the gaps. Doing so is asking for trouble.
If, say, you had the values 10, 20 and 35...
July 20, 2017 at 1:37 pm
Table-type parameters.
July 20, 2017 at 8:20 am
Unless you have some custom monitoring in place recording user errors and what login caused them, you can't tell.
July 20, 2017 at 4:18 am
July 19, 2017 at 4:29 pm
With that level of duplicates, and no foreign keys, easiest is probably to SELECT DISTINCT * INTO <new table> FROM ..., then drop (or rename) the original table, rename the...
July 19, 2017 at 1:33 pm
Look up Linked Servers.
July 19, 2017 at 1:32 pm
Viewing 15 posts - 1,081 through 1,095 (of 49,571 total)