Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 2,462 total)

  • RE: Are the posted questions getting worse?

    For anyone out there experienced with SQLIO can you chime in on this thread. I'm still learning and am not the best resource on this. Thanks!

    "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

    May 8, 2015 at 9:04 am

    #1796610

  • RE: IO bechmark

    mxy (5/7/2015)

    thanks Alan for your response. I have completed all the test runs with different block size, results see to be good (I don't know ;-))

    ex for 8k block...

    "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

    May 8, 2015 at 9:00 am

    #1796605

  • RE: Temporary Stored Procedures

    Interesting article. I learned something new this morning.

    "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

    May 8, 2015 at 7:39 am

    #1796575

  • RE: IO bechmark

    I just started working with SQLIO in the past couple months. I am no expert but found this article to be very helpful:

    http://blogs.technet.com/b/josebda/archive/2013/03/28/sqlio-powershell-and-storage-performance-measuring-iops-throughput-and-latency-for-both-local-disks-and-smb-file-shares.aspx

    "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

    May 7, 2015 at 10:21 am

    #1796298

  • RE: is a+ certification is good for carrier ?

    First, welcome to SQL Server Central! You'll notice on the homepage that this site is "A Microsoft SQL Server community of 1,800,502 DBAs, developers and SQL Server users". Most 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

    May 6, 2015 at 7:41 pm

    #1796097

  • RE: XQuery - XML column

    or...

    declare @xmldoc as xml

    select @xmldoc = REPLACE('<Text>This is firstline<Break />This is second line<Break />This is third line</Text>','<Break />',CHAR(10))

    select @xmldoc.value('(/Text)[1]','varchar(max)')

    "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

    May 6, 2015 at 3:59 pm

    #1796075

  • RE: T-SQL Result Table Values From Query

    Ditto what Nevyn said about the DDL. In the meantime, it's worth noting that you don't every need a subquery or CTE with SELECT * FROM <table>.

    You could replace...

    "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

    May 6, 2015 at 2:45 pm

    #1796065

  • RE: Access 2010 to SQL Server 2008

    crowegreg (5/6/2015)

    Thanks for the reply.

    I haven't tried that yet. Since my test is with a very simple delete query, I wanted to make sure that its not a setting within...

    "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

    May 6, 2015 at 1:09 pm

    #1796050

  • RE: Access 2010 to SQL Server 2008

    have you tried creating a stored procedure in SQL Server that does the DELETE for you and then calling it from MS Access?

    I have not worked with Access in...

    "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

    May 6, 2015 at 11:45 am

    #1796033

  • RE: Curious use of % on where Clause

    In addition to what everyone else has said...

    Someone could explain what thas it´s mean.

    On a performance note it means that you're going to get an index scan instead of a...

    "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

    May 6, 2015 at 10:13 am

    #1796004

  • RE: Clustered Index suggestion requested

    A few things to consider:

    I have inherited a system which has very few tables with indexes. One table has 18K rows, expected to grow to 25K by year end,...

    "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

    May 6, 2015 at 10:01 am

    #1796000

  • RE: Compare tables with count

    Take a look at this thread:

    http://www.sqlservercentral.com/Forums/Topic1678555-3077-2.aspx#bm1679472

    "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

    May 6, 2015 at 9:28 am

    #1795981

  • RE: Archieving Data

    For the sake of discussion we'll just say that we want to archive stuff older than three months.

    The most basic approach would be to use a stored proc and...

    "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

    May 6, 2015 at 9:15 am

    #1795970

  • RE: Using sp_MSForeachdb to create a SCHEMA

    Shawn Melton (5/5/2015)

    Alan.B (5/5/2015)

    I'm not trying to belittle Shawn's solution as he was just fixing your code.

    It is worth noting, however, that sp_MSForEachDB is undocumented and you should...

    "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

    May 5, 2015 at 3:08 pm

    #1795767

  • RE: Shredding XML

    Erland Sommarskog (5/5/2015)

    Indeed you can. You can have multiple CROSS APPLY on nodes that relate to each other:

    SELECT

    testsuite.c.value('@name', 'nvarchar(20)') as testsuitename,

    tescase.c.value('@internalid', 'int')...

    "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

    May 5, 2015 at 3:01 pm

    #1795764

Viewing 15 posts - 1,531 through 1,545 (of 2,462 total)