I have an idea. Since taxes may be a big concern, perhaps it best that everyone withdraw from the contest. I would be happy to be the default...

The taxes you may have to pay vary from country to country as well as by income level. In Canada taxes aren't a concern since prize money isn't considered...

At other points in my life I would have taken the cash, but now I want to be the DBA from SPACE. If I won, or should I say...

I like the question but the answer says:

Since 200,474 pages equates to about 1.53 GB, you will not get error 1105.

I ran this code and I got error 1105...

The actual truncate statements were:

USE ReportServerTempDB

truncate table SessionData

truncate table PersistedStream

truncate table Segment

truncate table SnapshotData

truncate table SegmentedChunk

truncate table SessionLock

truncate table ChunkData

truncate table ChunkSegmentMapping

fyi. The segment table started growing again...

Well we did it. We spoke to Microsoft and they okayed this. We stopped reporting services, and truncated all the large tables in ReportServicesTempDb and then shrunk the...

I am assuming this post implies that you can stop reporting services - truncate the segment table (TRUNCATE TABLE dbo.segment) then restart report services with no problems. Has anyone...

I am also having the same issue. My ReportServerTempDb is now 82G with the Segment table being 78G. Just 2 weeks ago the Segment table was 74G. ...

see http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx for downloads of all service packs and CUs

Revenant (7/5/2011)

---

Let me point out another wrinkle: big international companies have international shareholders, and their opinion what is ethical and what is not, with whom to do business and with...

There is nothing wrong with discrimination if it is legitimate. The movie example is perfect. If there is a part for a woman then men will be discriminated...

I don't see how simply having stockholders obligates you to maximize the money you earn without restrictions. I believe we are all still bound to act responsibly and morally....

There may be some warning that can be ignored. It depends. For example it may warn you DTS is not installed. If you aren't intending to install...

A couple of issues. One I assume you are using CHECKSUM when doing the backups. If not you should consider this.

Also consider test restores periodically (not...

I just did several Windows Cluster installs and I would say you should run the Windows Cluster Administration validation tool before continuing. If you find any errors get those...