Viewing 15 posts - 18,301 through 18,315 (of 22,202 total)
What is it that you're actually trying to do?
Just so you know, the code you posted ran in 89ms on my desktop (not the fastest machine on earth either).
February 19, 2009 at 6:48 am
It sounds like the database is in FULL recovery mode. So you need to institute log backups. Depending on your data needs, you could set the database to SIMPLE recovery...
February 19, 2009 at 6:45 am
harsha.bhagat1 (2/19/2009)
I have a procedure which has to insert into a table in different database and then will delete those data from the related tables. There are more than...
February 19, 2009 at 6:43 am
OK. Now I have questions. My contacts & calendar are managed through Outlook and my phone (Blackberry currently, going to change soon). Can you sync that with one of these...
February 19, 2009 at 6:21 am
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
It makes me wonder what people do all day at these jobs they've been slogging away at for years.
From prior experience working with people like that,...
February 19, 2009 at 6:19 am
GilaMonster (2/19/2009)
Roy Ernest (2/19/2009)
My problem is the management says I am too tough when giving interviews.
My former management used to tell me the same thing. So I expect that people...
February 19, 2009 at 6:15 am
Nomvula (2/19/2009)
hi guysthanks for the responses, and yes you were right, i got rid of the cursor and used a normal update query and it worked a bit faster..
thanks again
Welcome...
February 19, 2009 at 6:13 am
Excellent article. Thanks. I only wish I could use Firefox at work. Still, this is some interesting stuff. No, I hadn't been using a wiki to manage my info. I'm...
February 19, 2009 at 5:58 am
For many years now I've been doing interviews for senior level DBA's and I've consistently received resumes with between 5-10 years of experience from people. These individuals don't know the...
February 19, 2009 at 5:53 am
Hmmm. That is odd. I had a short period where our local spam blocker was taking out the daily emails, but never the discussion alerts.
Let me know if you got...
February 18, 2009 at 8:40 pm
From the description it sounds like an inline function, but I have to ask, is it? If it's a multi-statement UDF, that could explain the performance issues too.
February 18, 2009 at 6:09 pm
Thoughts?
I wish I was a consultant who worked near your office so I could make all the great money that's going to roll in when those queries have to be...
February 18, 2009 at 6:05 pm
Sorry man, it's just you. You're not really appreciated any more.
Kidding. Seriously, I've been getting my emails fine, so there must be something happening to yours.
February 18, 2009 at 6:02 pm
samalex (2/18/2009)
Thanks for the replies... if you have a moment I have some questions now that I have VS2008 DB Edition installed and have been using it for...
February 18, 2009 at 5:53 pm
GSquared (2/18/2009)
February 18, 2009 at 5:46 pm
Viewing 15 posts - 18,301 through 18,315 (of 22,202 total)