Viewing 15 posts - 2,251 through 2,265 (of 49,571 total)
Stefan LG (10/10/2016)
Companies might also provide incentive in terms of money to employees that publish articles on public forums.
Mine does that, and they don't require any name dropping at all.
October 11, 2016 at 3:52 am
Here's the query formatted to be readable. A single query roughly 850 lines long. Tuning that will take a professional days, and will probably involve splitting the query up into...
October 11, 2016 at 3:45 am
John Roy Ellis (10/10/2016)
Since I had never...
October 11, 2016 at 3:36 am
Brandie Tarvin (10/10/2016)
Hugo, are you heading west (over the Atlantic) or east (over the Pacific) on your Amsterdam to Seattle leg?
North. The flight goes over Greenland and Canada. Doesn't technically...
October 10, 2016 at 12:33 pm
No worries, deadlocks can get fairly hairy.
Shameless self-promotion: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
October 10, 2016 at 12:29 pm
You're misreading the deadlock graph.
The session running the select holds an S lock , and it's requesting an S lock.
The select is process5696e08
resource-list
pagelock fileid=5 pageid=96510 dbid=5 objectname=<DBName>.<schema>.Vehicles...
October 10, 2016 at 10:41 am
Also keep in mind that RPC completed is fired when the application calls a procedure directly procedure. If the application calls a procedure which then calls the one you're investigating,...
October 10, 2016 at 8:14 am
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
And seconding Grant, plan costs are NOT durations and not a good indication of duration
October 10, 2016 at 6:57 am
rodjkidd (10/10/2016)
You aren't flying Delta are you on your flight out?
Hell no. After their mess last year I'm done with Delta. Standardising to BA for all flights, local and international...
October 10, 2016 at 5:45 am
Ah, why not.
I get to Seattle Sunday 23rd Oct (via London)
Monday afternoon: Jason's Freecon (monday morning = sleeping in)
Tuesday probably Pass UG and/Or SQLSaturday meetings, though my UG leader is...
October 10, 2016 at 4:41 am
You need to test carefully. One of the changes to SQL 2014 was to the query optimiser. Most queries either improve slightly in performance or stay the same, but you...
October 10, 2016 at 3:42 am
Whatever the podcast or lecture that I'm listening to is about.
I listen to Dot Net Rocks, RunAs Radio, Writing Excuses and, when I run out of podcasts, university lectures via...
October 10, 2016 at 2:46 am
Ramdas Baghel (10/9/2016)
Is there anyway to find query completion time (how much time query took to complete) FROM Actual Query Plan?
No, there is not.
Besides, a plan extracted from cache...
October 10, 2016 at 2:38 am
mnadirwk (10/6/2016)
add MAXTRANSFERSIZE= 1048576
Why?
October 6, 2016 at 3:42 pm
ChrisM@home (10/6/2016)
Sure you could mess it all up by adding something rowcount-sensitive to the query
Like a key lookup due to a noncovering index on that single table. Yes, the trivial...
October 6, 2016 at 3:37 pm
Viewing 15 posts - 2,251 through 2,265 (of 49,571 total)