Forum Replies Created

Viewing 15 posts - 4,891 through 4,905 (of 8,416 total)

March 24, 2010 at 10:42 pm

#1139396

  • RE: Maximum Date that exists for two or three parties and also another table

    Nugby (3/24/2010)

    Hi Paul. I don't think that solution works if Table 2 doesn't contain the Max Date from Table 1.

    Did you try it? I think it meet the criteria...

    March 24, 2010 at 10:22 pm

    #1139391

  • RE: FullText Question

    Mauve (3/24/2010)

    "no" is a Stop (noise) word and will not be indexed. Which means that it cannot be searched. My strong opinion: Eliminate the Stop (noise) words. ...

    March 24, 2010 at 10:18 pm

    #1139389

  • RE: Must declare the scalar variable when assigning SELECT statement to nvarchar variable

    DECLARE @SageDataBase NVARCHAR(60);

    SET @SageDataBase =

    (

    SELECT ACSODBC...

    March 24, 2010 at 1:04 pm

    #1139189

  • RE: Assign value to another fieldname using CASE statement

    The Dixie Flatline (3/24/2010)

    Did you not even look at my example casting an integer as SQL_VARIANT datatype?

    I did, and I liked it.

    March 24, 2010 at 12:49 pm

    #1139181

  • RE: T-SQL: Why “It Depends”

    Jack Corbett (3/24/2010)

    Paul Randal has an older blog post about autoshrink on the Storage Engine Blog. It says:

    The algorithms that shrink use are basically brute force. It starts at...

    March 24, 2010 at 12:45 pm

    #1139175

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/24/2010)

    I prefer chrome - though not compatible with all sites yet.

    Chrome here too - version 5.0.356.2 today.

    I find it very stable, fast, and compatible with all the sites I...

    March 24, 2010 at 12:30 pm

    #1139162

  • RE: Are the posted questions getting worse?

    Tom Brown (3/24/2010)

    Finally put IE out of its misery after it had swallowed 1.5Gb and showed no sign of return after 5 mins.

    Is that not normal for IE? :-P...

    March 24, 2010 at 9:57 am

    #1139026

  • RE: Bit Param Evaluation alters Execution Plan

    nwoolls (3/24/2010)

    I do agree that it seems like, under 2000, the optimizer assumes a value of 1 for the param, which results in a more optimal join whether the param...

    March 24, 2010 at 9:27 am

    #1139001

  • RE: STATEMENT LEVEL RECOMPILATION

    Anu-923127 (3/24/2010)

    Still I could n't the thread of Statement Level Recompilation in the specified link

    The link takes you straight to it...? :unsure:

    March 24, 2010 at 7:30 am

    #1138911

  • RE: Table level backup

    Carl Federl (3/24/2010)

    The "Backup" command works at the database or database file level and there is no support for table level backups.

    My table resides on its own file group. 😛

    @Ratheesh:

    If...

    March 24, 2010 at 7:26 am

    #1138908

  • RE: T-SQL Oddities

    The Dixie Flatline (3/24/2010)

    Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".

    Awesome! Cannot wait to try...

    March 24, 2010 at 7:24 am

    #1138906

  • RE: Loading Web pages directly from SQL Server

    Nawar.Tabaa (3/24/2010)

    Thanks Paul, apart from the storage is there any way to load HTML documents from the web like those exists for documents on local file system / network share?

    SELECT...

    March 24, 2010 at 7:23 am

    #1138904

  • RE: T-SQL: Why “It Depends”

    TheSQLGuru (3/23/2010)

    Tom, why do you think that autoshrink will make the database more likely to fit into RAM?

    Possibly because auto-shrink may compact data onto fewer pages?

    edit: Jack said it better

    March 24, 2010 at 7:21 am

    #1138901

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/24/2010)

    ...as far as I know, beards are not contagious

    Not so sure...Gus caught it from somewhere...;-)

    March 24, 2010 at 7:17 am

    #1138896

    • Viewing 15 posts - 4,891 through 4,905 (of 8,416 total)