Microprocessor


What does this return? declare @i int select @i = -5 select +@i

-5
This will return -5 as the result. The + operator functions as a unary plus operator, which means that it performs no operation on the value it preceeds.

By on September 13, 2010 | Microprocessor

Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?

DDL triggers
DDL triggers cannot be signed, but all the other objects can.

By on | Microprocessor

If you received a “Performance Critical” status in the SQL Server 2005 replication monitor, what does this mean?

The latency between transaction commits at the publisher and subscriber exceeds the warning level.
This status can actually mean two different things. Either the latency between the commit of a transaction at the publisher and the same commit at the subscriber is exceeding some level in a transactional level or not enough rows are being processed in a merge replication scenario.

By on | Microprocessor

The Sort component in SQL Server 2005 Integration Services is what type of component?

Blocking Transformation
The Sort component is a blocking transformation meaning that it needs all rows in order to perform its function.

By on | Microprocessor

What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?

Add, string concatenation, unary plus
The three functions are Add, String Concatenation, and Unary Plus.

By on | Microprocessor

What does the Queue Reader Agent do in SQL Server 2005 replication?

This agent reads the subscriber logs and moves changes back to the publisher.
This agent is used when the queued update model is chosen with transactional replication. It moves changes from the subscribers back to the publishers.

By on | Microprocessor

How many rows are returned by these two select statements?

2 and 2
Each select statement actually returns 2 rows. You can use this script to check this:
create table mytable
( id int identity(1,1)
, mychar varchar(20)
)
go
insert mytable select null
insert mytable select ”
insert mytable select ‘ ‘
go
set ansi_nulls on
set ansi_null_dflt_on on
select * from mytable
where mychar is not null
select * from mytable
where mychar <> ” and mychar is not null
select * from mytable
where mychar <> ‘ ‘ and mychar is not null
select * from mytable where mychar = ”
select * from mytable where mychar = ‘ ‘
set ansi_null_dflt_on off
set ansi_nulls off
go
drop table mytable

By on | Microprocessor

If you run this, what does it return? select applock_mode(‘public’, ‘SalesApp’, ‘Transaction’)

The type of lock being held by an application that requested it.
This command returns the lock mode held by an application that was requested with the sp_getapplock procedure.

insert mytable select ”
insert mytable select ‘ ‘
select * from mytable where mychar = ”
select * from mytable where mychar = ‘ ‘

By on | Microprocessor

How does a differential backup know which extents have changed so that it can be very quickly run?

The DCM tracks changes. The differential backup reads the extents from this structure.
A differential backup uses the Differential Change Map to determine which extents have changed and need to be include in the backup. This greatly speeds the differential backup process.

By on | Microprocessor

What the heck does ATN2 do?

The angle between the x-axis and a ray.
This is a mathematical function that returns the angle between the positive x-axis and the ray that passes through the two coordinates passed in. The angle is in radians.

By on | Microprocessor

Copy Protected by Send free sms - Love2sms.