Viewing 15 posts - 16,996 through 17,010 (of 39,902 total)
Good point. I'll change the wording to say what the mistake is. Do you think
- writing single row triggers
or
- not coding triggers for multiple rows
is better?
January 21, 2011 at 11:55 am
If you have a second server, then I would raise the potential issues, but not too hard. Likely you are protected enough for now.
I would make sure the backups move...
January 21, 2011 at 7:16 am
The NULL mistake is that people often write
where a.col = null
instead of
where a.col is null
The multi-row trigger is the same. Developers assume triggers fire once per row, instead of...
January 20, 2011 at 9:25 pm
You really need to read up on how backups work, but here's the basic theory. Lets' assume you back up on Sat for your full. You then have
- Sat Full
-...
January 20, 2011 at 9:24 pm
1) Is that all I need to safeguard the database given that I only need to restore, if necessary, to the previous day or am I missing something?
- All you...
January 20, 2011 at 5:55 pm
Justin 17041 (1/20/2011)
January 20, 2011 at 12:35 pm
Thanks, will be interested to hear if it matches the talk.
January 20, 2011 at 11:34 am
Add the permissions for full control to the Network Service account for that file or folder. Perhaps they are not there.
January 20, 2011 at 11:33 am
Good feedback on this, however I'm more wondering if you think the abstract is well written. Does it make you want to go, or not go, to the session?
January 20, 2011 at 11:30 am
Check under Configuration Manager for the instance and see which account SQL Server runs under. Then check the permissions for that account on that folder.
January 20, 2011 at 10:42 am
One caveat here, it might be good for some things. So maybe you want your remote application to look up product information from a cloud db instead of coming back...
January 20, 2011 at 10:34 am
You likely need something like this:
From Orders o
Inner Join OrderDetails od
ON o.orderid = od.orderid
Inner Join Products p
on...
January 20, 2011 at 10:30 am
New forum for speakers. Critique abstracts and titles. I would love the feedback from people that actually go to sessions and try to decide what's good and bad.
January 20, 2011 at 10:19 am
Stefan Krzywicki (1/20/2011)
My favorite was one that wanted 5+ years experience in VB.Net in 2001.
I think that I saw that job as well. Saw a few similar ones asking for...
January 20, 2011 at 10:08 am
SanDroid (1/20/2011)
The question was the types of restore supported, not the restore commands supported. Wording is everyting in...
January 20, 2011 at 9:39 am
Viewing 15 posts - 16,996 through 17,010 (of 39,902 total)