Forum Replies Created

Viewing 15 posts - 1 through 15 (of 116 total)

  • RE: Migrating an on premise SQL Server Database to Azure

    The word "premises" indicates a property (land/buildings).

    A "premise" is the basis of an argument or inference.

  • RE: Which web service?

    Can anybody out there share their experiences communicating with a web-app using SOAP or the SSIS Web Service Task? I'm trying to determine the best practice.

    I'm not as concerned with...

  • RE: SSIS package configuration organizer throwing errors

    I figured out that I had set the Provider incorrectly for my ADO connection. Starting over -- just opening the package with the one environmental variable configuration set throws a...

  • RE: description of view columns

    elham_azizi_62 (6/12/2011)


    hello all.

    I need to access to description of view columns.I know to access description of table columns.please give me one script that show description of columns of views.

    SELECT

    ...

  • RE: What Sarbanes-Oxley Won't Do

    "I'm just happy to say that SQLServerCentral.com is not complying and I, for one, am thrilled :)"

    But Steve, isn't it about time that SQLServerCentral goes public? 😉

  • RE: Find a string in database objects

    I think mine works better:

    http://www.sqlservercentral.com/scripts/Search/64839/

    It hits all databases and includes job steps.

  • RE: Slow data transfer

    ...You may need to look at the underlying disks from your Fibre Attached Storage (FAS) to see you they are laid out....

    There appear to be 5: C,D,F,G, & H. However,...

  • RE: Slow data transfer

    Elliott Whitlow (6/14/2010)


    32 or 64-bit?

    Local drives or SAN?

    RAID array? What raid level?

    Are the OS drives on seperate disks from the SQL data files?

    Are the database log files on seperate...

  • RE: Slow data transfer

    Elliott Whitlow (6/14/2010)


    Why don't you tell us about the destination server.

    It's a Windows 2003 box using 4 Xeon 3.2GHz chips and 3.75 GB of RAM.

    SQL Server 2005:

    ProductVersionProductLevel

    9.00.3282.00SP2

  • RE: Slow data transfer

    Elliott Whitlow (6/14/2010)


    What is the data source?

    Same server/different server?

    How complex is the query used to generate the data?

    One of the things I've seen is the source isn't returning rows fast...

  • RE: SSIS Package Execution in SSMS

    You should be able to execute your package with the dtexec utility. I usually save mine to SQL server and run the following from a sprock.

    EXEC xp_cmdshell 'dtexec /SQL \package_name'

  • RE: Speed Racer

    I've been a Teradata user over the past year and I've never seen a SQL Server run anywhere near as fast on large data sets. On the other hand, all...

  • RE: Expanding The Scope of Bridge Tables

    JJ B (3/23/2010)


    I want to weigh in on the jargon discussion.

    I don't think I've heard the term "bridge" table before, and yet without even reading the article, I knew instantly...

  • RE: Expanding The Scope of Bridge Tables

    Ed-997158 (3/23/2010)


    David Korb (3/23/2010)


    Tom Wilson (3/23/2010)


    The basic idea for this topic is useful to brand-new database designeres - build a new table when there is a many-to-many relationship between two...

  • RE: Expanding The Scope of Bridge Tables

    Tom Wilson (3/23/2010)


    The basic idea for this topic is useful to brand-new database designeres - build a new table when there is a many-to-many relationship between two other tables. ...

Viewing 15 posts - 1 through 15 (of 116 total)