Hi,

This is an example of denormalised data and it's not good database design for an OLTP database.

In your case, the Orders table should not contain a clientname field at all,...

As far as I understand, you can use log shipping between a 2005 and 2008 database. However, the WITH STANDBY option is not available in this situation as the database...

No, I can't see any mention in BOL, but it's easy enough to demonstrate:

declare @testpattern varchar(max)

set @testpattern=''

select @testpattern=@testpattern+cast(number as varchar) from master..spt_values

where type='p'

print 'length of pattern to search for: '...

I don't believe patindex will work with a pattern term greater than 8k - it's fine if the column being searched is >8k.

Also, for more information on the above, the following areas in BOL should help out:

Configure the SQL Server to listen on a specific port (for security reasons, pick a non-standard...

Hi,

Hope this steers you in the right direction:

1: The port of named instances will generally not be 1433

2: External access is disabled by default, so you would need to enable...

Just wrap the sql to send the email in a IF...BEGIN END

e.g:

if (Some SQL Statement that returns a count of errors) >= 1

begin

print 'send email'

end

else

print 'dont send email'

If you're doing a lot of work with dates and financial years for reporting, I would strongly recommend creating a well indexed date table that you can use as a...

In terms of performance, I think the answer is probably 'it depends'. In my experience they tend to generate pretty similar execution plans so it's often just down to personal...

I have to say, I've never come across this bug before and I script things to clipboard and paste them all the time.

It looks like the bug relates to interpretation...

Incidently, you should be extremely careful in setting sa as the remote login credentials for a linked server as it's almost impossible to restrict users from having sysadmin rights on...

I suspect VSMIADB01 is a linked server that you've either set to use the login's current security context (and you're logged in as sa (tut tut)), or has a hard...

No, they use exactly the same engine - in fact I believe you can even change version by changing a registry key if this hasn't changed since 2005.

The only exceptions...

No problem - make sure you use the code I just edited as the first code messed up your count for number of attempts.

Assuming SessionID is your PK (which I hope it isn't in your real table):

;with CTE as (

select ObjectID,UserID, status, row_number() over (partition by UserID,ObjectID order by SessionDate desc) as sequence...