Forum Replies Created

Viewing 15 posts - 46 through 60 (of 207 total)

  • RE: SQL Server 2008 Launch Date

    Probably late Q2 but that is just my guess.

  • RE: I got burned today at a SQL Server Interview!

    I wasn't going to post but decided after reading the "everyone wants mid level" note to share a story.

    I was laid off of a job and had minimal TSQL expereience....

  • RE: Import Multiple txt files and append to 1 table

    When you get the pop up are you getting the expected file name? (The one before the move?)

    In your "shouldloop" function, is it getting called properly?

    Rather than this:

    for each fil...

  • RE: Import Multiple txt files and append to 1 table

    Can you post some code samples for us?

  • RE: Connect to a Remote SSAS 2005 Database

    There is. Look up HTTP Endpoints in Books Online. I beleive that will give you what you need.

  • RE: Runs in Production but not QA

    I agree with Tommy. Run an Update Statistics. I had a similar problem (granted it was SQL 2000) some time back and it boiled down to updating statistics and everything...

  • RE: Workplace Sabatoge or Incompetance. . .

    If you are working with recruiters, also let them know the exepericne you have had there and let this companies management know you are telling others of the situation there....

  • RE: selecting new records

    Still another way to do this if you are using SQL 2005 is to utilize the EXCEPT operator.

    DECLARE @TblNew TABLE(Column1 CHAR(1),Column2 TINYINT, Column3 VARCHAR(20))

    DECLARE @TblOld TABLE(Column1 CHAR(1),Column2 TINYINT, Column3 VARCHAR(20))

    INSERT...

  • RE: SQL Server 2008 Launch Date

    I'll beleive the release date when I actually see it come to pass. I don't think I've seen MSFT hit an initial release date yet =) I could be wrong.

  • RE: Connect to a Remote SSAS 2005 Database

    I'd like to see a follow-up article on this regarding security and when one would use HTTP to connect vs TCP/IP over port x. I am also curious as to...

  • RE: Using ODS As A Middle Layer

    Vincent,

    With regards to the 3 types of SCD, I don't see another alternative to handling updates in a table. Either you 1) Replace the data, 2) Version the data in...

  • RE: Row number

    Here you are setting the value of @RowID to the value of the RowID column. The Value of the RowID column is being set to @RowID + 1

    SET @RowID=0 --...

  • RE: The Best Thing?

    RSS is a great implementation of data exchange utilizing an XML Schema. That said, I think that external data exchange is the best use of XML with Configuration a close...

  • RE: xp_ExecResultSet

    After examining the procedure sp_execresultset, I decided to write a cleaner port.

    USE master

    GO

    CREATE PROCEDURE sp_execresultset

          @SQLToGetRecordSet nvarchar(max)

          ,@DatabaseToExecuteCodeIn sysname

          ,@debug bit = 0

    AS

  • RE: Import Multiple txt files and append to 1 table

    You should run the activex tasks first, then the executesql tasks. Generally, what I like to do to keep things organized, is to have an activex task for setting the...

Viewing 15 posts - 46 through 60 (of 207 total)