Viewing 15 posts - 511 through 525 (of 673 total)
Mad Hacker (1/20/2011)
January 20, 2011 at 10:35 am
Fraggle-805517 (1/20/2011)
SanDroid (1/20/2011)
Also please post "exec sp_configure".
If you could also tell us the size of the Page file, #CPU's, size of...
January 20, 2011 at 9:34 am
Fraggle-805517 (1/20/2011)
PageFile is 4.3GB on the C drive which is a RAID 10
TempDB is a logical drive off of the Primary C drive above.
.MDF files...
January 20, 2011 at 7:43 am
Can you post the return of the "SELECT @@version" command
Also please post "exec sp_configure".
If you could also tell us the size of the Page file, #CPU's, size of system drive.
My...
January 20, 2011 at 7:33 am
GilaMonster (1/17/2011)
SanDroid (1/17/2011)
Not certain who is learning.Restoring a group of pages can restore an extent.
There is no RESTORE DATABASE ... EXTENT command. There is a RESTORE DATABASE ... FILEGROUP, a...
January 20, 2011 at 7:17 am
Steve Jones - SSC Editor (1/19/2011)
I miss the "submit a note" item at the top right for the online BOL
So do I. Unfortunate that a large percentage of...
January 20, 2011 at 7:11 am
sqldba_icon (1/18/2011)
Actually it is 20 writes and 7934149300 reads for one execution. In any scenario would it be normal for7934149300 reads and 20 writes.
It all depends on the query...
January 20, 2011 at 7:04 am
One thing that is ofter overlooked is the CPU has to maps and control memory addressing. More System memory = more time the CPU needs to work it.
I...
January 20, 2011 at 6:51 am
bitbucket-25253 (1/16/2011)
So once again the QOD becomes a teaching tool.
Not certain who is learning.
Restoring a group of pages can restore an extent.
Are all the answers actual Restore command types as...
January 17, 2011 at 3:32 pm
Eric Russell 13013 (1/17/2011)
January 17, 2011 at 3:27 pm
Steve,
An extent is nothing more that a group of eight contiguous database pages.
Since Page restore can be used to restore one or more damaged pages, it can restore any extent...
January 17, 2011 at 8:35 am
Data security starts at data access.
If an unwanted user can access the data, it is not secure. PowerPivot does not change this.
It might in some cases...
January 17, 2011 at 7:59 am
The cloud, and it's issues, are as old as the mouse. However I have found that my mouse is more reliable than any cloud service I have used. ...
January 12, 2011 at 7:33 am
Tom.Thomson (1/11/2011)
Hugo Kornelis (1/11/2011)
Did I misinterpret the documentation? Or is Tom incorrect? (Christian's test code suggests the latter).
I think you are right - I got it wrong. Mea maxima...
January 11, 2011 at 8:22 am
Nice question. I also did not quite understand if the question meant could this be done with a trigger, or could you actually update the inserted table to change...
January 10, 2011 at 8:14 am
Viewing 15 posts - 511 through 525 (of 673 total)