Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 2,010 total)

  • RE: "Calling" an HTTPS site from T-SQL?

    This sounds very much like the situation RBarryYoung discussed in his talk. In that case he was just packaging up an XML doc and sending across the wire, but...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: "Calling" an HTTPS site from T-SQL?

    So I guess there are a couple of basic questions here...

    1, is this some sort of API or whatever that you are being forced to interact with and this is...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Dec 12 - SQL Security Issue

    So I've been looking into this a bit and the one piece of info I can't seem to find is, what the heck does sp_replwritetovarbin do? I've disabled it...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: How do I use the GETUSERID() function?

    I believe you can do what you want with the User!UserID global variable...

    Create a Hidden Parameter of type string, call it LoginName for instance.

    for the default value select the radial...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: How do I use the GETUSERID() function?

    Are you attempting to use this in a piece of TSQL because I don't believe it's a built in function.

    there is a function for that in SSRS. If...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Dec 12 - SQL Security Issue

    Actually I've been seeing reports of a new SQL Server vulnerability, this is a different one from the IE exploit.

    Here's the post from secunia...

    http://www.sec-consult.com/files/20081209_mssql-2000-sp_replwritetovarbin_memwrite.txt

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Selecting any 3 Characters

    Go to Book Online and look up the LEN() command.

    I think you will find that helpful.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Certain Number of rows before SQL will use an index ?

    Just to add to what Jerry already said...

    If you are using columns in your Select statement that are not part of your index in one way or another and the...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Header Table Record containing Line Table Records as Columns

    Sure, it makes it clearer what you are trying to do. In my above post, I posted a few links to articles by Jeff Moden who recently covered how...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Header Table Record containing Line Table Records as Columns

    It sounds liek perhaps you are looking for a pivot or cross table...

    Here are some more articles by Jeff on doing just that. Have a read and see if...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Header Table Record containing Line Table Records as Columns

    Martin, unfortunately it will be very difficult to guess exactly what you are asking about.

    Could you please post a bit more detail? Some Table DDL and test data would...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Strange error on SQL agent job

    Do you have disk quotas turned on? You say the disk space is fine, have you checked while the job is executing or only before and after it's completion?

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Select top 1 from subquery

    GilaMonster (12/5/2008)


    Does this work?

    select top 1 id

    from tblname

    where tblname.person = 'xxx-xxx...'

    group by id order by max(dttm) desc

    Just outta curiosity, doesn't the above make the TOP unnecessary, or is there...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    Another Great article Jeff. Very informative and useful.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Remove AdventureWorks from SQL Server 2005 Developer

    If this is on a Dev workstation Win XP or Vista, you could use System restore to restore back to before you attempted to install adventureworks.msi. windows should have...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 15 posts - 1,276 through 1,290 (of 2,010 total)