Using sys.columns cause it should have more than 50 rows. My test DB, I get estimated rows 1, actual 460. That cardinality inaccuracy is what really causes problems with...

Um - you Gail. Hope the suggestion's taken in the way it was meant ...... just thought it was nice and to the point

I'm not saying never use them - hey over the last decade I've even used cursors 3 or 4 times :w00t:. But in general - I find derived tables...

Hi,

in all honesty, I'm puzzled as to why your boss is demanding you use Temp Tables. Personally, I'd consider these a last resort other than the...

Ever thought of expanding that slightly and submitting as an article on here? Seen soooo many posts on forums and usenet where people just fail to grasp the issues...

Andras Belokosztolszki (8/11/2008)

---

Umm - surely that's our job?

Andrew Whettam (8/9/2008)

---

OS & SQL Installation RAID 1

SQL Log files RAID 1 + 0 (not RAID 5 as it has poor write performance)

tempdb RAID 1 + 0 (not RAID 5...

Hi,

yes - you can use EXECUTE AS - see http://msdn.microsoft.com/en-us/library/ms188354.aspx for an explanation

As the why the question is phrased in a rather general way - please forgive the kinda general nature of the answer - if you need something more specific please...

Does the account you are using have appropriate permissions on Master on the target server? Bear in mind thaht datareader and datawriter are not sufficient to access system sp's...

Or alternatively, you could set up an SSIS package to export "TOP 10000000 FROM " set an exported flag on these records and loop until the count on the...

Hi - are you *sure* you don't need transaction log backups? If this is an OLTP database, this would mean if you have a problem during the day, you...

Hi - that's a wide range of things to think about. What are your main aims? Are you a developer in other languages also using SQL, a new...