Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 49,552 total)

  • RE: Indexes not shown in sys.objects

    Correct, indexes don't show up in sys.objects. You'll find indexes in sys.indexes (they're not considered objects like tables, procedures, constraints, etc are)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 21, 2016 at 8:13 am

    #1902180

  • RE: Are the posted questions getting worse?

    BLOB_EATER (9/21/2016)

    Earlier in the year I applied for a PFE role which I didn't get but reached the last round. I was wondering if you guys think it would be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 21, 2016 at 7:53 am

    #1902171

  • RE: Read data row wise with multiple transaction

    I strongly recommend you reconsider the entire process.

    Leave .net out, other than to call the stored procedure. Write the load process in T-SQL in a single batch. Do the same...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 21, 2016 at 7:00 am

    #1902145

  • RE: Stored Proc for .net application which use multithread

    Please don't post multiple threads for the same question.

    No further replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1819483-3740-1.aspx

    As I said in the other thread, I would recommend you not use .net, not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 21, 2016 at 5:48 am

    #1902127

  • RE: Read data row wise with multiple transaction

    A million rows is not large, and processing row by row is inefficient.

    Don't do it from .net (even slower), do whatever you need as a single transaction in T-SQL.

    If...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 21, 2016 at 5:42 am

    #1902124

  • RE: Instant file initialization and tempdb log

    No. TempDB uses existing files, they're just cleaned on a restart. It's only if the files aren't there that it will have to create and size them.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 1:40 pm

    #1902020

  • RE: Are the posted questions getting worse?

    BrainDonor (9/20/2016)

    New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

    My favourite Friday shirt (not casual fridays, because every day is casual dress) is one that I got from the MS company store...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 1:34 pm

    #1902016

  • RE: Are the posted questions getting worse?

    Phil Parkin (9/20/2016)

    TomThomson (9/20/2016)

    Phil Parkin (9/20/2016)

    BrainDonor (9/20/2016)

    New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

    But I don't know if I can - shouldn't the first full-stop be a comma? I think it...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 1:32 pm

    #1902014

  • RE: How to optimize my current sql query without using a sub query

    I don't have time to rewrite it (and no DDL anyway), but the main performance problem there is the TOP (1) ... ORDER BY in the subquery.

    Try changing the subquery...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 9:27 am

    #1901922

  • RE: SP inserts into table

    The table name is specified as a parameter

    @table varchar(30)

    That is horrible design and a security nightmare. Completely vulnerable to SQL Injection since no checks are done on the parameters. Terrible...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 9:21 am

    #1901919

  • RE: Non-clustered index question

    Mike Scalise (9/20/2016)

    To me, it's the difference between the overhead to maintain a clustered index when rows are INSERTED/UPDATED vs the overhead to maintain the copy of the data (the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 9:19 am

    #1901917

  • RE: Virtual Servers - are separate drives still Best Practice in SQL 2014

    Depends

    Are you talking about separate VM drives which are just virtual hard drives on the same physical device? If so, no point (other than logical separation and easier space management).

    VMs...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 9:03 am

    #1901909

  • RE: Non-clustered index question

    Mike Scalise (9/20/2016)

    However, if I add only a non-clustered index with ID as the key, then the table becomes ordered, much like it would if I created a clustered index...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 8:58 am

    #1901906

  • RE: Non-clustered index question

    Mike Scalise (9/20/2016)

    If I create a non-clustered index on ID and include the rest of the columns (first name, last name, and middle name), is that effectively the exact same...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 8:56 am

    #1901904

  • RE: Migrate from sql server 2005

    tbague (9/20/2016)

    My intention is will not accept new connections on old server, make a full backup of 2005 database, restore it in the new server with sql server 2016.

    That'll work.

    You...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 20, 2016 at 4:20 am

    #1901818

Viewing 15 posts - 2,356 through 2,370 (of 49,552 total)