Viewing 15 posts - 781 through 795 (of 1,219 total)
Judging from the error message, the service account for SQL Agent has problem accessing the AD to validate the user. 0x63 = 110, and NET HELPMSG 110 says:
The system cannot...
August 22, 2013 at 4:17 pm
pandiyarajk.rjpm (8/21/2013)
I tried to sort names in my application.It is strange that W comes in between V :alien:
It's not strange at all! That's how we sort in Swedish(*). In...
August 22, 2013 at 4:13 pm
If you want to collect this data for a specific execution, you need to save the data before execution into a table, and then after execution read the DMV again...
August 22, 2013 at 4:08 pm
SELECT n.software_manufacturer, n.productname, n.productversion, d.licensable
FROM dbo.newtable n
JOIN dbo.datalookuptable d ON d.software_manufacturer = n.software_manufacturer
...
August 22, 2013 at 4:03 pm
Your query is very difficult to read, because you don't prefix every column, and therefore it is difficult to tell where they are coming from.
It also suffers from having...
August 22, 2013 at 3:57 pm
Here is a query that I have canned. It's part of a tool, and the purpose is to return information about all user-defined types. (But I realised today that it...
August 22, 2013 at 3:41 pm
There is something which is amiss here. The code you sent me had no parameters or variables. However, the plans you posted has:
...
August 22, 2013 at 1:34 pm
Procmeister (8/21/2013)
I can hardly believe that the data and log files can be on a UNC Pathname, but not the Filestream.
FILESTREAM data can be exposed to remote clients on a...
August 22, 2013 at 12:32 am
jerome.morris (8/21/2013)
How do I get this to work ? I know the format is M/d/yyyyHH:mm:ss
You think you know. Unless the file is produced by a device, it is almost given...
August 22, 2013 at 12:29 am
I said that you don't need the inner TOP. The outer TOP is sufficient. Hm, it may have an interesting effect on the query plan. Try it!
August 21, 2013 at 4:04 pm
New persopn (2013-08-21)
here in this table 9112177 records are there 6.3gb data is available.
And from where are you running that query? Not SQL Server Management Studio I hope!
The problem is...
August 21, 2013 at 4:02 pm
It should not cause a problem if you stop playing with fire and stop using unsafe date formats. Stick to YYYYMMDD, which is always interpreted the same way.
So in two...
August 21, 2013 at 4:00 pm
You don't really need the inner TOP in the UNION ALL query.
But as Kevin says, the optimizer is not perfect, and it does not shine on queries with OR. I've...
August 21, 2013 at 3:55 pm
aykut canturk (8/21/2013)
August 21, 2013 at 3:51 pm
So what you error message do you get?
Generally, SQL Server does not support databases on remote servers as I recall.
August 21, 2013 at 3:42 pm
Viewing 15 posts - 781 through 795 (of 1,219 total)