Viewing 15 posts - 23,431 through 23,445 (of 39,819 total)
Ravi,
We do make articles in books a few times a year available for download, but it takes time and resources to reformat them. Also, if we make Word/PDF versions available,...
June 16, 2009 at 8:49 am
Good point, I'll add a couple IF items now. Well, as soon as I figure out how to use Google to find the tags 😉
June 16, 2009 at 8:48 am
Always start with Books Online. They always have the basics in there. After that, there are some good whitepapers on Log Shipping and mirroring on MSDN
June 16, 2009 at 8:47 am
OK, walking a line here. I know a lot of people in PASS, especially the Board, so I hear things that I'm not sure should be public. So, I can't...
June 16, 2009 at 8:39 am
I was expecting these types of responses, but I wasn't sure quite how I wanted to frame this. And Mr. Blandry, wrist slap noted and it stings!:hehe:
We definitely have to...
June 16, 2009 at 8:34 am
It's possible that you have machine (OS/hardware ) issues. One quick check, swap the network cable out.
Beyond that, can she log in from another machine? Can you log in from...
June 16, 2009 at 8:25 am
there are issues with the VLFs sometimes. You can use this script to try and shrink things. Note that it will mess with your log and backups, so I'd plan...
June 16, 2009 at 8:22 am
I don't think I'd advocate trashing existing systems and moving to VMs for many people at all. Instead I'd start learning about it, and perhaps shifting some systems to VMs...
June 15, 2009 at 4:48 pm
It sounds like you're in a bad situation. Honestly, you are playing with fire here. One issue, and it's possible that you will be without data, and then without a...
June 15, 2009 at 4:28 pm
I think if the transaction fails with a full tempdb log, it gets rolled back. It seems to me I've seen that written somewhere.
Can you make the job fail? It...
June 15, 2009 at 4:16 pm
There are absolutely systems with multiple inserts in a split second, and it's not 1000 needed, it's 2 that can cause issues.
I still don't see a reason why identity won't...
June 15, 2009 at 3:45 pm
I'd agree that you shouldn't mess with the design, and I'd also be careful about basing things on date. Dups will occur, and then you'll be in the case where...
June 15, 2009 at 3:26 pm
Well, I for one, am sad the NBA ended last night. I was rooting for a Laker's chapionship, but in 6 or 7 games.
June 15, 2009 at 3:23 pm
Based on that, I think you want the application to generate the flat file and then save it to the server. It doesn't need to have SQL Server generate it.
June 15, 2009 at 2:39 pm
Viewing 15 posts - 23,431 through 23,445 (of 39,819 total)