| A community of more than 1,600,000 database professionals and growing |
| | | SQL Crossword #1 Enjoy our first crossword puzzle and see if you can solve all the clues. The key will be posted tomorrow. | Across 2. Column1 + Column2 is a ______ column. 5. Determines which set of characters is being used in a non-unicode column. 8. Only one of each value is allowed. 9. A query within a query 10. Parent element 11. Switch to the secondary automatically when the primary fails. 12. The index can go up (asc) or down (desc) 14. Change the database immediately by rolling back all open transactions. 16. A transaction is kept separate from all other transactions until it's completed. |
| Down 1. Last option to fix database corruption 3. GO 4. Indexes that uses more than one column. 6. End a transaction successfully. 7. Once a transaction is complete the changes are permanent. 13. 1 or 0 15. Alternate name |
Kenneth Fisher from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | Write, format, and refactor SQL effortlessly with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial |
| | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
|
|
|
| | | | | Frank A. Banin from SQLServerCentral.com Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL. More » |
| | Press Release from Redgate When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. More » |
| | Additional Articles from Database Journal Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function. More » |
| | Andrew Pruski from SQLServerCentral Blogs Up until now my posts about containers have been talking about working with one container only. In the real world... More » |
| | Arun Sirpal from SQLServerCentral Blogs So here we go, the first installment of my cloud blog series. From my experience this concern is a common... More » |
|
|
| | | Today's Question (by Steve Jones): For these questions, I am working with RStudio without any additional packages installed. I want to plot the number of Home Runs for Hank Aaron. I create a vector with the CU count: HankAaron <- c(13,27,26,44,30,39,40,34,45,44,24,32,44,39,29,44,38,47,34,40,20,12,10) Now I to graph his home runs over time showing the count of each relative to the others. However, I want to label the graph with the year of each count. I have this vector: Years <- c(1954:1976) What should I run before I do a barplot(HankAaron) to get an image like this? |
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: R Language. 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): What datatype is returned by SYSDATETIME()?
Answer: datetime2(7) Explanation: If you run SYSDATETIME(), you get a Datetime2(7) return value. This can be implicitly converted to many other date types. Ref: SYSDATETIME - click here » Discuss this question and answer on the forums |
|
|
| | | | Aakash Patel from SQLServerCentral.com This sql script will give you thorough report about sql server jobs based on historical data. The user can change the dates to narrow down the stats. Make sure you are monitoring DB health specially when you running it against PRODUCTION DBs. 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. SQL Server geo-cluster 2016 - Dear Everyone Ikeep reading online that its not recommended to virtualize SQL Server clusters (4 nodes) Backup command with multiple threads. - Hi, Is there any switch / option is available to take the backup in multiple threads (parallelism) so that it can be... AlwaysOn Missing Redo Thread - Morning Guys, I have one particular database that isn't large or overly active but has stopped redoing logs on ONE of the replicas. We... Odd Behavior by Instance - I have multiple SQL Instances Our Developer and Integration Testing run on a virtualized host environment. I have User Acceptance... List of all dtsx files used in - I need help with the SELECT statement - How may I write a SELECT statement that will list each SSIS Package and the dtsx files that go with... Difference between (where ID = 543 vs Where ID = '543') - Is there any advantages, disadvantages, system overhead etc if let's say I use a '543' vs 543 in a where... My db has a lot of PAGELATCH_SH waits going on - Hi all, Hope this topic is in the right area. I have a highly normalized Dynamics AX database, and lately there... SQL QUESTION but SSIS related - How do we get a list of parameters used by each DTSX file ? - As you see, we have great list of SSIS packages. I am sure there is some table that keeps track... How to View OR Retrieve all the tabs in SQL. - SQL query windows saves all the tabs in numerical sequence after you close each window. SO for example if you... Next row begins - Ok so what I am wanting to do is fill in rows with information that is missing from a file.... time - missing colon : - i have received a legacy data files from vendor time values are sent without semicolon , can you help me how... Expensive View help - Hi Guys I have the below query which is part of a view. This query takes > 5 minutes to complete.... Copy information from SQL to Excel without VB (just plain copy/paste) issue... - Hi there, I am doing some normal Selects on a database (SQL 2008), and I want to copy using copy/paste the... Formatting in HTML table - Hi guys, I have created a HTML table dynamically to send on mail. That table contains few amount columns. It's... Recovery Pending Status - Good Morning Experts, One of our databases went into "Recovery Pending" Status. Could you please share the steps to fix it. Some linked server connections stop working - I have a 2008R2 Standard instance (2008R2 SP1 10.50.2500) which has developed strange problems with linked server connections. All of... Anyone using Python? - This was brought up in the automate everything article, so I figured I start a new thread on the topic. Anyone... SSDT Execute SQL task is not resolving parameters - Summary: SSDT is not resolving parameters in a simple statement DROP TABLE . Details: Environment: Microsoft Visual Studio 2015 Shell (Integrated) Version 14.0.23107.0... Lookin for Reference for EDI Using SSIS and X12 Format Files - Let me start by saying that I'm not looking for assistance in solving a work problem. I'm looking to improve... Production DBA Vs Project/Development DBA - Hi, Does anybody have any reference points for how the role of a production DBA may differ from that of a... |
|
| 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] |
|
|
