Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 6,486 total)

  • RE: with (nolock) replacement/substitute

    noeld (9/25/2008)

    You should know that with ( nolock) can read dirty values and even return duplicates if it hits a hot spot.

    If your queries are reading mostly historic data you...

    September 25, 2008 at 3:31 pm

    #877371

  • RE: generic stored proc/function to convert columns to concatenated rows

    Along with what Steve said - a function won't do this for you, so focus on using a stored proc. Functions can't use EXEC() and cannot make changes to...

    September 25, 2008 at 1:42 pm

    #877318

  • RE: Tables are big?

    Steve Jones - Editor (9/25/2008)

    I thought Gail was right here. Shouldn't use space for int/char if it's null, the null bitmap should carry that.

    Again - speaking form memory here, but...

    September 25, 2008 at 11:06 am

    #877208

  • RE: Tables are big?

    GilaMonster (9/25/2008)

    Matt Miller (9/25/2008)

    On other (non-variable length) columns, such as int, the space is still allocated even when the Bit map is set.

    I don't think they are. Will test.

    I should...

    September 25, 2008 at 10:55 am

    #877180

  • RE: Tables are big?

    GilaMonster (9/25/2008)

    But it's not going to be 42 GB for a million rows.

    True. that's more than the overhead observed. Besides - that space isn't free and wouldn't come up...

    September 25, 2008 at 10:50 am

    #877176

  • RE: Doevent functionality in SQL Server 2005

    giri_engg2001 (9/25/2008)

    Doevent functionality in SQL Server 2005 with example

    Under what circumstance would you ever need that? It would help to have an actual business example to understand why you'd...

    September 25, 2008 at 10:34 am

    #877160

  • RE: Tables are big?

    Unless the column is marked as sparse, there is a (small) cost to storing nulls. There's a flag that gets set per row that gets set denoting it as...

    September 25, 2008 at 10:26 am

    #877156

  • RE: 'CREATE TRIGGER' must be the first statement in a query batch.

    Why not use sp_msforeachdb?

    Would allow you to get that created....

    September 25, 2008 at 9:25 am

    #877098

  • RE: Can SQL 2005 be installed on a SQL 2000 Machine.

    Ellis RemoteDBA (9/25/2008)

    You can install SQL server 2005 on the same machine as a SQL server 2000 BUT i believe you may have to use a named instance... for...

    September 25, 2008 at 9:06 am

    #877083

  • RE: Copying views form database to database

    Also - if you want to do a bunch at a time...Right-click on the DB name, Tasks, Generate Scripts, pick the objects you want and voila. Play around a...

    September 24, 2008 at 8:26 pm

    #876760

  • RE: Breaking a SP into smaller modules

    Jeff Moden (9/24/2008)

    Hey MATT! Congrats on becoming a proud member of the over 5k crowd!

    Is it just me or is the air thinner up here????:D

    September 24, 2008 at 8:17 pm

    #876759

  • RE: Breaking a SP into smaller modules

    Jeff Moden (9/24/2008)

    Folks, please... go back and look at the original post... the queries are identical except for the IF and the WHERE... just move the IF to the WHERE...

    September 24, 2008 at 6:35 pm

    #876744

  • RE: FOR XML EXPLICT ORDER BY problem

    The FOR XML EXPLICIT needs to get the data "ordered" as it should be in the XML output. For better or worse, your ordering scheme is opening up a...

    September 24, 2008 at 11:06 am

    #876542

  • RE: INSTEAD OF INSERT trigger not firing

    Ian Massi (9/24/2008)

    I forgot to mention, if I run the stored procedure it returns a value. However, since the trigger isn't firing, the procedure doesn't run.

    Don't trust that the...

    September 24, 2008 at 8:24 am

    #876398

  • RE: Complex Case Conditions eating my query!

    Christopher Ford (9/23/2008)

    How do you SQL guru's handle rules in your queries?

    I have about 20 rules to apply to each column in a query to determine it's final value.

    How can...

    September 23, 2008 at 7:53 pm

    #876086

Viewing 15 posts - 2,536 through 2,550 (of 6,486 total)