Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 5,685 total)

  • RE: Is my DBA being a Control Freak? Wont' give me access to Report Server.

    RaviInBaltimore (1/25/2012)

    When I arrived here, my DBA took away all the access to report server. I don't even have publishing rights to the report server, let alone manage it....

    January 25, 2012 at 1:50 pm

    #1438434

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/25/2012)

    Steve Jones - SSC Editor (1/25/2012)

    SQL Kiwi (1/25/2012)

    Steve Jones - SSC Editor (1/25/2012)

    Maybe you can do this?

    If we had ever met in person, you would not need...

    January 25, 2012 at 1:45 pm

    #1438431

  • RE: Weird AND Problem

    fahey.jonathan (1/25/2012)

    SQLKnowItAll (1/25/2012)

    Where is this query being executed from; i.e. a text file, SSMS, 3rd party query editor?

    As far as I recall, the code was copied from a hosted SVN...

    January 25, 2012 at 1:43 pm

    #1438430

  • RE: How to use what I created?

    barry.pettis (1/25/2012)

    Ok... I'll go the table route... I'm seeing more information that I could add.

    So from the existing result of this "PROC" it always returns a single record......

    January 25, 2012 at 11:37 am

    #1438344

  • RE: Table Partitioning Issue

    Bhuvnesh (1/25/2012)

    Paul/Dev i am waiting here for your responses

    I can't answer the question but a simple comment. They responded about 2 days ago, and it's after midnight on the...

    January 25, 2012 at 1:30 am

    #1438125

  • RE: Transaction replication doubts..?

    karthikaug18 (1/25/2012)

    My table has 175203942 rows and the size is 361 GB used for datawarehousing, I am going configure transactional replication on this table. how much time it...

    January 25, 2012 at 1:29 am

    #1438124

  • RE: interactive package in SSIS?

    public2 61705 (1/24/2012)

    I still have a question, though. I don't want to start a holy war, but almost everybody seems to discourage having an interactive package. Is there a deep...

    January 24, 2012 at 8:58 pm

    #1438073

  • RE: Full Text Search on a Varbinary Column Not Returning Rows

    mymail.default (1/24/2012)

    Thanks for your input.

    But, I am able to search fine on my local machine (with SQL 2008 32bit), not so on the server (64bit).

    I did install the filters too!

    Hm,...

    January 24, 2012 at 5:50 pm

    #1438044

  • RE: Are the posted questions getting worse?

    GilaMonster (1/24/2012)

    http://en.wikipedia.org/wiki/Fine_structure_constant

    As for Flash Forward, the blackout and flash forward that the series is named for was 2 minutes, 17 seconds long.

    Ah, thank you. I now understand 137 and...

    January 24, 2012 at 5:23 pm

    #1438035

  • RE: How to use what I created?

    GilaMonster (1/24/2012)

    Evil Kraig F (1/24/2012)

    DATENAME is apparently non-deterministic, I'll have to see what's going on there

    Because it might return different results from the same input depending on the SET options...

    January 24, 2012 at 5:19 pm

    #1438031

  • RE: Full Text Search on a Varbinary Column Not Returning Rows

    mymail.default (1/24/2012)

    Note:

    I added another document with a .doc extension, and I was able to see the search results.

    So, the problem is when I add the document as .docx, the search...

    January 24, 2012 at 5:17 pm

    #1438029

  • RE: Are the posted questions getting worse?

    GilaMonster (1/24/2012)

    SQL Kiwi (1/24/2012)

    GilaMonster (1/24/2012)

    Oooh, a palindrome! Nice.

    It's also the first five binary digits of 10001001 - a number I seem to recall has special significance to you 🙂

    Yes, I...

    January 24, 2012 at 5:13 pm

    #1438027

  • RE: How to use what I created?

    An example of a persisted table:

    CREATE TABLE BarrysCalendar

    (ReferenceDate DATETIME NOT NULL,

    IsNightShiftBIT NOT NULL,

    ShiftStartAS CASE IsNightShift

    WHEN 0 /*Day*/ THEN DATEADD( hh, 6, ReferenceDate)

    ELSE DATEADD( hh, -5, ReferenceDate) -- Start at...

    January 24, 2012 at 5:11 pm

    #1438026

  • RE: Are the posted questions getting worse?

    Anyone else losing CR/LFs when they copy paste code off the site recently? I've had the problem in anything in a code="", plain or SQL.

    EDIT: I can quote and...

    January 24, 2012 at 4:46 pm

    #1438019

  • RE: How to use what I created?

    barry.pettis (1/24/2012)

    Evil Kraig F (1/24/2012)

    Yes, it's a function. You want a UDF, or user defined function. However, you need to be aware that inline functions like this are...

    January 24, 2012 at 4:43 pm

    #1438017

Viewing 15 posts - 1,876 through 1,890 (of 5,685 total)