I would think that your networking people are a bit upset with you 3 times per day. That is quite a load, performing a full backup and restoral across thenetwork....

:crazy: My problem with the answer is that everywhere you read about B-tree, that I have found, does not use the term balanced. There are many...

:w00t:Great question - thought provoking. Had to re-read a couple of times

Excellent question - made me think, got it wrong, then learned something.

Sorry, the link did not show up:

http://msdn.microsoft.com/en-us/library/aa337311(SQL.90).aspx

There could be several reasons for the memory error. Automatically increasing the pagefile is not necessarily the best thing to do. It should be at a minimum equal to the...

Very good question - makes one think, but I have to agree with Adi Cohn though, that the last potential answer is wrong. The REPAIR_ALLOW_DATA_LOSS is a parameter passed to...

I had the correct answer as well, until I reread the question, which specifically said to run that code, and actually had a correct answer to it. Thus, 40% of...

The question was about running the code. The code will not run the way it is written. Afte getting it wrong, I tried the code and received an error. Thus,...

Amazing, I ran the code which supposedly has a typo, and the results were:

Em Ma

---------- ----------

Vyas ...

I setup a table with the same field names, and primary key as the table which I am replicating from. This is required in order to perform replication.

Fortunately though,...

As I. That is why I did not elaborate. I was able to monitor exactly what Crystal does through a Lanalyzer - it was amazing, but keep in mind that...

Gotchas are the expense in having multiple servers, as for indexing, each table is indexed to meet it's needs whether on the OLTP or BA side.

ETL tools may work -...

In an attempt to create harmony, I use trasnactional replication, preventing the OLTP side of the house from interfering with the BA side on larger databases. In some cases...

I should have read the responses before answering - I also must have missed that class, but when did MTX become part of T-SQL? Everyone who answered without the "exception"...