Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 3,656 total)

  • RE: sql script for table rowcounts

    How do they name hurricanes anyway?

    What they don't tell blokes about marriage is that you evolve a new sense organ called the marital radar. It pings like crazy when...

  • RE: Initial size of TEMPDB in a large environment?

    Thanks Rudy,

    We are currently experiencing the old TempDB contention issue that was partially fixed by Hotfix 818. We are running back at SP3a on build 760.

    I am going to...

  • RE: Initial size of TEMPDB in a large environment?

    I had more or less decided to set the initial size to 4GB as creating such a file on the SAN is a surprisingly quick operation.

    I was thinking of fixed...

  • RE: Performance enhancement achieves the precise opposite

    Correct!

    The performance of the stored procedure using the new table instead of the view is lower than when using the view alone.

    It is an absolutely crazy result, especially as the...

  • RE: Performance enhancement achieves the precise opposite

    For confidentiallity reasons I cannot post the actual view or the stored procedure but if you imagine the table is something similar to the following

    AccountID INT

    LineNo INT

    SalesValue MONEY ,

    CostValue MONEY...

  • RE: Employee Retention From the Managers Perspective

    Little fleas have bigger fleas upon their backs to bite them.

    Bigger Fleas have greater fleas and so on ad infinitum.

    That's my view of management.

    As an employee I may get frustrated...

  • RE: "Edited" Reviews?

    If I see a review that is all roses I look for the fertilizer. If it sounds too good to be true then it probably is.

    If a review is...

  • RE: Ever Buy From These Guys?

    The thing is it wasn't just the .com startups that got into difficulty, it was the infrastructure guys as well.

    British Telecom decided that what Britain needed was a high speed...

  • RE: Being Retained

    You have said something that is blindingly obvious but only after you have said it.

    A subtle change in management style can have a big influence on morale.

    I was asked to...

  • RE: Do You Talk Salary in the Interview?

    The general rule used to be salaries/pensions etc could be discussed at 2nd interviews.

    If you go through a recruitment consultant then , once the offer is made you can let...

  • RE: Stop Reading

    I take the view that if I get something out of SSC then I should put something back in.

    I don't use SQL Server outside of my work therefore my use...

  • RE: Scheduled DTS Package

    Yes, If you use the DTSRUNUI.EXE then it will produce an encrypted string that says what the package is, who the running user is, their password and various other...

  • RE: Updating a frequently used table

    Do you mind dirty reads?

    If you don't mind use the WITH NOLOCK query hint on the SELECT statement.

    It means that the readers might see obsolete values while the update is...

  • RE: Huge Number of Records - Failed to Be Loaded

    If your data for past years is static then I would look at having a specific table into which your write your summary information. That way the only time...

  • RE: Honouring the dead in London (Terror attack)

    A sort of satanic public transport?

Viewing 15 posts - 2,656 through 2,670 (of 3,656 total)