I have been told by Microsoft to reduce the number of useable CPUs on a box with more than 8 physical processors to 8. SQL 2005 is greedy when...

I wouldn't waste my time with an order by on INSERT, that...

CozyRoc (10/25/2009)

---

You can...

Kwisatz78 (9/8/2009)

---

Ok, I wil make sure I review the recommendations that come out of DTA carefully.

SQLRunner what kind of stats you require? This is a 4 disk RAID 5...

Kwisatz78 (9/7/2009)

---

Hi there thankyou to all for your replies.

SQLRunner - the SQL Buffer cache is %99 and above for the same period.

Marcin Gol - I will set up a new...

If you look closely you will see that by adding recid to the select statement, sql has chosen totally different indexes to search, namely it is using 'Unit_Readings_Unique' in the...

Can you provide information about the server itself? Can you also tell me what your cache hit% is? I would hazard a guess and say that you are...

forum member (9/3/2009)

---

Hi,

Need help with Execute Sql Task,I am using delete statement where it deletes records based on date

DELETE FROM mytesttable

WHERE (CONVERT(VARCHAR, datevar, 103) =...

If you are using sql 2005, and the columns you are interested in are varchar,nvarchar, or varbinary, you can try making a computed column out of the /b HashBytes /b...

Are you by chance running this in 64-bit mode? Excel services can only run in 32-bit mode, so simply make sure you run it using 32-bit mode for execution...

Tim,

This select statement 'Select ACT_BLKDTL'. Is this the 'special' table that contains your passwords or is this the select from the data tables?

Scott (9/3/2009)

---

I've gone down the xp_cmdshell route and it's working. It's a shame as it feels like a much less elegant solution but it's doing the job so I won't...

I will tell you that certain functionality is not compatible with 64-bit, such as Excel Services. Mind you there is no need to go 64-bit. You can run...