| A community of more than 1,600,000 database professionals and growing |
| | | The Most Wanted Upgrade I replaced the case on my desktop recently, though not without a few struggles. A damaged motherboard in the move, and then a DOA replacement caused me a bit of a headache while troubleshooting. Fortunately, I was able to get a few minutes with Glenn Berry to find the issues. Things are back up and running now, which is good. I like my desktop and I'm more comfortable doing most of my work there. The process got me thinking about upgrades, especially when I got a look at Glenn's newest machine. He hasn't published details, but he did post a few results for his Intel Optane 900p PCIe cards. He also dropped a picture on Twitter of his Threadripper CPU. That's quite a Task Manager display for a desktop workstation. I don't know that I need that much power, but it's still impressive and exciting. Seeing a recent picture of Andrew Kelly's 38" 4K monitor for his new workstation has me drooling a little, even though I don't really need more hardware. It's Black Friday, and while I doubt many of you are out shopping for yourselves, I do wonder if there are upgrades that you'd be excited to get. If someone were to gift you some computer hardware, what would you want? It could be hardware or software, desktop, mobile, whatever type of upgrade you'd want. Let me know today what you wish someone would give you for a present. I'm not an enthusiast. I think my son spent almost as much on his video card upgrade as I did for a motherboard, CPU, and RAM. However, I did get a little excited in looking at the various options in the Denver Microcenter store last week. From 3D printers to CPU water coolers to fancy video cards, I was tempted by no shortage of high end hardware. I don't really need anything, and even passed on adding RAM to my desktop. 32GB works great for me, and while I might squeeze a touch more performance out of another 16 or 32, I don't really need it. I am tempted by a set of larger, high resolution monitors. The idea of a couple of large, 38" monitors that would spread work across my desk is tempting. Probably overkill and silly, but enticing. If I were to really dream about some upgrade, I'd like to get some faster internal 3D storage for my system. I hate waiting for programs to start, and getting some faster internal NVMe storage to replace a legacy 1TB HDD and get my system moving quicker. At heart, I'm a practical computer user, but I can appreciate the effort that some people put into build their systems. I'm just not sure that I'd want any of the fancy RGB lighting or as many cores in my video card as I have in my CPU. I'm also quite pleased with my mobile devices, so I don't want an upgrade there, though I wish I could get a device with a different (bigger) battery. You might feel different and perhaps you can change my mind today. What cool upgrades would you make if cost were not an issue? Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.0MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | Extending DevOps practices to SQL Server databases In this demo-heavy session you’ll see how Redgate’s SQL Toolbelt allows you to take a local development database, source control it, set up automated builds and automate deployments to an Azure SQL database in less than an hour using VSTS. Register now |
| | | | Register now for SQL in the City Streamed Redgate’s popular SQL in the City Streamed virtual event takes place again this December. Wherever you are, tune in on Wednesday December 13 to watch some of the best-known speakers from the database world present the latest technologies and tools from Redgate. Register free now |
|
|
|
| | | | | Bob Hovious from SQLServerCentral.com This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined. More » |
| | Whether you’re exploring the advantages of DevOps or already fully immersed in the journey, including the database brings additional advantages. But how are you performing compared to the competition? What could you do better? What’s the benchmark you should be aiming for? More » |
| | Don Halloran from SQLServerCentral.com Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups. If you've ever received the message "login failed... More » |
| | Matthew McGiffen from SQLServerCentral Blogs I’ve not done a SQL puzzle for a while so thought it was getting overdue… I set this one for my... More » |
|
|
| | | Today's Question (by Junior Galvão - MVP): | SQL Server will consider parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population. You can override the max degree of parallelism value in queries by specifying the MAXDOP query hint in the query statement. You disable parallel execution plans for these statements using which trace flag? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Max Degree of Parallelism. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): The Chargers-Cowboys game that takes place today will start at 3:30 in Dallas, TX. I've got the time stored in a variable DECLARE @d DATETIME2 = '20171123 3:30pm' If I am in Denver, I want to be sure plan dinner around the game. How can I get the time the game starts? Hint: Dallas is in the Central Time Zone, Denver is in the Mountain Time Zone. I will run the query in the Mountain Time Zone.
Answer: SELECT (@d AT TIME ZONE 'Central America Standard Time') AT TIME ZONE 'Mountain Standard Time' Explanation: The AT TIME ZONE clause can be added to a datetimeoffset, with a target time zone specified. If the input value isn't a datetimeoffset, the local date time offset is used. This means that the inside AT TIME ZONE will return a datetimeoffset at Central Time. We need to then convert that to Mountain time for the correct Denver time. Ref: AT TIME ZONE - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. SSIS : Rounding a numeric value - Dear all, I have a numeric value in SSIS like = numeric 28,14 and I have created a new derivated column to... ICQ No. : 722403840 Sell Cvv Good Fresh Sell Cvv Good Fresh Sell CVV all country us,uk,ca,au,eu,asia...Fresh=> Price cheap Hi everycustomer, i have shop CVV and site tool shop. i work prestige, professional If you need CVV please contact me for ICQ No. : 722403840 Gmail :... - ICQ No. : 722403840 Sell Cvv Good Fresh Sell Cvv Good Fresh Sell CVV all country us,uk,ca,au,eu,asia...Fresh=> Price cheap Hi everycustomer, i have shop... SQL server 2016 - Backup definition - Hello. I have SQL server 2016 over a Windows server 2016 on Amazon web service, I need to set up backup´s from... AG Listener not working with OLAP Cubes \ Tabular Cubes \ Linked Server Connections - Greetings, My team and I have been working for some time to establish Always-On Availability Groups in our production warehouse environments.... Check for existense of database master key in "all" databases - Hi there, I'm struggling with a little query here. I'm much more a DB admin than programmer, so I really got... ICQ No. : 722403840 Sell Cvv Good Fresh Sell Cvv Good Fresh Sell CVV all country us,uk,ca,au,eu,asia...Fresh=> Price cheap Hi everycustomer, i have shop CVV and site tool shop. i work prestige, professional If you need CVV please contact me for ICQ No. : 722403840 Gmail :... - ICQ No. : 722403840 Sell Cvv Good Fresh Sell Cvv Good Fresh Sell CVV all country us,uk,ca,au,eu,asia...Fresh=> Price cheap Hi everycustomer, i have shop... Visual Studio 2017 - Display Data Flow Rows - Hi All, Sorry if this is the wrong forum I'm nor sure where to post it. I am using Visual Studio... Do we need license for SQL 2016 Dev Ed ? - Hi We are planning to use use SQL 2016 Dev Ed. in dev and test enviroments. I have not found out... Date Ranges - Simple, but seemingly impossible - Hi all, I've done a lot of research and tried so many things for around a week. I'm desperate at this... trying to edit a stored procedure - i have a stored procedure exec usp_Sizing this is the bottom half it works very nice. my question is where i have... Cluster Behaviour - Hi Experts, We have a 2 Node Active \Active Cluster of BizTalk and 2 Node Active\Passive cluster for Application. The Second... Choosing the Birthday of a Customer by month? - CREATE TABLE birthdays( cust_id INTEGER NOT NULL PRIMARY KEY ,cust_fname NVARCHAR(50) NOT NULL ,cust_lname NVARCHAR(50) NOT NULL ,cust_dob DATETIME NOT NULL ); INSERT... Endpoints Sql server - Hello, guys.I thinking for something but not really sure.Is it possible to make a endpoint in sql server 2012 for... Better TSQL Performance - Hi everyone, I am trying to improve query performance, I have encapsulated the following query into a stored procedure and have... Column Length - Dear All, Question regarding the length of a column . As its understandable it has to be in accordance with the data... How to get Qty value? - Hi Friends, I have table two tables desc table1 company_no varchar(10) invoice_no varchar(20) locn_no varchar(10) model_ref varchar(20) item_type char(10) item_code varchar(10) QTY varhcar(20) desc table2 company_no varchar(10) order_no varchar(20) locn_no varchar(10) model_no varchar(10) item_ SQL Server memory consumption is more - OBJECTSTORE_LOCK_MANGER is consuming more memory. Any idea how to fix this? I have attached image for reference Windows server Mmemory 32... Split function - Hello, I need to pass a comma separated values to subreport. The string that is used to obtain input parameters is... "Invalid column type from bcp client for colid xx." - Hello, I have an issue with transferring some data from prod to uat, the two tables are identical. I first thought... Table Design - Dear Experts , Please share if there are any standard guidelines for designing the table objects , apart from Normalization , and Column... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
