Forum Replies Created

Viewing 15 posts - 5,521 through 5,535 (of 8,416 total)

  • RE: SSMS 2008

    stewartc-708166 (3/11/2010)

    Intellisense takes a while to synchronise added / changed / removed metadata.

    It only seems to refresh my cache if I disconnect and reconnect to the server. If it...

    March 11, 2010 at 5:43 am

    #1131953

  • RE: T-sql , permutation/Combination On columns

    No worries.

    You can help us to help you next time by including sample data in your question, just like I did in the answer.

    Paul

    March 11, 2010 at 5:28 am

    #1131947

  • RE: where clause need to pull datetime column for yesterday at 3:00 pm to current time

    The most compact way to find yesterday at 3pm is:

    SELECT DATEADD(HOUR, -9, {fn CURRENT_DATE()});

    Works on SQL Server 2005 and 2008.

    Paul

    March 11, 2010 at 5:20 am

    #1131942

  • RE: SSMS 2008

    Refresh the IntelliSense cache.

    You can do this by pressing Shift+Ctrl+R, or from the menu: Edit->IntelliSense->Refresh Local Cache.

    It may take a few seconds to rebuild.

    Paul

    March 11, 2010 at 5:16 am

    #1131939

  • RE: T-sql , permutation/Combination On columns

    One way to achieve it:

    DECLARE @SampleData

    TABLE (

    SSN BIGINT NOT NULL PRIMARY KEY,

    ...

    March 11, 2010 at 5:14 am

    #1131938

  • RE: Log Growing Pains

    You are welcome. 😎

    March 11, 2010 at 4:41 am

    #1131931

  • RE: Log Growing Pains

    arr.nagaraj (3/11/2010)

    One thing I fail to understand is your questions about my digression are ok. But my replies arent. 🙂 . No problem. I have met people like this, and...

    March 11, 2010 at 4:07 am

    #1131922

  • RE: Log Growing Pains

    arr.nagaraj (3/11/2010)

    Workarounds do work. But they are temporary and the issue can re occur on the same database and also on some other databases.

    Nonsense. The issue, workarounds, and permanent...

    March 11, 2010 at 4:01 am

    #1131920

  • RE: Log Growing Pains

    CirquedeSQLeil (3/11/2010)

    Let's keep in mind that the query I provide for recording the size is for SQL 2005 and 2008 (as stated in the article). To make this work...

    March 11, 2010 at 3:24 am

    #1131910

  • RE: SQL Random selection with NewID()

    Dave Ballantyne (3/11/2010)

    What !!!!

    use a udf ? , (select null) will perform better 😉 😀

    For the .NET-challenged, that was C# 😛

    Paul

    March 11, 2010 at 3:21 am

    #1131907

  • RE: Log Growing Pains

    arr.nagaraj (3/11/2010)

    The unfortunate thing is my apps are not well designed and I have very little control over it. And My idea is this. To play it safe and instead...

    March 11, 2010 at 3:16 am

    #1131904

  • RE: Log Growing Pains

    arr.nagaraj (3/11/2010)

    Well, I have systems running with SP2 + still facing the issue.

    And I know few people who have the same issue even after sp3.

    That really makes no...

    March 11, 2010 at 3:10 am

    #1131900

  • RE: Find all objects that use this view?

    Nigel,

    Good point and nice links, but they don't cover the new system views in 2008.

    See Understanding SQL Dependencies in Books Online.

    The new system views:

    sys.sql_expression_dependencies

    sys.dm_sql_referencing_entities

    sys.dm_sql_referenced_entities

    ...represent the best solution from Microsoft so...

    March 11, 2010 at 2:53 am

    #1131893

  • RE: Today's Random Word!

    Shagpile

    March 11, 2010 at 2:34 am

    #1131888

  • RE: SQL Random selection with NewID()

    Dave Ballantyne (3/11/2010)

    This will cause things to be LESS random.

    Checksum returns an int (32bits) , and UUID is 128 bits.

    Heh...less random, eh? 😉

    :laugh:

    March 11, 2010 at 2:33 am

    #1131887

Viewing 15 posts - 5,521 through 5,535 (of 8,416 total)