Forum Replies Created

Viewing 15 posts - 46 through 60 (of 215 total)

  • RE: Can Reporting Services do this?

    Thanks.  We downloaded yesterday and one of my programmers was looking at it, we'll get together today to see if she got it installed (I had the pleasure of being...

  • RE: Forcing order of evaluation

    That's an interesting construct, and it worked.

    I thought for some reason you couldn't nest case statements, but apparently you can.

    Rather ugly in a syntax sense, but perhaps you've got it! ...

  • RE: Forcing order of evaluation

    The query plan is below.  It obviously combines the two queries into one.

    as to the question about invalid data -- well, that's kind of the point, ISNUMERIC ought to catch...

  • RE: Question of the Day for 11 Feb 2004

    I agree, having just gone through this I also chose "none of the above" because it is "not required".

    Bad wording.

  • RE: SQL 2K on win 2003

    We migrated from a 2G 4x700Mhz server on W2K to a 32G 4x2.8G server on W2003.

    We went to W2003 primarily so we could make use of 32G instead of 8G...

  • RE: Good Argument for IT Director - Your thoughts...

    You really want to help or do you want access?

    If you really want to help, build a case of what is wrong -- what needs doing, the kind of problems...

  • RE: Choice: to /3GB @ 16G or /2GB @ 32G

    Be nice if I could, but these are all users of a couple of databases, so the workload is not easily partitioned among instances.

    I can say that so far it's...

  • RE: Choice: to /3GB @ 16G or /2GB @ 32G

    On SQL 2000 EE SP3 I can confirm that it does understand 20000 as 20G.  I moved it up and down and could see the memory usage changing on task...

  • RE: Screwed up links and pagination and logins

    Sorry, I guess I kind of lost track of where to post problem reports, and was thinking this was it (since I saw others here).

    I now see there is a...

  • RE: Which administration tool should I use?

    Many SQL developers are MS developers and have MSDN Universal or similar which gives them Visio.

    For design (not, IMO, administration and maintenance) I think Visio is a great tool, the...

  • RE: How can I see progress within a transaction?

    Here's a rearranged version of the popular SP_WHO2 which, when run with a specific PID, will show the sql statement being executed.  At least mostly -- some things like UDF's,...

  • RE: Best way to license SQL server for web apps

    Do you have a microsoft reference for that?

    I'm not disputing it, but it addresses a discussion I have had internally and I have not seen that written down from Microsoft.

     

  • RE: Do you enable parallel execution?

    I've often wondered the same.  We have 4 CPU's and I am convinced that at times we get basically hung up because some query creates a huge number of parallel...

  • RE: How to detect changes in the data using T-SQL

    We did something once that might satisfy you, though honestly I'm not sure that your approach isn't better served with triggers, at least setting an update date/time in the sale...

  • RE: SQL/RAID

    For such a huge amount of write activity I would expect switching to Raid-5 would be a bad idea.  For write activity while each logical block write might require two...

Viewing 15 posts - 46 through 60 (of 215 total)