Viewing 15 posts - 811 through 825 (of 1,033 total)
CREATE TABLE [dbo].[UPR00900](
Hmmm with names like those... let me guess.. Great Plains?
I find it sad that Microsoft makes very poor design mistakes like this stuff.. I'm getting used to it...
August 7, 2009 at 2:02 pm
Scott Coleman (8/6/2009)
This was an interesting question, it's a shame it was so horribly written. The statements are all incomplete phrases so they don't really have a truth value.
Thanks...
August 6, 2009 at 12:30 pm
Here's how to write the True/False type statements to work within the context of the question
A 823 error such as a disk error may write records to the table.
A 824...
August 6, 2009 at 10:16 am
True with regard to what?
Here are the answers provided. Tell me how they are true or not with regard to the above question.
Introduced in SQL Server 2005, the suspect_pages...
August 6, 2009 at 10:05 am
The author asks this question
Introduced in SQL Server 2005, the suspect_pages table records pages considered to be suspect. Select all statements which are true as applied to this table
DBCC CHECKDB...
August 6, 2009 at 8:29 am
SQL Dev (8/3/2009)
Hi friends...Here also same problem...even though i configure minimum and maximum server memories...using sp_configure
If you used sp_configure to change the memory allocated, did you then run RECONFIGURE in...
August 4, 2009 at 10:18 am
GilaMonster (7/27/2009)
Pretty much the only thing...
July 28, 2009 at 9:39 am
The Garbage collection process is also a correct answer.
]SQL Server 2005 Books Online April 2006 Help File
July 28, 2009 at 9:35 am
Hyperbac is licensed per physical node running SQL, so every node in a cluster that you want to do the backups on requires it.
i.e. if you had a 6 node...
July 28, 2009 at 7:38 am
3.0.22.0
We probably should upgrade it... but in the realm of "when it works" we tend to leave things like this alone.
July 24, 2009 at 10:20 am
Where I am now, we tend to roll our own...
Which I'm not a big fan of.
Prior to that I was well versed with the Business Objects (now a division...
July 24, 2009 at 8:47 am
george sibbald (7/23/2009)
I did email hyperbac and they responded promptly, striping and maxtransfersize suggestions were theirs, but that does not really cut it and...
July 24, 2009 at 8:42 am
Don't have much to worry about there... our backups are shipped off of the server nightly, so when doing a restore, they have to be copied back to a staging...
July 16, 2009 at 12:32 pm
Steve Jones - Editor (7/16/2009)
Need to teach those techs how to run with scripts (DMVs, sys., etc) rather than SSMS!
Granted they can run a backup and/or restore via SQL... but...
July 16, 2009 at 9:54 am
YaHozna (7/16/2009)
July 16, 2009 at 8:25 am
Viewing 15 posts - 811 through 825 (of 1,033 total)