Viewing 15 posts - 601 through 615 (of 619 total)
Well - usually in QA once it's written. Prototype in MS - then you get that sinking feeling when a colleague comes up to you baffled that someone normally...
August 12, 2008 at 6:41 am
Hi Krish,
have a look at SSIS - very easy to do it using that
August 11, 2008 at 5:43 pm
Do you think of any new features which would be helpful
Personally - since 6.5, I've been waiting for the ability to write a view, and then, when I open it...
August 11, 2008 at 5:22 pm
Hi - forgive me if I'm missing the point of what you're trying to do, but here's my understanding;
Basically - what you're wanting to do is have a login tied...
August 11, 2008 at 5:16 pm
Was thinking of this one
http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
Think we all know how often people seem to get parachuted into 'looking after the database(s)' and over the years I've seen a pretty...
August 11, 2008 at 4:40 pm
On temp tables being used insanely: Yeah! I recently ran into a query that used twenty-one temp tables and six cursors. I changed the whole thing into a...
August 11, 2008 at 3:44 pm
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...
August 11, 2008 at 3:35 pm
Um - you Gail. Hope the suggestion's taken in the way it was meant ...... just thought it was nice and to the point
August 11, 2008 at 2:41 pm
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...
August 11, 2008 at 2:32 pm
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...
August 11, 2008 at 11:52 am
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...
August 11, 2008 at 10:57 am
Andras Belokosztolszki (8/11/2008)
Adam Zacks (8/11/2008)
Very business oriented Gail?
Umm - surely that's our job?
August 11, 2008 at 10:50 am
Andrew Whettam (8/9/2008)
SQL Log files RAID 1 + 0 (not RAID 5 as it has poor write performance)
tempdb RAID 1 + 0 (not RAID 5...
August 11, 2008 at 6:38 am
Hi,
yes - you can use EXECUTE AS - see http://msdn.microsoft.com/en-us/library/ms188354.aspx for an explanation
August 11, 2008 at 5:51 am
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...
August 11, 2008 at 5:46 am
Viewing 15 posts - 601 through 615 (of 619 total)