Viewing 15 posts - 1,921 through 1,935 (of 49,557 total)
darshan.joshi29 (12/28/2016)
5.sanity check of application with 2016 version database.
Testing should be the first thing done, in a dev/test environment, long before the production server is touched. If you test...
January 10, 2017 at 2:16 am
What's your concern with replication?
January 10, 2017 at 2:14 am
Mail the dev team and ask nicely. (not joking, this isn't something they've disclosed afaik)
January 9, 2017 at 9:19 am
Snargables (1/9/2017)
So when you say wrap around are u speaking of just the that column or all of them?
The sample_ms, the one you were asking about.
The other columns...
January 9, 2017 at 8:50 am
When you can remove the join hints and get us an execution plan, please post back. Until then, there's nothing we can really do with that query.
Nolock hints mean that...
January 9, 2017 at 8:40 am
FROM sys.tables WHERE name NOT IN (<list of tables to be excluded>);
January 9, 2017 at 7:44 am
Start by taking out the nolock hints (they allow the query to return incorrect data) and the join hints so that the optimiser is free to choose a good query...
January 9, 2017 at 7:40 am
Snargables (1/9/2017)
January 9, 2017 at 7:30 am
aalberyo (1/9/2017)
January 9, 2017 at 7:28 am
Uninstall the RC (hope that it uninstalls cleanly) and install the RTM. The RCs don't always support upgrades, especially not to the final release version.
Personally I install CTPs and RCs...
January 9, 2017 at 5:40 am
JasonClark (1/8/2017)
You may use this statement to check the virtual I/O file statesSELECT * FROM sys.dm_io_virtual_file_stats (NULL, NULL);
GO
This shows you how many I/Os occurred, with latencies for all the files.
Only...
January 9, 2017 at 5:36 am
January 9, 2017 at 5:35 am
It's probably an execution plan change, possibly triggered by data volume changes.
Do you have any record of what the queries were running like before this?
Do you have...
January 6, 2017 at 6:35 am
The CXPacket wait is not a problem. sys.dm_exec_requests only shows thread 0 of a parallel query and, as I explained above, thread 0 is the controller thread. It will always...
January 6, 2017 at 6:09 am
Before we go on, what exactly are you declaring to be the issue?
January 6, 2017 at 4:46 am
Viewing 15 posts - 1,921 through 1,935 (of 49,557 total)