not saying if code is right or wrong, neither would it matter for the interviewers.

It shows a good attempt at solving the issue even if syntax wise it could be...

• This reply was modified 6 years, 1 month ago by frederico_fonseca.

you have 2 errors.

first the excel result is 2.2892064 and not 22.9 as you mention

second, and this is the important one, your formulas are not the same

last block on excel...

I would say that particular keywords of the create/alter index statement are part of that command definition, not part of the object that is object of the command

object static properties...

• This reply was modified 6 years, 1 month ago by frederico_fonseca.

ok. thanks for the explanation.

Could you also confirm if when a single non mod flags a new thread does it flag it immediately? It seems to me that when I...

I haven't tried it yet since this change but have you also changed it so someone can report the same post more than once? so far on new site we...

when installing the oracle client make sure you select the connectivity tools (oledb and ado). by default they are not selected.

also make sure you did install the 64 bit versions...

on my shop we use group managed service accounts (GMSA) for ALL SQL instances (over 800 of them)- one per service per server

works great and no issues with it.

so server...

issue is that you are not looking for equality but for inequality - hence if either of the conditions is true it meets the criteria

so for your desired result it...

sometimes a google search does answer

https://www.mssqltips.com/sqlservertip/3307/managing-the-size-of-the-sql-server-ssis-catalog-database/

Note that with that size and depending on whether the correct indexes are inplace you may have issues - not sure now which ones but...

No it does not reverse the sql statement - but by using a...

haah.. I wasn't asking for one - just stating that yes he could do it as the others that were asking for it were saying he could not post it...

He can supply it - just needs to use SQL Sentry Plan explorer to anonymize  it before posting here.

If not mistaken that is one I managed to report - once...

if you change your query to

select *
 from @jo j 
inner join @temp t 
on j.txt=t.sait 
order by j.id desc

you will see why

in order to run SSIS packages targeting a particular version of SSIS you do need to have that version installed on the server (or a higher version in some cases...