Forum Replies Created

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

  • RE: SQL Server Alias not updating

    arnipetursson, great find. I confirmed sp_setnetname worked and I consider it much cleaner as behind the scene this line does the magic:

    EXEC %%LinkedServer ( Name = @server ) . SetDatasource...

  • RE: SQL Server Alias not updating

    Interesting, thanks for the lead, I appreciate it!

    Yesterday I found I could "trigger" a refresh of the linked server by running sp_serveroption, setting an existing option to itself for the...

  • RE: Memory Issue with Named Instance

    Ah, awesome, thanks for sharing this!

  • RE: Memory Issue with Named Instance

    Using the link Lynn mentioned you'll likely need to start SQL Server in single user mode (-m). If you find that you can't connect to the instance after doing this...

  • RE: Blocked Continuously by Different SPIDs

    @Deadlock priority, I don't think this is a factor here... deadlocks aren't occurring at all but thank you for a response!

    @Blocking, I should've been more specific. The blocking does not...

  • RE: Listing Years based on range

    Jeff Moden (10/19/2013)


    AmarettoSlim (10/19/2013)


    Can I ask why you don't want a loop? Recursion via a common table expression (CTE) can be your friend in this case.

    DECLARE @fromYear DATETIME, @toYear DATETIME

    SELECT...

  • RE: Storage arrays/RAID configurations

    You mentioned this is primarily a read heavy box, correct? If that's the case then going to RAID 5 might be the move to make if cost is a concern...

  • RE: Listing Years based on range

    Can I ask why you don't want a loop? Recursion via a common table expression (CTE) can be your friend in this case.

    DECLARE @fromYear DATETIME, @toYear DATETIME

    SELECT @fromYear='1913-01-01', @toYear='1998-01-01'

    WITH...

  • RE: Licensing with respect to SSRS and Clustered DB engine

    Per the 2008 SQL Licensing Overview:

    The Business Intelligence components for SQL Server 2008 include Analysis Services, Reporting Services, and Integration Services. To use any of these components, the server on...

  • RE: Optimizing loads from linked server

    I'd recommend using SSIS as its purpose is for developing ETL processes. If you want to stay within I would use a pass through approach via open query vs a...

  • RE: Connection to SQL Server > 5 sec after packet arrives at NIC

    To loop back for those who might stumble on this. We found a decent accumulation of the THREADPOOL wait and ended up resolving the connection timeouts by tweaking the MAXDOP...

  • RE: Replication - How to tell if transaction has been applied to a subscriber

    I found the answer to my own question. For others wondering, connect to the subscriber and run the following:

    USE <subscriber_db>

    GO

    SELECT publisher,publication, distribution_agent,transaction_timestamp

    FROM dbo.MSreplication_subscriptions

    The transaction_timestamp value contains the Log Sequence Number...

  • RE: Large INSERT INTO SELECT ....

    I just dug up the plan and sure enough you're correct HowardW!

    This is the plan:

    INSERT <---Clustered Index Insert <--- Sort <--- Compute Scalar <--- Compute Scalar <--- TOP <--- Clustered...

  • RE: Large INSERT INTO SELECT ....

    Ah cool, thanks for the explanation, I appreciate the response!

    There is a clustered index on a single field for the destination table (and it's different than the clustered index of...

  • RE: Does SQLSERVER2008 offer Object level recovery

    Resurrecting this thread with a question I have...

    Can someone explain why SQL Server doesn't support object level recovery in a native manner?

    How do 3rd party vendors make this possible?

    I'm just...

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