as you can see from my example - i didn't touch the proc - just the UDT

you should really do this on a dev server and send it for test before you even think...

i know since sql 2000 there have been some changes to the way queries are evaluated... you get the same type of errors is you try and insert from a...

My Company is a huge user of Cloud services (we consume about 250Gb of new data a day) and although there are some drawbacks (IO performance is appauling etc) the...

Changing the recovery model to simple is not recommended for the fact it will break the chain of the log in case if you are having log shipping or database...

in that case (depending on how dilligent your test analyst is and what methods/tools they are using for the test) then i would just leave it alone - any...

in that case (depending on how dilligent your test analyst is and what methods/tools they are using for the test) then i would just leave it alone - any...

what kind of testing ?

performance testing (soak, stress, load tests)?

functional testing / Unit testing?

environment/patch deployment testing ?

joe.eager (7/5/2012)

---

I've been beating my head against the wall for a bit with this problem and was wondering if anyone could point me in the right direction.

Background: I was...

are you doing index rebuilds or index reorganisation? it sounds like a rebuild

if it is a rebuild then changing the t-log backup schedule would be pointless as the entire index...

i can see that in some cases using an IF statement might make huge blocks of duplicate code, but i can't see any performance issues

regardless you can do the following...

i think this is 99% correct

with x (name,id,gid)

as

(

select a.name,a.principal_id as id,b.role_principal_id as gid from sys.database_principals a inner join sys.database_role_members b on b.member_principal_id=a.principal_id

where a.principal_id=5

union all

select a.name,a.principal_id as id,b.role_principal_id as gid...

how about in access running a maketable query based on the linked table and then pushing that to your sql server ?

if it's a new development have you considered moving to SQL 2008/2012 and using filestream ?

i've used the file full text search before and it leaves you at the mercy...

or you could just turn the column of data into a CSV format

declare @str varchar(max)=''

select @str=@str+name+',' from syscolumns where....