here is the link

http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

as long as u follow the principle of least privileges using a sql login shouldnt be too much of a problem.

ideally u want :-

domain account > login> db user> application...

The below link shud be a good place to start

http://msdn.microsoft.com/en-us/library/ms177411%28SQL.105%29.aspx

Partitioning is best for performance when placed on multiple drives with a suitable raid level.

else the best way to save IO...

have u tried running the queries thur DTA. It shoudl work out easier.

being a DBA nowadays is much more than performance tuning and recovery models. I know guys who are dedicated to HA while others are migration experts or build and deployment...

you won't get all columns by default unless you have selected the option for show all columns , the important thing to remember here is that the columns which get...

if your doing this as part of managing multiple servers you can try using cms and query the sys tables directly

in the ssis package the way to go and the data flow tasks have everything u need. ideally you might still want to consider bringing the data from the othe...

if you have a column other than the date time which can be used to identify the deltas that would be your best bet, Mainly becuase datetimes have problems with...

yes , i would go with except or the MERGE statment to idetify and insert the delta

without knowing the ddl and sample data its difficult to give you an answer but you could try this ( modify further as required).

update spc

set tiempo_partida_cliente= d.sums

from spotPartidaCliente spc...

Waiting for the first service pack 😀

the only other thing i can think of would be collations.

I am thinking recursive CTE, something like

create table #tempstore(

id int , counts int , texts char(1)

)

insert into #tempstore

select 1 , 4 , 'a'

union all

select 2,5,'b'

;

with cte as (select id...

I am guessing here , but have you looked closer at what the trigger is doing ?