As I read this a few times I keep asking myself...is this person trying to implement a trigger? You said you use this when a certain value changes, how do...

MyTSQLRepl (7/15/2013)

---

Thank you Sean

Are you saying to use the ackup set table for all the servers in foreach loop? I though there could be a way either by using SQL...

MyTSQLRepl (7/15/2013)

---

Thank you Sean.

This is the way I had earlier but now reqirements and scope have changed. I need to get the lastest backup file size from the backup server...

Check out this table.

select * from msdb.dbo.backupset

Not 100% certain what you are after here but take a look at this. This will parse everything into last, first, middle.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

SomeID...

ajlefort (7/15/2013)

---

Hi,

I need to parse last name,first name space middle name.

Example A - DOE,JOHN

Example B - DOE,JOHN A

I am able to parse the last name.

left(dbo.AbstractData.Name, charindex(',', dbo.AbstractData.Name)-1) as last name

I...

ajlefort (7/15/2013)

---

Hi,

I need to parse last name,first name space middle name.

Example A - DOE,JOHN

Example B - DOE,JOHN A

I am able to parse the last name.

left(dbo.AbstractData.Name, charindex(',', dbo.AbstractData.Name)-1) as last name

I...

chrissorric (7/15/2013)

---

Thank you for your reply and I will read your article about posting

However, both examples fail to evaluate all records in the related table before returning the OrderNum

If an...

dspink (7/15/2013)

---

Also any thoughts on this approach?

Select * INTO T1_Obfuscated FROM T1. (obfuscating only columns needed.) then dropping T1 and renaming T1_Obfuscated to T1. Not really too worried about space...

dale 34292 (7/15/2013)

---

I'll try that, although I have not used it before. However, I am pretty sure it is executing as the log from the script says that it...

Of if you want to use the schema name.

select *

from sys.tables t

join sys.schemas s on t.schema_id = s.schema_id

where s.name = 'YourSchemaName'

Total guess but here is two ways that might work.

select *

from Lab_result_obr_p o

left join Lab_rsults_obx r on o.LabNum = r.LabNem and r.Flag = 'N' and Value <> 'TNP'

where re.LabNem...

dale 34292 (7/15/2013)

---

I have a javascript that uses a sql.execute command to execute a sql insert. The return values show success but no record is inserted. When I...

Thanks Luis for posting the "other" option.

To the OP, which one is better? That is not as simple as it may seem. There are some considerations about the actual...

Many of the things you listed as possibilities are likely to help but probably the biggest performance woe is calling the same scalar function 11 times for 250 million rows....