Viewing 15 posts - 6,481 through 6,495 (of 13,469 total)
Pretty sure sp_OACreate is limited to an NVarchar(4000) max parameter;
I had written something in SQL 2000 which harvested web pages, and had to grab slices of the results from my...
November 4, 2011 at 12:22 pm
well, the part i was trying to talk about was the screenshot below; see the difference for the "good enough plan found" vs the other that did not find a...
November 4, 2011 at 9:46 am
i had to use winmerge to be sure, the two files you posted are identical; could you have copied the same plan as two different names?
November 4, 2011 at 9:14 am
Cadavre I love how you add the million row test harnesses to your examples...
I may start adding that to some of my posts as well in the future.
Thanks buddy!
November 4, 2011 at 8:03 am
mikes84 (11/4/2011)[hrLowell,
So are you saying that this type of comparison, row over row (as in the EXCEPT clause and my second example):
Table 1 fields
-------------
Table 2 fields
is usually better than this...
November 4, 2011 at 7:52 am
in 2008 and above, i think the expectation is to start switching over to CLR;
here's the CLR equivilent of xp_GetFileDetails:
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.IO
Namespace Enterprise.SqlServer.Server
...
November 4, 2011 at 7:34 am
i think you want to look at the EXCEPT operator;
if all the columns are the same, it might look like this:
--find what doesn't match from Table2
SELECT PK,ColumnList FROM Table1
EXCEPT
SELECT PK,ColumnList...
November 4, 2011 at 7:31 am
A couple of Grant Fitychey's presentations he did on execution plans might be relevant;
as i remember it, the key to look for is the property "Reason For Early Termination of...
November 4, 2011 at 6:28 am
chandraa.bollineni (11/4/2011)
Thanks for your reply.
I already checked in this way and it's already fixed those settings like both failed and successful logins.But i am not able to see what are...
November 4, 2011 at 5:29 am
would they be asking you to use a DMV like sys.dm_exec_sessionsto get the column host_process_id?
I think that would require querying all four instances, right?
for example, ran Windows Task Manager and...
November 4, 2011 at 5:16 am
Jack this was a double post;
In another thread we tracked down the issue:
November 3, 2011 at 2:09 pm
sure but you'll have to make sure you always wrap it in brackets when refering to it:
WHERE [Fixed/Float/Step (Interest Rate Type)] = 42
to avoid that, you want to go witht...
November 3, 2011 at 1:38 pm
you'll want to script the table out from the source, including indexes, and create it on the destination database.
then you can use the import/export wizard,and change the step that says...
November 3, 2011 at 1:06 pm
sturner (11/3/2011)
Things you can do to make the import operation as efficient as possible:
1) put the database...
November 3, 2011 at 12:47 pm
glad you got it fixed!
sometimes the "obvious fix" for an issue is, well, not really that obvious.
November 3, 2011 at 10:50 am
Viewing 15 posts - 6,481 through 6,495 (of 13,469 total)