Forum Replies Created

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

  • 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

  • RE: Using sp_MSForeachdb to create a SCHEMA

    Will read the entire OP moving forward.

    "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 2:50 pm

    #1795758

  • RE: Cannot find the object "Table_Name" because it does not exist or you do not have permissions.

    rpetit1230 (5/5/2015)

    I'm trying to run an Insert on tables using a User Login but I keep getting the error above. I ran the insert using my own credentials and it...

    "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 2:41 pm

    #1795753

  • RE: Are the posted questions getting worse?

    Luis Cazares (5/1/2015)

    Jeff Moden (5/1/2015)

    I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him...

    "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 1, 2015 at 2:53 pm

    #1795124

  • RE: SQL - Where Row_Number = 1 discussion

    w.zia.2015 (4/30/2015)

    Afternoon ladies and gents,

    I'm trying to find an alternative, more efficient way of processing some code to select the top row of a specific order.

    At the moment we use...

    "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

    April 30, 2015 at 9:39 am

    #1794749

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