Viewing 15 posts - 3,601 through 3,615 (of 8,753 total)
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
Did a quick test on my 2nd generation i5 laptop which has 3rd gen. SSD, the ramdisk dbs and tables in a ramdisk filegroup do not yield much of a...
May 10, 2016 at 9:56 am
Lowell (5/10/2016)
there might be a shorter datemath to do the same work,...
May 10, 2016 at 7:22 am
etl2016 (5/10/2016)
I have a requirement where a portion of code either grows or shrinks depending on situation, every time it runs.
For example, on week-1 of a month, it has to...
May 10, 2016 at 5:07 am
Grant Fritchey (5/10/2016)
Brandie Tarvin (5/9/2016)
Ed Wagner (5/9/2016)
Phil Parkin (5/9/2016)
Eirikur Eiriksson (5/9/2016)
Who needs a desk when one can bang ones head against this?😎
Occam's razor clearly does not apply in this case....
May 10, 2016 at 4:20 am
Viewing 15 posts - 3,601 through 3,615 (of 8,753 total)