Viewing 15 posts - 256 through 270 (of 400 total)
GilaMonster (3/19/2011)
nagireddy0024 (3/19/2011)
plz any one rply correct answer.42?
What's the question?
Quote "You are creating a procedure that will update two tables within a transaction. The code looks similar to the following...
March 19, 2011 at 1:54 pm
P.S. I just realized that my earlier post eludes to a Full backup scheme, and I am not doing that any longer. It's now a Filegroup backup scheme....
March 17, 2011 at 2:15 pm
New issue. Database restores and appears to be "Online". I can open it, expand objects, query from it, etc...But - when I then try to run the very...
March 17, 2011 at 1:59 pm
The moment I posted the above, I found the problem. I had mistakenly left this Filegroup in the PRIMARY Filegroup as opposed to the one that was created for it....
March 17, 2011 at 10:52 am
OK - I figured out the issue I was having in restoring my Filegroups. I have to take the db off-line to RESTORE the filegroups - hence why they...
March 17, 2011 at 10:45 am
Ah - I understand now. In the test I did for the restore - I had deleted my main User database, and simply ran the restore it that particular...
March 16, 2011 at 3:29 pm
Hi Craig!
Sorry for any confusion on these multiple points. Yes - I went with a design of between 64mb - 1gb for the .ldf's across the board. that...
March 16, 2011 at 2:50 pm
OK - getting down to the end, and I wanted to run this by you all to get some further input.
I have a really nice looking SQL Server 2005 64-bit...
March 16, 2011 at 2:16 pm
LOL! Thanks for the reminder Craig. Yes - I love SQL so much that I have completely saturated myself as a DBA since last November (worked with it...
March 14, 2011 at 10:27 pm
Grrrrrrrrrr! I'm such an....
Honestly - it's what I still do not know that bothers me the most. Why oh why did I not have this info just 5...
March 14, 2011 at 10:13 pm
I know - this is why I am concerned. When I went into Open Manager (Dell's RAID tool) I was able to configure a RAID 0 disk - one...
March 14, 2011 at 10:00 pm
Craig Farrell (3/14/2011)Yep, but RAID 0 requires two drives, as does RAID 1.
Rut-Roh! How did I get this thing to configure as RAID 0 on a single disk then?!?...
March 14, 2011 at 9:45 pm
Hi Craig!
Thank you so much for this input. I was definitely operating under a very bad, rookie misunderstanding, of how to divide up my objects from DDL creation. ...
March 14, 2011 at 9:21 pm
Oh my. I appear to have learned something the hard way, yet again. I was modifying my db creation scripts as follows...
small table example
/****** Object: Table [dbo].[AlertLog]...
March 14, 2011 at 4:56 pm
March 14, 2011 at 1:46 am
Viewing 15 posts - 256 through 270 (of 400 total)