| A community of more than 1,600,000 database professionals and growing |
| | | The Slow Week This is usually a very slow week for most organizations. Staff is on vacation, customers aren't demanding much, and it's entirely possible if you're in the office today that you're a bit grumpy as Monday was Christmas and many of us haven't had quite enough of a holiday this year. With many employees in the same situation, and another holiday coming next week, it's likely that everything in your shop is moving a bit slow. Certainly there are no shortage of people that might be on vacation this week. Usually it's a ski week for me, but not this year. Some of you might be just as motivated to get things done this week as any other. In fact, with less people around, you might even be more productive and perhaps are taking advantage of the time. Others of you might be trying to mosey along through your workday, enjoying a relaxed pace of work. I find that this is a good week in the office for me to catch up on some work that might not get a priority the rest of the year. Perhaps there are some processes that I've been wanting to automate, but never found the time. Perhaps my automation isn't quite as robust or resilient as I'd like. These are the times when I can actually make a few changes and try to improve a system for the next year. If I finish early, then I'll often use this as a chance to learn something or tackle some POC that's on my list. That hasn't always been the case. My first exposure to SQL Server was with a system that went live on Dec 31 at midnight. In the week leading up to the launch, I was working with various other employees and contractors to get a plan in place for the cutover, including new equipment installed and all the various networking and security changes that were required. It was a busy week for me, and one that sticks in my mind. Despite all the prep work and testing, after turning the new system on we found that it couldn't handle the load. Rollback wasn't an option, so my 5pm-2am shift didn't go as planned. I worked through the next day and into the early evening before being relieved. If you have a slower week, consider taking advantage of the time to do something interesting at work and have some fun in a way that might benefit you and your employer down the road with a new script, a stronger skill, or even a better way to handle some task. There are still a few days this week that you can use to try something. 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 | | | | Watch SQL in the City Streamed 2017 The livestream recording for Redgate's 2017 virtual event is now available. Technical sessions went into the latest Microsoft SQL Server releases, and covered topical issues such as DevOps, data compliance, protection & privacy. Watch the recording |
| | | | SQL Clone: Now supporting databases up to 64TB Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free |
|
|
|
| | | | | Erin Stellato from SQLServerCentral.com In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers. More » |
| | Press Release from Redgate When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do. More » |
| | Additional Articles from SimpleTalk Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you make the right choice for your application. More » |
| | Steve Jones from SQLServerCentral Blogs Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More » |
| | Roland Alexander STL from SQLServerCentral Blogs The obesity epidemic is much in the news these days. The list of health issues related to being overweight is... More » |
|
|
| | | Today's Question (by Steve Jones): It's the third day of Christmas week and fun questions (with one more less point). The question today is who said this? "Bah Humbug" The answer comes from this data set. What's the order by? SELECT TOP 1 answer = SomeName FROM ( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'), ('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'), ('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'), ('George Bailey', '''s a Wonderful Life', 'Adult', 'Falls') ) AS a (SomeName, Movie, Age, Genre, Locale) ORDER BY |
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 5 points in this category: humor. 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 | | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): It's the second day of Christmas week and fun questions (with one less point). The question today is who said this? "One can never have enough socks. Another Christmas has come and gone and I didn't get a single pair. People will insist on giving me books." The answer comes from this data set. What's the order by? SELECT TOP 1 answer = SomeName FROM ( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'), ('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'), ('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'), ('Buddy', 'Elf', 'Teenage', 'Comedy', 'New York') ) AS a (SomeName, Movie, Age, Genre, Locale) ORDER BY
Answer: age desc Explanation: Dumbledore is today's answer. Hope you're having a good holiday week. » Discuss this question and answer on the forums |
|
|
| | | | Alexander Parakhnevich from SQLServerCentral.com I've just started to use columnstore Indexes in a SQL Server 2016 for a datawarehouse and realized, that it would be nice to have a SP, doing a maintenance of my ccix and ncix, without to know how they called and in wich tables they are :-) After examining of this info: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-defragmentation following scenarios came into my focus - 1) I would like to be able to start a maintenance of a columnstore Index for a table, after data was loaded in it from a SSIS package. 2) I would like to start a maintenance from aMS Job Agent for all ccix in some schema in my database, after all ETLs have been completed. 3) I would like to proceed with a maintanance for all ccix within a database All of this I would like to do in a simple way, just giving names of db, schema or table to a store procedure. Also I would like to be able make a choice if I do it with a rebuild or with a reorg. I have solved it for me and I'm glad to share it with you. I belive everyone who is developing for a data warehouse with columnstore Indexes and tries to avoid OPEN row_groups from DeltaStore will need it:-) Usage examples: 1) Command runs a reorg for all colunmstores (for only partitions with OPEN RGs) in MyDB. exec [dbo].[usp_Maint_ColumnStore] @database='MyDB' 2) Command runs a rebuild for all columnstores (for all partitions in each table) in MyDB exec [dbo].[usp_Maint_ColumnStore] @database='MyDB', @Mode='reb', @Partitions='all' 3)Command runs a reorg for all columnstores (in all tables) in MySchema in MyDB exec [dbo].[usp_Maint_ColumnStore] @mode='reorg', @database='MyDB', @schema='MySchema' 4) Command runs a rebuild for a columnstore in MyTable existing in MySchema in MyDB with compression 'COLUMNSTORE_ARCHIVE' exec [dbo].[usp_Maint_CumnStore] @mode='reb', @database='MyDB', @schema='MySchema', @table='MyTable', @compression='arc' More »
|
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Antivirus Exceptions - Yes or No? - Hi Folks, I heard an interesting conversation today about whether or not Antivirus Scanning exceptions (in this case provided by McAfee)... Tempdb growth - Hi, I have a huge insert/update operation performing in set of tables. The process tooks almost 1-2 hours to complete. Meanwhile... case statement - I'm using two cases separately to display the result as two columns, but I'm getting the result of only first... ENCRYPTBYPASSPHRASE Output Length Difference - We noticed there is a difference in the length of the output from SQL Server 2008 and 2014 versus 2017.... Combine 3 SQL queries - Hello, I want the combine the following queries Select Complains. as NewComplains,Complains.ID AS ComplainID from Complains where Complains.ReadStatus = 'false' Select Suggestions. as... I want get html report from log shipping - I want to get HTML report from log shipping, here is my script... please modify it ##setup data source $dataSource1 = "MANU\PRACTICE" ##SQL... FCI + Always On - Hi, I want to setup a 3 nodes solutions. NODE_A, NODE_B and NODE_C are part of the same WSFC. Node_A -> Contains... Setting a variable using select with other variables in the select statement - To all:. Happy Holidays. I need some help on this statement. Currently this works but I need to change it to... Server Not Responding - Hi Experts, The active server in 2 Node Active\Passive Cluster having another Always On AG node was not responding till we... Memory issue .. cloudberry service getting stop with following error - HI Everyone, I am getting this error on SQL server developer edition 2014 SP2 server . We have installed the cloudberry service... is there a way to auto-gen crud sprocs in ssms 2017? - Is there a way to auto-gen CRUDsprocs in SSMS 2017? For example, a basic User table might just need cookie... Using hardcoded database names in query when database names are different on development and production server - I have a database 'DatabaseA' which exists on a development server and a production server (called 'DatabaseA' on both servers).... Two tables, exact same structure but with different names, behave differently while performing mass updates. - Hi all, This has me stumped. I'm performing mass updates to a table. I'm using Data Masker by Redgate to de-identify... Choose: SQL 2012 Enterprise or SQL 2016 Standard - That's the choice I've been given. 1 month into work at a small business with 1 well used 2008 r2... Group by with min and max dates - Hi All and Merry Christmas! I have what I thought was a simple requirement. I have to modify a table that has... How to do Parallel Query Execution in SQL Server - Hey Guys, I stuck in a situation where I need to do parallel maintenance on few tables, Can someone please suggest... Need some suggestions on query execution plan - Hi All, Need some advise on the query plan analysis. There is stored proc within which a dynamic sql is... SAN replication - does SQL service need to be shut down before copying? - We're moving to another datacenter. The plan is to replicate all data using SAN replication (HP 3PAR) to the new... Reduce records in a slowly changing dimension table - I have a table that tracks groups over time using a start and end date columns. Some of the groups... Oracle Linked Server query error - unable to read certain data - We have a problem with a query from a SQL Server 2008R2 - 64bit to an Oracle Linked Server. We use the... |
|
| This email has been sent to newsletter@newslettercollector.com. 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.
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: webmaster@sqlservercentral.com |
|
|
