I think the answer is 5, can also be considered correct

or am i wrong?

I think the same thing

AS Alias And AS 'Alias'

also i can write AS [Alias], or write CTE

so there are only three ways: "=", "AS" and column

I got an error: "String or binary data would be truncated. The statement has been terminated."

(0 row(s) affected);-)

Select a.code, a.price, (price * percent * case when check = 1 then 1 else 8 end) as new_field

From a,b

Where a.code = b.code

?

the answer is ambiguous and depends from collations

get my point back 🙂

This article helped me

http://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspx

show the script to create linked servers

too mach scans

select

*

from

reporthistory rh

where

not exists (select * from reporthistory rh1 where rh1.Report_id = rh.Report_id and rh1.ReportHistoryID > rh.ReportHistoryID)

and (select top 1 rh1.Report_status_id from reporthistory rh1 where...

try to use

Multiserver Administration

or if you have a MSSQL2008

Administer Multiple Servers Using Central Management Servers

support-555807 (8/22/2012)

---

is it possible to update values based on a wildcard? For instance, I have many dates in the database that are all formatted with different criteria and I want...

I think no

1. if you reduce the number of events to a minimum, the load will be minimal

read this article Finding the Causes of Poor Performance in SQL Server, Part...

have you checked all the processes from all users?

use "tasklist"

MSSQL does not have built-in diagnostics.

but you can create your own based on sp_trace_create and etc. or use Profiler

declare @temptabnew table (id int, name varchar(50), datestarted datetime)

declare @temptabold table (id int, name varchar(50), datestarted datetime)

insert into @temptabnew values (1, 'John Smith', '2000-01-01')

insert into @temptabnew values...

select @@VERSION

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1...