Search Results | SQL Server Performance Forums

Database mail w/ HTML format

Post by: neo302, Dec 6, 2006 in forum: SQL Server 2005 General Developer Questions

quote:Originally posted by dineshasanka I have checked this nothing do with code. check your mail server and SMTP Service...

Database mail w/ HTML format

Thread by: neo302, Dec 5, 2006, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hey, I'm trying to send an email in HTML format with a hyperlink. When I include http in it to send a hyperlink, the email does not send. Can...

Weird random error...

Post by: neo302, Oct 19, 2006 in forum: General DBA Questions

quote:Originally posted by satya Check this KBAhttp://support.microsoft.com/?kbid=834849 for further help. Satya SKJ Microsoft SQL Server MVP...

Weird random error...

Thread by: neo302, Oct 18, 2006, 3 replies, in forum: General DBA Questions

Hey, I have a Sql 2000 on Server 2003 running an sp that inserts and updates to a 2005 64 bit DB on Server 2003. The SP has worked forever. No code...

Disable Disk Cache

Post by: neo302, May 19, 2006 in forum: Performance Tuning for Hardware Configurations

quote:Originally posted by joechang [use Lumigent to look through the logs Hey Joe, We have the Dell Perc 4E/Di. We have 3 Raid 0 containers....

Disable Disk Cache

Post by: neo302, May 19, 2006 in forum: Performance Tuning for Hardware Configurations

quote:Originally posted by joechang the OS driver should already have write cache disabled for all disks on the RAID controller, if the controller...

Disable Disk Cache

Thread by: neo302, May 19, 2006, 5 replies, in forum: Performance Tuning for Hardware Configurations

Hey, How do you disable disk caching in Windows? When looking at the policy on the RAID controller, it has the caching selected, but both...

L2 Cache / machine advice

Post by: neo302, May 17, 2006 in forum: Performance Tuning for Hardware Configurations

quote:Originally posted by derrickleggett See what your cache settings are on the RAID controller for the 2005 server. If write cache is enabled,...

L2 Cache / machine advice

Post by: neo302, May 16, 2006 in forum: Performance Tuning for Hardware Configurations

quote:Originally posted by joechang what api is used to do the inserts what do you mean by drop, is there a sql error message, a client api error?...

L2 Cache / machine advice

Thread by: neo302, May 16, 2006, 5 replies, in forum: Performance Tuning for Hardware Configurations

Hey, We have a 2.2 quad proc sql 2000 box w/ 2 megs l2 cache & 4 gigs of ram. A test quad 3.2 w/ 1 meg L2 cache sql 2005 & 8 gigs of ram. The 3.2...

Sql 2005 Tempdb

Post by: neo302, May 11, 2006 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by satya I have followed...

Sql 2005 Inserting

Post by: neo302, May 11, 2006 in forum: T-SQL Performance Tuning for Developers

Hey cmdr_skywalker! Thanks for the script!!!!!! I will run it when things are done for the day. J

Sql 2005 Inserting

Post by: neo302, May 11, 2006 in forum: T-SQL Performance Tuning for Developers

quote:Originally posted by joechang i suggest a proper analysis of the system to determine where the delays are, instead of just guessing and trying...

Sql 2005 Tempdb

Post by: neo302, May 11, 2006 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by thomas Have you got tempdb on a separate physical drive? You need to really for SQL Server 2005 because it's so heavily...

Sql 2005 Tempdb

Thread by: neo302, May 11, 2006, 12 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hey, We do rapid and mostly inserting. We are testing a 2005 box which processes way slower than our 2000 box, although the 2005 box is much better...

Sql 2005 Inserting

Thread by: neo302, May 11, 2006, 5 replies, in forum: T-SQL Performance Tuning for Developers

Hey, We do rapid and mostly inserting. We are testing a 2005 box which processes way slower than our 2000 box, although the 2005 box is much better...