Viewing 15 posts - 32,656 through 32,670 (of 39,740 total)
My apologies. I've made some security changes and removed the offending script.
Steve
January 11, 2007 at 3:51 pm
I like the above advice. There are times a job is just a job. Look for a challenge elsewhere, either in technology or outside it.
If you're really bored, maybe take...
January 9, 2007 at 10:14 am
Thanks for the comments.
They don't "hold" the book for you. At least not for me. I've added stuff to my cart and then been notified that it's out of...
January 9, 2007 at 6:34 am
I'd call MS support for this. Sounds like maybe they either changed functionality or it's a bug in the SP.
January 8, 2007 at 9:28 am
select top 6 newid(), col1, col2
from table
order by newid()
January 5, 2007 at 2:46 pm
3-4M rows a day shouldn't be too bad. Are your quieries indexed? I'd start trying to optimize those, but don't make too many indexes with that many rows. 3-4 max.
January 5, 2007 at 10:13 am
If you do updates through stored procedures, make the change there. If you have updates through T-SQL and want to be sure they are captured, use a trigger.
January 5, 2007 at 10:07 am
I've seen something similar when the secure channel between teh SQL server and the domain controller is broken. Can't authenticate. Is this a new user? Or someone that hasn't logged...
January 5, 2007 at 9:56 am
Thanks for the replies and it's interesting to read.
Luke! Send me some SQL-Beer samples and I'll get them reviewed for the site! Always on the lookout for new and interesting...
January 5, 2007 at 9:01 am
Congrats on the MS job. Let us know how it goes if you can.
January 4, 2007 at 5:55 pm
I've tended to use different accounts for each server. Since you rarely set them up, it works well. Store the passwords in Password Safe or something similar and then yo...
January 4, 2007 at 11:12 am
If you have multiple statements in the task, they're each separate. When you run the proc, the temp table exists, but it should go out of scope when the proc...
January 4, 2007 at 9:12 am
You could use a subquery.
Delete from a
where a.pk not in (select b.pk from b where a.xx = b.xx)
Something like that. You'd have to work out the joins you...
January 4, 2007 at 9:10 am
Viewing 15 posts - 32,656 through 32,670 (of 39,740 total)