Forum Replies Created

Viewing 15 posts - 1 through 15 (of 27 total)

  • RE: Five Free Hours of Training

    Please let us know where the recorded versions will be available - Just returned off from vacation and saw I missed these classes 🙁 -

    Thanks for offering them ,...

    ** What you see, Depends on what you Thought, Before, You looked! **

    July 23, 2008 at 8:35 am

    #847089

  • RE: Are Views - good or bad!

    sp_refreshview - Thanks for that noeld, - I forgot about it - I know it would have come back to get me later on

    ** What you see, Depends on what you Thought, Before, You looked! **

    June 15, 2007 at 2:17 pm

    #713396

  • RE: Are Views - good or bad!

    I thought the check constraint was to ensure data integrity by ensuring modifications made through an updateable view would satisfy all conditions of the view definition. I need to get...

    ** What you see, Depends on what you Thought, Before, You looked! **

    June 15, 2007 at 6:20 am

    #713225

  • RE: What do I monitor to prove the server needs more memory

    Just remember if you add more than 4 GB memory you need to get the patch as there is a bug in the SP4 which halves the available memory. -...

    ** What you see, Depends on what you Thought, Before, You looked! **

    February 13, 2007 at 8:15 am

    #689473

  • RE: Centralizing Resources and using reporting services for reports - How

    Thanks for that reply, I feel happier I am persuing the correct direction to attaining my goals with this project. I totally forgot about creating a view that can span...

    ** What you see, Depends on what you Thought, Before, You looked! **

    February 5, 2007 at 1:27 pm

    #687874

  • RE: Home Sweet Home

    Originally born in Zimbabwe - nearest city that I can find reference for distance was Harare - now work between North Carolina, California and New York - so the greatest...

    ** What you see, Depends on what you Thought, Before, You looked! **

    January 19, 2007 at 12:13 pm

    #684413

  • RE: Snack Attack

    Ginger nuts (cookies/ biscuites) dunked in a hot cup of tea - problem is that they never end at the same time.

    An old favorite - Toast and marmalade with bacon...

    ** What you see, Depends on what you Thought, Before, You looked! **

    January 12, 2007 at 6:56 am

    #682892

  • RE: Performance Considerations - which host

    Absolutely any information of links that may help me determine a good configuration will be of help - I just dont want to go down the path and then find...

    ** What you see, Depends on what you Thought, Before, You looked! **

    January 3, 2007 at 11:18 am

    #681001

  • RE: large table queries - using views - how do I get better performance?

    Thanks for all the positive feedback and reference links - They are all helping. From many of the comments above it looks like adding hardware is going to get the...

    ** What you see, Depends on what you Thought, Before, You looked! **

    January 2, 2007 at 7:13 am

    #680739

  • RE: large table queries - using views - how do I get better performance?

    AH!!!!! that was a killer - just typed a large response and hit the reply button - It all disappeared and now I must do again

    ** What you see, Depends on what you Thought, Before, You looked! **

    December 29, 2006 at 11:17 am

    #680558

  • RE: large table queries - using views - how do I get better performance?

    Thanks for the /3gb heads up - I was unaware of that.

    I am assuming to just perform the select statement to the temp table to pull all the necessary rows...

    ** What you see, Depends on what you Thought, Before, You looked! **

    December 29, 2006 at 8:52 am

    #680521

  • RE: Compression tool???

    I have to ask - what size are the uncompressed forms of the files you are planning on storing within the database - and what size are you expecting them...

    ** What you see, Depends on what you Thought, Before, You looked! **

    December 29, 2006 at 8:41 am

    #680516

  • RE: Memory Usage by SQL Server

    if you are using SP4 then there is a bug and you need to apply a patch - " If Address Windowing Extentions (AWE) support is enabled, a single instance...

    ** What you see, Depends on what you Thought, Before, You looked! **

    December 29, 2006 at 8:30 am

    #680513

  • RE: Query: SLOW then FAST then SLOW (SQL 2000 SP3, Large Tables)

    Initial thoughts are that the first call you are making it is pumping all the data into the cache - once cached subsequent reads are fast. after your 30 minute...

    ** What you see, Depends on what you Thought, Before, You looked! **

    December 29, 2006 at 7:55 am

    #680499

  • RE: Using WHERE IN(...)

    works for me - just dont put in the ' ' when capturing the variables in your string list - just tested it and it went through like a...

    ** What you see, Depends on what you Thought, Before, You looked! **

    December 29, 2006 at 7:35 am

    #680488

Viewing 15 posts - 1 through 15 (of 27 total)