Forum Replies Created

Viewing 15 posts - 31,651 through 31,665 (of 39,819 total)

  • RE: RAID-5 Disk Crash

    Do you mean a single disk of a R-5 array?

    We've had notifications set up before in software to notify administrators. At the least this should be written to the Windows...

  • RE: SHRINK DB

    I don't think that's an accurate count. If you check the properties of each database, you will see the size and space available. The difference is your data, index, and...

  • RE: Rolling up values

    You can do things like

    select venue, date, avg(los)

    from table

    group by venue, date

    Are the dates really dates only or are times in there. You might be able to clean...

  • RE: Tuning Time

    I guess I wasn't thinking of just bad code, but decent code you write to get a job done. We all could stand our code to be tuned to some...

  • RE: Recomendations and opinions please

    Sorry to hear that David and good luck taking it again. Definitely spend some time just doing stuff in SSMS, add users, permissions, etc. Just talk through exercises and get...

  • RE: 13 Disasters

    Ah, I've met David. "Fine" might not be the right word

  • RE: The 18 Month Debate

    Didn't know the plates stayed with the car. That's interesting.

    In VA and CO, when you sell the car, you remove the plates immediately. They are yours. The new owner must...

  • RE: 13 Disasters

    Anders brings up a good point, and one I'm addressing now. What happens if Steve leaves (I'm not planning on it).

    Everyone should have...

  • RE: The 18 Month Debate

    Anders,

    I guess I'd disagree on this. You should be allowed to go to court, but the film and record of the camera is evidence. I think you're responsible for your...

  • RE: SQL Server Licensing for Internet

    The summary is that if you have un-authenticated users, meaning not in your AD forest, you need a processor license. If you have employees or partners, with AD accounts, you...

  • RE: One query is hogging my baby!!!

    Yep, steve_smith, of (steve) Smith and Jones fame, hit it. It should run a little faster if that field is indexed and it's used.

  • RE: Where statement Joins vs join statement joins

    TheSQLGuru has the best reason. The old syntax will get dropped.

    I think the inner join syntax reduces mistakes and it's easier to read, but that's personal preference. I never had...

  • RE: SQL SERVER RECOVERY TOOLS

    Actually in SQL Server, a system backup of the host Windows system wouldn't get the databases. The files would be locked, so without a database backup plan by the DBA,...

  • RE: Working with dates

    Are you looking at the right dates? Meaning are there multiple dates in the table and the one in the WHERE clause is the right one?

    It worked for me as...

  • RE: Book Recommendations...

    Sounds more like you want some sort of SSIS package. The header row with rowcount will be slightly tricky. You need this info first, so it's probably two queries you're...

Viewing 15 posts - 31,651 through 31,665 (of 39,819 total)