Viewing 15 posts - 736 through 750 (of 1,219 total)
R. Brush (8/28/2013)
I'm unclear as to how it relates to ChrisCarsonSQL's question.
The correct behavior for an aggregate concatenation query is undefined.
That is, the correct result of the query that...
August 28, 2013 at 2:21 pm
What does "no luck" mean? Error message? Unexpected results?
And if you add PRINT @sql what do you see?
But if the table is small, why not filter on the SQL Server...
August 28, 2013 at 9:02 am
You convert to format 111 which is YYYY/MM/DD, and then you tell Oracle to convert to YYYY-MM-DD, and then it goes downhill from there.
Try format 121 instead.
And if Oracle is...
August 27, 2013 at 4:18 pm
To add what Gail says, you need to run the query once saving the data into a temp table, wait for time, and then run again to compute the delta....
August 27, 2013 at 4:02 pm
ffoerster (8/27/2013)
bcp "table" out nul -n -S192.168.100.230,1433 -T -dTEST -a8000should direct the data output to nul, right?
Yes, but you should also add
> nul
to the command line. Since...
August 27, 2013 at 3:57 pm
ChrisCarsonSQL (8/27/2013)
Erland, would you expand more on why the behavior of the above statement is undefined? Is it because it uses the QUOTENAME function?
No, it is because it uses...
August 27, 2013 at 3:47 pm
rajborntodare (8/27/2013)
this organization installs every instance on D drive. the same path is with D drive
something like this
\D:\Program Files\Microsoft SQL Server\MSSQL11.AGOSQL2K12DEV01\MSSQL\Log\SQLAGENT.OUT
Yes, is there a LOG directory? And in such...
August 27, 2013 at 3:41 pm
And this user is also a user in SQL Server with sysadmin permission?
And you did use SQL Server Configuration Manager to set the service account, didn't you?
August 27, 2013 at 3:39 pm
A two-word answer is: it depends.
That said, generally, using a multi-statement table valued function lowers your odds for good performance, because the optimizer has no clue about how many rows...
August 27, 2013 at 5:25 am
Do you have file C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\SQLAGENT.OUT?
In such case, does it include anything interesting?
Note that the exact path varies depending on your installation. The above assumes a default...
August 27, 2013 at 2:56 am
Eric1/2aB (8/26/2013)
For indexes on GUIDs, an idea is to have a low fill factor, say...
August 26, 2013 at 8:59 am
R. Brush (8/26/2013)
SET @sql = ''SELECT @sql = @sql + ' Truncate table ' + QUOTENAME(TABLE_NAME) + '; ' + CHAR(13)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE @TableNameStartsWith + '%'
Easier to...
August 26, 2013 at 7:37 am
There is always that the caveat that the optimizer might change.
However, it's a little difficult to see why it would happen in this case. Changes in the optimizer are usually...
August 26, 2013 at 7:35 am
Jeff Moden (8/25/2013)
August 26, 2013 at 1:19 am
Glad to hear that there was a happy ending!
August 25, 2013 at 4:28 pm
Viewing 15 posts - 736 through 750 (of 1,219 total)