Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Give away something you have been holding on to

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

All I Want for Christmas

I've been learning to play All I Want for Christmas this fall, hoping to have some fun with the family during the holiday. Hopefully it's a festive, fun time of year for many of you out there, despite the challenges of this pandemic year. As I was listening to the words, I thought about what I'd want this year.

2020 has been disruptive to me, as someone that often travels and meets lots of people. Trying to comply with regulations, as well as stay safe, has meant parts of my job have changed this year. One thing that hasn't changed is that I still work most of the time in my home office, which is a change that many of you got to experience this year. I wasn't sure how people would cope, but most of the friends and colleagues I speak with have enjoyed working at home.

While I do think the world of work for technology people has likely changed, I also suspect that some of you won't get to keep working at home forever. There are certainly managers that don't like this format, though I hope this year has opened their eyes to understanding just how productive people can be, even when not visually supervised.

One of my wishes for Christmas is that we find a way to hold some live events next year, with speakers and attendees getting to be in the same room, network, and shake hands. I know this won't happen soon, but I'd happily skip other presents if this would come true sometime in 2021.

I suspect that many people this year have varied wishes for this holiday season, mostly for the health and well-being of their families, but perhaps some other more tangible hopes as well. In any case, I wish you joyous celebrations and smiles with loved ones.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents

Download SQL Patch Info

Theo Ekelmans from SQLServerCentral.com

This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.

Deep Learning with GPU Acceleration

Additional Articles from SimpleTalk

Deep Learning theories have been around for many decades, but solutions have not always been practical due to hardware constraints. In this article, Shree Das explains how GPU Acceleration can help organisations take advantage of Deep Learning to speed up training of neural networks.

Database Build Blockers: Four-part Object References

Additional Articles from Redgate

Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms.

From the SQL Server Central Blogs - Placing my Bid for SQLSaturday.com

Steve Jones - SSC Editor from The Voice of the DBA

I’m making my bid. I don’t know this brand needs to continue, or that it will, but I’d like to hold this for posterity, at least in an interim...

From the SQL Server Central Blogs - SQL Puzzle – Eight Queens on a Chess board

matthew.mcgiffen 73574 from Matthew McGiffen DBA

Here's a SQL Puzzle for the festive period. 2020 has been a year of many things but amongst it all, it has been the year of chess. The combined...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Merry Christmas 2020

I have a list of songs in a table. I've written a program to retrieve a song from my table and then play it on my Raspberry Pi jukebox. Which of these queries will give me a new random song with each connection from the jukebox?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Starting a Python Program

I have a Python script full of functions. When I run this as a program, which function will be executed first?

Answer: The function named "__main__"

Explanation: The main function is the one that will be automatically run when your script is run as a program. Ref: The main function - https://docs.python.org/3/library/__main__.html

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.

SQL Server 2017 - Development
insert data from Form into two different tables - I have a form with fields to fill : NAME_POSTE, NamePrinter, PathPrinter for example: NAME_POSTE: poste1 NamePrinter: name imp 1 PathPrinter: path 1 when adding these values, I want to insert it into two différents tables: CREATE TABLE Postes ( PK_POSTE int NOT NULL PRIMARY KEY ,NAME_POSTE varchar(20) NOT NULL ); CREATE TABLE Params_Poste ( […]
SQL Server 2016 - Development and T-SQL
Pulling stats for multiple columns out of a table efficiently - Dear Experts I have a table that accumulates daily stats, defined so: CREATE TABLE [dbo].[Stats2]        ([StatsDate] [datetime] PRIMARY KEY,        [TypeA_Calls] [int] NULL,        [TypeB_Calls] [int] NULL,        [TypeC_Calls] [int] NULL); I need a SELECT statement, or sequence of statements, which can pull out the earliest and latest date on which each stat is […]
Administration - SQL Server 2014
SQL performance on couple queries are better on older compatibility - Hello, So i have a SQL server 2014, SP3, with 256 gigs of memory, 32 cores, windows 2012 R2 i faced this issue the other day, when the database was on Compatibility level 2014 (120), the query was performing poor, like it would never return. HOWEVER, when i switched it from from Compatibility level 2014 […]
SQL 2012 - General
How to use Cursor to Execute stored procedure where featurevalue is bigger than - How to use Cursor to Execute stored procedure where featurevalue is bigger than 0 ? I work on SQL server 2012 . I face issue I can't use cursor to execute stored procedure when feature value is bigger than 0 . I have stored procedure must execute with every line where feature value is bigger […]
How to get zplid that have zfeature key value on all rows? - Exactly I need zplid and codetypeid that have feature value on all rows . if I have Null on zfeature key on one row then I don't Need it . I need to get zplid that have features Not Null on all rows as zplid 9714 but 9823,5890 have Null so I don't Need it […]
How to delete Max PartDetailsId for Reapeated parts Based on CompanyId and PartI -   I work on SQL server 2012 . I face issue I can't delete max PartDetailsId from part details based on part ID and company id that related to main table parts . if Part ID repeated on partdetails then I get max PartDetailsId by companyid and partid as Part ID 1222 and 1901 and […]
SQL Server 2019 - Administration
SQL command returning - - Hi All, I run a online game, and sometimes a player will have neg stats. This is now causing neg score for neg stats. I would like to cap this at 0 if the stat is neg, but im not sure where I am going wrong. This is what I have so far. update #p […]
column has a single quotation causing error - Hello, while trying to insert records to a table making joins between several tables, its found that one column has such entry with a single quote (for e.g, Record'ng date is on Feb 2010 t0 -678659x). Can I either use quotename() function or do you suggest some escape function in order to load the data? […]
SQL Server 2019 - Development
B2G((+27609335000))SSD CHEMICAL SOLUTION IN SOUTH AFRICA, - B2G((+27609335000))SSD CHEMICAL SOLUTION IN SOUTH AFRICA,ssd chemical solution in mpumalanga+27609335000,ssd chemical solution in durban+27609335000,ssd chemical in qator+27609335000 ,ssd chemical solution in germany+27609335000 ,ssd chemical solution in england+27609335000,ssd chemical solution in mpumalanga,ssd chemical in free state+27609335000 ,ssd chemical in switzeland+27609335000 Malaysia, Johannesburg,Lebanon, Zambia,USA,Kenya, California, Dallas,England,German,Spain, Jamaica,St,Lucia, Brasil,Austria,Vancouver, Denmark,Hong Kong, China,,Pretoria, Durban, Australia, Wales, France,Cairo,china, Norway,, Botswana, […]
Join 2 sum cases - Hi Guys, Can someone help me with the below.  I need to joins the below two so that I only have one column. I'm struggling how to get there. SUM(CASE RepairCodes.[Service] WHEN 'Y' THEN 1 ELSE 0 END) AS SERVICE ,SUM(CASE ServCode WHEN 'MST' THEN 1 WHEN 'S&M' THEN 1 ELSE 0 END) AS SERVICE […]
How to use the column name alias from a case statement to a join statement - Hello While trying to use the case alias column in the join statement, getting the invalid column error. Error msg: Invalid column name 'ST100'. SELECT TOP (1000) CASE WHEN [Sx].ac_No IN ( 'ARC' ,'GFT' ,'DHG' ,'STF' ,'FRX' ) THEN '45010' ELSE CD.Idea END AS [ST100] FROM CONSUL AS CD LEFT JOIN table2 AS [Sx] ON […]
Reporting Services
Error: Sub report could not be shown - Hi Guys, I am so stuck, and have been for several days now. I am running SQL Server 2014, 2014.0120.6372.01 I have a report which has many sub reports within, the sub reports are all the same report but I pass in a different parameter for each one. Sub Report 1 = Parameters!BusinessArea.Value(0) Sub Report […]
Reporting Services 2008/R2 Administration
SQL services stops not accepting connection - SQL 2008 R2 service pack1 SQL server not accepting connection error in event log A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service. error in sql server errorlog Using 'dbghelp.dll' version '4.0.5' **Dump thread - spid = 0, EC = 0x0000000000000000 * BEGIN STACK DUMP: * A fatal […]
Integration Services
SSIS ForEach Loop Container for XML Files with mixed content - Hello, (can't upload images into body, neither .png or .jpg, size is less then 1024KB) My goal is to read data from XML files into SQL table. The main issue is that those XML files have mixed content that is not supported through XML Source. To overcome this issue i used XML Task with XSLT […]
Article Discussions by Author
Download SQL Patch Info - Comments posted to this topic are about the item Download SQL Patch Info, which is is not currently available on the site.
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -