Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 2,458 total)

  • RE: Options for storing .jpg files on SQL Server 2008 R2

    ELLEN-610393 (1/21/2014)

    Gentlemen, much thanks to all of you.

    I will read up on the FILESTREAM / and storing BLOBS outside of the database.

    Will also test using varbinary(max) .

    The images should not...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 22, 2014 at 3:06 pm

    #1682604

  • RE: passing a variable to CTE in a view

    Prassad Dabbada V R (1/21/2014)

    you cannot pass parameters to View

    For parameterized views please check below link

    http://msdn.microsoft.com/en-us/library/c11kd98s(v=vs.80).aspx

    You can also think of an inline Table Valued Function (iTVF) as a parameterized view....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 22, 2014 at 2:47 pm

    #1682589

  • RE: Need help to Add XML encode using T-SQL

    Hopefully you understand what Evil Craig was saying. To put it another way: you cannot click on the XML returned from a SQL query in SSMS and see a header...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 22, 2014 at 2:35 pm

    #1682585

  • RE: Mastering Dimensions of Time

    Nice work on the article.

    I was putting together a way to populate dimdate using a tally table but see that Louis beat me to it. Thought I would include...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 21, 2014 at 1:34 pm

    #1682150

  • RE: Parameter sniffing Troubles

    Grant Fritchey (1/13/2014)

    Alan.B (1/13/2014)

    I took a quick look at this and there does appear to be a lot parameter sniffing but there's a lot of other problems too.

    I'm confused....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 15, 2014 at 8:40 am

    #1680311

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    I will ignore your comment about suggesting that always using NOLOCK is a good idea when integrity of the results is not important.:w00t:

    To be clear (and to avoid being the...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 13, 2014 at 1:00 pm

    #1679691

  • RE: Parameter sniffing Troubles

    First is that the query plan from SSMS (the faster version)? Is it possible to provide both?

    I took a quick look at this and there does appear to be...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 13, 2014 at 11:09 am

    #1679663

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    kbhanu15 (1/9/2014)

    Hi All,

    can any one clarify the difference between NOLOCK and WITH(NOLOCK) in sql server 2008 ?

    which one is the best practice to use ?

    Thanks

    Bhanu

    I think everyone did a good...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 13, 2014 at 10:19 am

    #1679650

  • RE: xml to html

    I know this is a few days old but I thought it would be good to expand on this a little:

    The W3C defines two technologies for "Transforming XML": SQLXML/XQuery...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 8, 2014 at 1:41 pm

    #1678585

  • RE: insert (xml dml) error

    Unless I am mistaken it appears that you cannot add CDATA to the XML data type. This is a known Microsoft bug which they doesn't look like it's getting fixed....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 8, 2014 at 12:29 pm

    #1678546

  • RE: query giving unexpected results

    Do you have any DDL/Sample data for [alpsMaster].[dbo].[uExtractMonitor]? ... and some sample data for what will go into files? If you can provide that I am sure we can help...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 8, 2014 at 12:15 pm

    #1678543

  • RE: Stairway to SQLCLR Level 1: What is SQLCLR?

    Great Article Solomon. Very easy read and informative. I have been looking forward to a SSC Stairway on CLRs for a long time and look forward to the rest of...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 8, 2014 at 8:38 am

    #1678445

  • RE: The new Analytic functions in SQL Server 2012

    I just read this article. Great work Wayne.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 27, 2013 at 9:55 am

    #1676144

  • RE: Query -- Help

    Minnu (12/17/2013)

    Hi Team,

    Please help in below query, it should return TRUE.

    DECLARE @req_1 varchar(50)

    DECLARE @req_2 varchar(50)

    set @req_1='AAM'

    set @req_2='VVE'

    if (@req_1 !='AAM' OR @req_2 !='VVE')

    print 'TRUE'

    ELSE

    print 'FALSE'

    It's worth noting that you...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 18, 2013 at 2:56 pm

    #1674632

  • RE: SQLServerCentral apologizes and you can win a book

    kennethrbell (12/12/2013)

    Last evening I went to a Pacific NW SQL user group meeting. The guest speaker was Itzik Ben-Gan.

    Before that:

    I opened the “Apologies…” email last week from SQLServerCentral.com (very catchy...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 13, 2013 at 10:30 am

    #1673348

Viewing 15 posts - 1,996 through 2,010 (of 2,458 total)