Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 1,838 total)

  • RE: Advantages and Disadvantages of SQL EXPRESS

    nairsanthu1977 (12/21/2008)

    ...client is planning to use SQLSERVER express as they dont want to pay for database.

    Can anyone tell me what are the advantages and disadvantages of SQL EXPRESS...

    December 29, 2008 at 9:21 am

    #918429

  • RE: Return all Master and any child records

    interfac (12/27/2008)

    ...but I need the WHERE

    If you need that WHERE clause condition, you'll have to do it like Grant says to handle the case where there is no matching child...

    December 29, 2008 at 8:54 am

    #918411

  • RE: How to calculate the Bi-weekly in SQL

    Christian Buettner (12/28/2008)

    Jeff Moden (12/28/2008)

    ...Lordy, I hope they never make SQL Server require semi-colons for everything like {gasp} Oracle...

    Hm I kind of like that approach with semicolon after each statement,...

    December 29, 2008 at 8:34 am

    #918401

  • RE: Enterprise Grade Stored Procedures with One to Many relations

    Personally, I'd say it depends on how your application user interface is designed and how much logic you have in your business layers. If the user enters all of...

    December 23, 2008 at 8:17 am

    #916786

  • RE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED VS WITH(NOLOCK)

    GilaMonster (12/19/2008)[hr...Neither is desired for performance reasons. If there's blocking problems the best thing to do is fix the cause, not hide they symptoms.

    Actually, because of the architecture of SQL...

    December 19, 2008 at 8:54 am

    #915381

  • RE: Which .Net Language Should We Adopt

    MattieNH (12/17/2008)

    ...we thought we'd just move to VB.Net, to leverage what little we know in VB to the new environment...We know we can write in either, and end up (at...

    December 19, 2008 at 8:12 am

    #915325

  • RE: Enterprise evaluation to Developer edition

    Mani (12/17/2008)

    ...are there any issues and special considerations as we are moving databases from higher edition(Enterprise evaluation) to Developer edition?

    There shouldn't be, Developer Edition has the same featureset as Enterprise...

    December 17, 2008 at 3:17 pm

    #914201

  • RE: Opinions, performance implications of 1 bidge table vs 2 bridge tables

    ccakinberk (12/16/2008)

    ...I find myself joining to both tables often, this is how I have written all the stored procedures, speed is good...WOuld it be better to create one table that...

    December 16, 2008 at 4:11 pm

    #913500

  • RE: The best rapid application development tool for SQL server

    Could you clarify what you're looking to accomplish with the tool? I thought RAD was more a software design methodology than a set of tools. If you're looking...

    December 16, 2008 at 3:51 pm

    #913491

  • RE: Left outer join, error 4104

    bseeley (12/16/2008)

    Below is a simplified version of a select statement...

    SELECT

    RRSPRB1.REFERENCE,RRSINV20.PARTNUM,RRSINV2.ITEMCOST,

    RRSINV19.LOCATION,RRSINV1.INVCAT FROM

    RRSINV2,RRSINV1,RRSINV20,RRSINV19

    LEFT OUTER JOIN RRSPRB1 ON (RRSINV19.LOCATION=RRSPRB1.LOCATION)

    AND (RRSINV20.PARTNUM=RRSPRB1.REFERENCE)

    Would it be possible to see the whole SELECT statement? ...

    December 16, 2008 at 7:35 am

    #913135

  • RE: Interpreting dm_db_index_physical_stats ?

    Below is a query that can help you understand this table:

    SELECT s.name AS schema_name, o.name AS table_name, i.name AS index_name,

    ps.partition_number, ps.avg_fragmentation_in_percent, ps.avg_page_space_used_in_percent, ps.fragment_count, ps.page_count

    FROM...

    December 15, 2008 at 2:35 pm

    #912814

  • RE: problems with subquery counts

    AJ Mendo (12/15/2008)

    I am trying to get distinct counts on forms a certain user has filed for a certain day...

    ,(Select RecordCount from FunctionNumberofNODand9(@SelectedOffice,@SelectedDate,@Outreach)) as 'NoNOD'

    --Code 1

    ,(Select count (DISTINCT NatureId) from...

    December 15, 2008 at 12:59 pm

    #912734

  • RE: way to resolve virtual memory problem

    What I'm saying is that it could be a concern if there are a lot of virtual memory swaps occurring. Making a larger virtual memory swap file will not...

    December 15, 2008 at 12:44 pm

    #912721

  • RE: IDENTITY INSERT PROBLEM

    Something the VB routine is doing is causing the command SET IDENTITY_INSERT ... ON to happen for your data copy process. Have you tried to do a trace with...

    December 15, 2008 at 9:43 am

    #912586

  • RE: Identifying long running queries SQL server

    SQL Server 2005 keeps alot of good information in the dynamic management views about this kind of thing. Below are the 2 main queries I use to find slow...

    December 15, 2008 at 8:46 am

    #912506

Viewing 15 posts - 1,606 through 1,620 (of 1,838 total)