Post reply

Are the posted questions getting worse?

  • October 19, 2017 at 7:21 am

    #1964342

    Lynn Pettis - Tuesday, October 17, 2017 4:33 PM

    Any help here would be nice.

    Added a response. Dono if that's what you're hoping for. But give it a read.

  • October 19, 2017 at 8:23 am

    #1964351

    Hey guys. Anyone willing to review a blog post on Phantom Reads that I am doing? Its not too long but I wanted a second eye over it. THANKS ALL!!

  • October 19, 2017 at 8:50 am

    #1964356

    BLOB EATER - Thursday, October 19, 2017 8:23 AM

    Hey guys. Anyone willing to review a blog post on Phantom Reads that I am doing? Its not too long but I wanted a second eye over it. THANKS ALL!!

    Sure, no problem. Just send it over.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • October 19, 2017 at 8:58 am

    #1964357

    Thom A - Wednesday, October 18, 2017 2:32 AM

    Jeff Moden - Tuesday, October 17, 2017 6:24 PM

    Lynn Pettis - Tuesday, October 17, 2017 4:53 PM

    How do companies end up with people like this working with their databases?

    The interviewers forgot to ask them if they know how to get the current date and time using T-SQL. 😉

    Heh... that would sound funny except for one thing... it's usually true.

    If you want, Lynn, you can play Windows Support instead: https://www.sqlservercentral.com/Forums/1902258/Windows-Server-2012 🙂

    No thanks.  I have been away from that side long enough to know enough that I would be dangerous.

  • October 19, 2017 at 8:59 am

    #1964358

    BLOB EATER - Thursday, October 19, 2017 8:23 AM

    Hey guys. Anyone willing to review a blog post on Phantom Reads that I am doing? Its not too long but I wanted a second eye over it. THANKS ALL!!

    If you want a third eye I would be willing to give it a read as well.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • October 19, 2017 at 10:45 am

    #1964377

    Grant should still be on sabbatical through thsi week or early next.

  • October 19, 2017 at 11:33 am

    #1964387

    BLOB EATER - Thursday, October 19, 2017 8:23 AM

    Hey guys. Anyone willing to review a blog post on Phantom Reads that I am doing? Its not too long but I wanted a second eye over it. THANKS ALL!!

    I can review it.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 19, 2017 at 12:26 pm

    #1964401

    Finally got around (after downloading it 4-5 times over the last several years) to giving SQLMonitor a test drive on my lab.

    Wish me luck, Monday I'm going to have a chat with the boss to see about getting it for my servers at the office to give me a more real-time view of what my boxes are doing and better reporting when people report problems.
    Plus, it'll be far easier to set up for the bosses to be able to get a 1000ft view of the status of the servers.

  • October 19, 2017 at 2:01 pm

    #1964425

    jasona.work - Thursday, October 19, 2017 12:26 PM

    Finally got around (after downloading it 4-5 times over the last several years) to giving SQLMonitor a test drive on my lab.

    Wish me luck, Monday I'm going to have a chat with the boss to see about getting it for my servers at the office to give me a more real-time view of what my boxes are doing and better reporting when people report problems.
    Plus, it'll be far easier to set up for the bosses to be able to get a 1000ft view of the status of the servers.

    If you want to keep the bosses out of your hair, go for a 5 mile view.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 19, 2017 at 3:30 pm

    #1964433

    Oh how I love third party databases. I have been working with this one off and on and am always surprised that the table I am looking at doesn't have a primary key so just for giggles I ran these two queries.


    select count(*) from sys.tables
    select count(*) from sys.indexes where type_desc = 'HEAP'

    tables = 495
    heaps = 433

    And people wonder why this system is so slow. :crying:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • October 19, 2017 at 3:54 pm

    #1964435

    Sean Lange - Thursday, October 19, 2017 3:30 PM

    Oh how I love third party databases. I have been working with this one off and on and am always surprised that the table I am looking at doesn't have a primary key so just for giggles I ran these two queries.


    select count(*) from sys.tables
    select count(*) from sys.indexes where type_desc = 'HEAP'

    tables = 495
    heaps = 433

    And people wonder why this system is so slow. :crying:

    My favorite recently, the first of those would have returned around 120.
    SELECT COUNT(*) FROM sys.indexes where index_id > 1
    returned 0.

    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

  • October 20, 2017 at 12:51 am

    #1964454

    Hugo Kornelis - Thursday, October 19, 2017 8:49 AM

    BLOB EATER - Thursday, October 19, 2017 8:23 AM

    Hey guys. Anyone willing to review a blog post on Phantom Reads that I am doing? Its not too long but I wanted a second eye over it. THANKS ALL!!

    Sure, no problem. Just send it over.

    Thanks Hugo. I will get it done over the weekend 

    Thanks to everyone else that offered too. (Wayne and Sean)

  • October 20, 2017 at 4:55 am

    #1964469

    Sean Lange - Thursday, October 19, 2017 3:30 PM

    Oh how I love third party databases. I have been working with this one off and on and am always surprised that the table I am looking at doesn't have a primary key so just for giggles I ran these two queries.


    select count(*) from sys.tables
    select count(*) from sys.indexes where type_desc = 'HEAP'

    tables = 495
    heaps = 433

    And people wonder why this system is so slow. :crying:

    Nitpicking, I know - but a primary key can also be implemented with a nonclustered index. So in theory (and I am really talking theory here) it is still possible that all those 433 have a nice nonclustered primary key on them.... :crazy:

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • October 20, 2017 at 7:56 am

    #1964487

    Hugo Kornelis - Friday, October 20, 2017 4:55 AM

    Sean Lange - Thursday, October 19, 2017 3:30 PM

    Oh how I love third party databases. I have been working with this one off and on and am always surprised that the table I am looking at doesn't have a primary key so just for giggles I ran these two queries.


    select count(*) from sys.tables
    select count(*) from sys.indexes where type_desc = 'HEAP'

    tables = 495
    heaps = 433

    And people wonder why this system is so slow. :crying:

    Nitpicking, I know - but a primary key can also be implemented with a nonclustered index. So in theory (and I am really talking theory here) it is still possible that all those 433 have a nice nonclustered primary key on them.... :crazy:

    Fair point Hugo. There are only 51 indexes where type = 2 🙂 Oddly there are 125 columns with the identity property set to true. I just find it amazing how sloppy some of these vendors code is. Another funny thing is the database landed on our system with no rows in any of the tables but they typically have to customize this system for each client so they add tables with their company name in them. There are dozens of these tables. Not used, why are they there?

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • October 20, 2017 at 8:56 am

    #1964504

    Gail might be interested in this, if she hasn't already heard about it:
    https://www.troyhunt.com/questions-about-the-massive-south-african-master-deeds-data-breach-answered/

    Some 65million SA records potentially leaked out into the wild, including the official SA government ID numbers...

Viewing 15 posts - 60,166 through 60,180 (of 66,569 total)

You must be logged in to reply to this topic. Login to reply