Clustering

RE: SMTP and sp_MakeWebTask

• by Brian Knight

• SQLServerCentral

• Reply

Hi David, we're about to convert to Lyris ourselves. It and many other newsletter software tools (we use G-Lock software right now) can send out a dual-message in the same message. One is for the clients with no HTML the other for HTML. One thing to watch out for is Outlook 2003 will not allow […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-29

1 reads

RE: Evaluating a string arithmatic expression

• by Dave

• SQL Server Performance

• Reply

Hey try this surreal solution. I doubt perfomance would justify it. SELECT ((CASE WHEN CHARINDEX('h',elapsedtime)>0 THEN CAST(LEFT(elapsedtime,CHARINDEX('h',elapsedtime)-1) AS int) ELSE 0 END) * 3600)+ ((CASE WHEN CHARINDEX('m',elapsedtime)>0 THEN CAST(SUBSTRING(elapsedtime,(CASE WHEN CHARINDEX('h',elapsedtime)>0 THEN CHARINDEX('h',elapsedtime)+2 ELSE 1 END),CHARINDEX('m',elapsedtime)-(CASE WHEN CHARINDEX('h',elapsedtime)>0 THEN CHARINDEX('h',elapsedtime)+2 ELSE 1 END)) AS int) ELSE 0 END) * 60)+ CAST(SUBSTRING(elapsedtime,(CASE WHEN CHARINDEX('m',elapsedtime)>0 THEN CHARINDEX('m',elapsedtime)+2 […]

2003-05-28

RE: Pinning a table/index to memory

• by Andy Warren

• SearchSQLServer

• Reply

DBCC Pintable. Andy http://qa.sqlservercentral.com/columnists/awarren/

2003-05-24

1 reads

RE: Thanks for taking the test!

• by Lakusha

• SQL Server Performance

• Reply

I enjoyed the test. Was surprised not to see any question about SPN and kerberos authentification. This is one of the more confusing aspect of sequel security.

2003-05-22

RE: Thanks for taking the test!

• by efelito

• SearchSQLServer

• Reply

Good test. Had to take a little time to think things through. I flip flopped my thoughts on revoke vs deny, so I missed those two and I've never use the C2 audit setting, so I just guessed that it would be stored in the logs directory. Now I know! I'll be waiting for my […]

2003-05-22

RE: Error 17052: SQL Server has been optimized for 8

• by karifsmith

• SQLServerCentral.com

• Reply

Thanks for the suggestion! I am looking into what it will take for us to get Standard Edition installed. Thanks again!!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-14