Viewing 15 posts - 3,601 through 3,615 (of 8,761 total)
Grant Fritchey (5/11/2016)
Eirikur Eiriksson (5/11/2016)
Grant Fritchey (5/11/2016)
My guess is, you may have hit some bad parameter sniffing on the query that was...
May 11, 2016 at 9:32 am
GilaMonster (5/11/2016)
Eirikur Eiriksson (5/10/2016)
One could argue that 153000 userlookups indicates that other indices should be created, key lookup is quite expensive operation.
Since key lookups are only ever done to the...
May 11, 2016 at 9:23 am
Grant Fritchey (5/11/2016)
My guess is, you may have hit some bad parameter sniffing on the query that was running fast previous to...
May 11, 2016 at 9:10 am
Phil Parkin (5/11/2016)
Eirikur Eiriksson (5/11/2016)
Sean Lange (5/11/2016)
May 11, 2016 at 9:04 am
By the looks of it this elementary, is this the real problem?
😎
May 11, 2016 at 8:11 am
jigging.tech (5/11/2016)
We have a database which sadly is a heap (can't change because it's a vendor database).
We added a non-clustered index to the table in order to speed up...
May 11, 2016 at 7:42 am
Sean Lange (5/11/2016)
May 11, 2016 at 7:41 am
Sean Lange (5/11/2016)
Ed Wagner (5/11/2016)
Sean Lange (5/10/2016)
Eirikur Eiriksson (5/10/2016)
Luis Cazares (5/10/2016)
Lynn Pettis (5/10/2016)
Eirikur Eiriksson (5/10/2016)
Michael L John (5/10/2016)
Lynn Pettis (5/10/2016)
May 11, 2016 at 7:16 am
onlo (5/10/2016)
My SQL 2014 is running on VM. So, all of its disk drives, actually, are using the same disk system.
It...
May 10, 2016 at 9:59 pm
With Alan's correction on the quotation and an additional correction in the value path then this works
😎
SELECT
data.value (
'(/event/data [@name="statement"]/value)[1]', 'varchar(max)') AS [SQLText]
...
May 10, 2016 at 9:23 pm
Luis Cazares (5/10/2016)
Check this: https://connect.microsoft.com/SQLServer/feedback/details/737341/sql-server-2012-openrowset-on-msdb-dbo-sp-help-job-throws-errorIt includes a workaround posted in here: https://blogs.msdn.microsoft.com/sqlagent/2012/07/12/workaround-sql-server-2012-openrowset-on-sp_help_job-throws-the-metadata-could-not-be-determined/
Blast you are fast Luis, I was still typing an identical message when I saw yours
😎
Even have the connect...
May 10, 2016 at 2:08 pm
Luis Cazares (5/10/2016)
Lynn Pettis (5/10/2016)
Eirikur Eiriksson (5/10/2016)
Michael L John (5/10/2016)
Lynn Pettis (5/10/2016)
May 10, 2016 at 2:05 pm
Michael L John (5/10/2016)
Lynn Pettis (5/10/2016)
May 10, 2016 at 1:50 pm
rk1980factor (5/10/2016)
I tried that and now it gives me this error message:Msg 245, Level 16, State 1, Line 4
Conversion failed when converting the varchar value 'PR001' to data type int.
Guess...
May 10, 2016 at 10:55 am
Tac11 (5/10/2016)
Index id = 1 (datatype...
May 10, 2016 at 10:46 am
Viewing 15 posts - 3,601 through 3,615 (of 8,761 total)