Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: SQL Server Trace Flags

    Nicely done!

    July 5, 2013 at 1:00 pm

    #1630167

  • RE: Cannot drop temp table

    Shane Martin (12/3/2007)

    thanks, I'll use your if exists statement in my stored procedure.

    I'm still a little confused about how the temp table stuck around, there shouldn't be any open connections...

    December 3, 2007 at 12:37 pm

    #756624

  • RE: VARCHAR(1000) vs. VARCHAR(MAX)

    colin Leversuch-Roberts (7/27/2006)

    I'm quite happy for the use of varchar(max) and including them within index defs - these features will help keep me in employment < grin >

    Colin, count me...

    November 28, 2007 at 12:25 pm

    #755091

  • RE: Migrating SQL 2000 DB to 2005

    For DTS packages, you can also use BIDS and place the files any folder you like to move. It would be good idea to rewrite some of those packages...

    November 28, 2007 at 9:34 am

    #755023

  • RE: Migrating from 2000 to 2005

    Nita Reddy (11/27/2007)

    We are migrating SQL from 2000 to 2005 before I migrate I want to know all the configuration setting and database size and there physical location.

    Can anyone please...

    November 27, 2007 at 3:09 pm

    #754746

  • RE: scheduling a job in sql

    Hi JP,

    Service Broker and Notification Services are also other alternatives that can be explored.

    -Najm

    November 26, 2007 at 12:09 pm

    #754200

  • RE: Writeback OLAP Data

    Hi Carlos,

    Thank you for your reply. When we speak of OLAP data, it also includes dimensions so becareful ..;)

    It is all fun and good. We reason and learn and explore...

    November 21, 2007 at 8:09 am

    #753121

  • RE: Writeback OLAP Data

    It has nothing to do with the logic. QOD should conform to correct structures. The question should have been about write-enabled partitions rather than cubes. 😀

    November 21, 2007 at 7:23 am

    #753098

  • RE: Finding Objects Owned by non-DBO Users

    It is a usefull Script; however, I will avoid the cursor.

    December 15, 2005 at 7:08 am

    #609711

Viewing 9 posts - 1 through 9 (of 9 total)