Viewing 15 posts - 1 through 15 (of 15 total)
Was the Report Server that is not used and has now been turned off.
Thank you!
February 16, 2008 at 9:43 am
Then you would just restore that page from your last backup.
Wait, you're saying this thing has a backup feature? :w00t:
February 13, 2008 at 6:45 pm
Ok, this will really light your fire :hehe:
The reason I was asking is becuase it's my database, for my company, that I manage the db for, because I'm anal when...
February 13, 2008 at 5:42 pm
I think having proper code should be assumed. My original question was asked so that I can properly setup a new db and not worry about adding multiple files later...
February 13, 2008 at 3:52 pm
That was it alright. I really appreciate the help!
February 11, 2008 at 10:41 am
Not possible in my case. I think what I will do is just pass each xml node into tables individually and work with the data from there. Unless...
February 9, 2008 at 8:08 am
Mark (2/8/2008)
Does this help?
Select r.value('local-name(.)','varchar(20)') as Name,r.value('(text())[1]','varchar(100)') as Value
From @X.nodes('//*') as x(r)
Now we're cooking! Any chance that could be turned...
February 8, 2008 at 1:38 pm
Yes I know that, I'm using it in my example above. But how can I display the results of the variable using XQuery, the same way I do in...
February 7, 2008 at 5:27 pm
I think I may not have been clear on this. I am not trying to pass a table into a procedure as a single variable. I am trying to take...
February 4, 2008 at 8:10 am
I found another MS page on this. Interesting thing about this page is that is says:
http://msdn2.microsoft.com/en-us/library/ms187087.aspx
"Most databases will work well with a single data file and a single transaction log...
January 28, 2008 at 10:01 pm
I appreciate the info, I was just wondering why MS would put that out there if the experts say not to. Sounds to me like a case of MS generalizing...
January 28, 2008 at 4:39 pm
I respectfully disagree that they are saying "do it based on your disk configuration and how many disks you have". I'm not saying you are wrong, but I have...
January 28, 2008 at 11:53 am
I understand how the various Raid's work, but what I still do not understand is why would I not want to follow MS best practice (as well as what Dell...
January 28, 2008 at 10:08 am
I think what confuses me the most is why it is recommended to put one file per core on TEMPDB knowing that 9 times out of 10 (I'm guessing) it...
January 28, 2008 at 9:18 am
Ok, now I'm really stumped. Microsoft has setting up to one data file per cpu in their top 10 best practices. (# 8) http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
I have also read...
January 28, 2008 at 8:42 am
Viewing 15 posts - 1 through 15 (of 15 total)