| A community of more than 1,600,000 database professionals and growing |
| | | Happy Thanksgiving 2017 Happy Thanksgiving to the US SQLServerCentral community. I hope you have a wonderful holiday and you're not working today. For the rest of the world, I hope it's a quiet Thursday, all your queries run fast, and nothing causes you any undue stress. Today is a day that used to be almost universally celebrated in the US, with most businesses being closed. This day used to be close to Christmas, and a good day for most of the country to relax and enjoy time with family. Certainly some people always need to staff certain positions, and there were often restaurants and leisure businesses, like movie theaters, that were open. That's changed a bit, with more businesses being open, and some companies even starting Christmas sales today, ahead of Black Friday. For me this will be a day off, relaxing with family as my kids will be here, back from college and work, to have some family fun. A nice meal, some games, maybe a movie at home. At least, I hope we'll stay home. All the travel for me this year has me enjoying the moments I get at home. Today should be a nice day to recharge for me, and I hope a good one for you as well. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | 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 |
| | | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | | | | Michael Morin from SQLServerCentral.com Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms. More » |
| | 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. More » |
| | By being able to run R from SQL Server, you have available to you not just a convenient way of performing analysis on data but also a wide range of more specialized graphical facilities. Rob Sheldon illustrates the point by demonstrating how you can create sparklines that can then be embedded in reports. More » |
| | Andy Warren from SQLServerCentral Blogs Every year when many of the SQLSaturday event leaders meet at the Summit the topic of improvements to the tools... More » |
| | Mala Mahadevan from SQLServerCentral Blogs Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In... More » |
|
|
| | | Today'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. |
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: T-SQL. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this code, which creates two variables a <- array(1:12, dim = c(3, 4)) b <- 1:12 This gives me a matrix and a vector, as seen here: > a [,1] [,2] [,3] [,4] [1,] 1 4 7 10 [2,] 2 5 8 11 [3,] 3 6 9 12 > b [1] 1 2 3 4 5 6 7 8 9 10 11 12 If I run this, what happens? a == b
Answer: A matrix of 12 TRUE values Explanation: R will attempt to compare variables that are nearly equal with the == operation. If we used the identical() function, this compairson would fail. Since the values can be matched up by R, the comparson will return a matrix of 12 TRUE values. Ref: Using Vectors and Matrices - 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. Tool for SQL Server code tuning - Hello experts, Is there a free or a paid tool/software that can be used to provide t-sql recommendations or that can... Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb? - Hi Is there any reason why the below DBid order is maintained? Master - 1 TempDB - 2 Model - 3 MSDB - 4 Slow query - client or server issue - If seeing a client make a regular query that uses the same plan but completes in radically different times on... Does anyone use views in this way? - Hi, I know there are several cases where we as database developers need reference tables to help us with our querying... 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... Trigger to notify when mssql job is disabled - I have a trigger that will let me know when a job is disable or enabled how do i add... 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... Tricky LAG() and Windowing Script - I have a requirement where 3 records *should* be getting recorded on the patient at the same time. However, occasionally... 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... The slab consolidation / trim operation cannot be performed because the volume alignment is invalid - Has anyone seen this error? I received it when attempting to run defrag analysis (defrag S: -a -v) on a 64K... Better TSQL Performance - Hi everyone, I am trying to improve query performance, I have encapsulated the following query into a stored procedure and have... Force execution plan in a view - I'm having an issue right now. We removed an identity column that is mostly irrelevant to a table. However, this... Add New Column Based on Criteria - Hello, I have: select * from #test_table INSERT INTO #test_table (, , , , , , ) VALUES ('2016-11-01 00:00:00.000', 'voucher', 10, 'up', 22,... Merging multiple tables from one database in to another one in a single table on incremental basis - Hello All, I require some suggestion for one of my requirement. I have a SQL Database where 30 tables are created automatically... Log file R drive- What is consuming it - Good Morning Experts. We have a SQL Server instance. All the user databases log files are on R drive. We have... Why SQL Server is not using non-clustered index - In SQL server 2008R2, Table having Non-clustered index and table contains 2 crore records, while executing "Select count(*) from table... SSRS Excel export group filtering - Hi I'm building a tablix with several groups (I'm trying to avoid repeating the same value) - this is great when you... Good to have Multiple Data Warehouses? - Interesting debate came up on data warehousing. Is it good to have multiple data warehouses or just one? To add some... 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] |
|
|
