| A community of more than 1,600,000 database professionals and growing |
| | | DMO Word Scramble Unscramble the DMOs and match them with the clues below. | sys.dm_ionk_isgttssaa_w sys.dm_uqe_ten_ceplxtyr_axe sys.dm_nnaoiar_strst_asessncinto sys.dm_tn_ecisooenccexn sys.dm_rsa_urinaecanntntttr_cor | sys.dm_akstc_ornl sys.dm_sys_oo_fnsi sys.dm_fitoai_ta_irll_setvsu sys.dm_rxee_seuqtsce sys.dm__efdacb_ass_iglueep |
most_recent_sql_handle What's doing something? Get the query plan for just one query within a batch. Reads per database file Number of CPUs What's waiting? My transaction Held locks Starting point to find out who has a given transaction open Size of data files on current DB I'll post the answers into the comments within a day or two of the puzzle posting. Kenneth Fisher from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | Have you got NoSQL fingers? No, thought not. Writing and tuning queries in JSON is a short-cut to repetitive strain injury. But with Studio 3T - the IDE for MongoDB - you can manage MongoDB directly with SQL queries. Join the accuracy of SQL to the speed of NoSQL. Get me my free 14-day trial. Get a free 14-day trial |
| | | | 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 |
|
|
|
| | | | | Bill Pearson from SQLServerCentral.com Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively. More » |
| | Press Release from Redgate Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? More » |
| | This quick tip shows how to connect to Azure SQL Database instances from SQL Compare, using its built-in Active Directory authentication mode, giving you an easier and more secure way to, for example, deploy schema changes from version control to an Azure SQL Database. More » |
| | Additional Articles from SimpleTalk How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth system based on the SQL specification of the Open Geospatial Consortium (OGC). However, this is not the only approach, as Joe Celko explains. More » |
| | Grant Fritchey from SQLServerCentral Blogs I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly. Unfortunately though, I think a lot... More » |
|
|
| | | Today's Question (by Steve Jones): I want to merge two data frames. Here I have created them and gotten their values: > countrygdp countries gdp 1 USA 18,569,100,000,000 2 China 11,232,108,000,000 3 India 2,263,792,000,000 4 UK 2,629,188,000,000 > CountryPopulation countries Pop 1 USA 324,459,463 2 China 1,409,517,397 3 India 1,339,180,127 4 UK 66,181,585 Now I want to combine these together into a dataframe that has 3 columns, one with Country, one with population and one with GDP. How can I do 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 | | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I've got this table: CREATE TABLE Team ( PlayerID int , PlayerName VARCHAR(10) ) GO INSERT Team VALUES (1, 'Kendall'), (2, 'Maddie'), (3, 'Andrea') What does this query return? SELECT COUNT(PlayerID) FROM dbo.Team HAVING COUNT(PlayerID) > 3
Answer: An empty result set Explanation: An empty result set is used. If the HAVING clause is used without a GROUP BY, it behaves as a WHERE clause. Ref: HAVING - 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. Implications of slower writes with 64K pages using SSDs vs SAN - As part of our migration to SQL Server 2017, we are considering a move to local SSDs. Some testing with... Current Quarter - Hi Guys, I am using the below which does the following. Show the data for the current month unless today's date... SSIS Database with lots of space - Dear all, I have a SSIS DB in my SQL Server. This database currently uses more than 10 GB of data... 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... Disable Automatic update SSRS versioning issue - Hello, i´m new woriking with SQL reporting services, This is the issue: Every time i restore the report server database works fine... 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... SQL instance is not starting automatically after reboot. - What is the best way to manage SQL Server rebooting after monthly security patching that is in a 3 node... 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... stored proc fails randomly... - I have a agent task that calls a SSIS routine and in that routine is a stored proc call.. Sometime... MSSQL Schema Export Only - Is there an easy way to do schema only exports in mssql 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... decimal places correction - Hi All, I want my numbers to be converted from a column which is of nvarchar(100) datatype to decimal(18,2). How can I... 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... SSIS Foreach File Enumerator Date Order - I'd like to ensure that my SSIS (2012) Foreach File Enumerator processes the files in order of creation date. Ideas? ETL from MySql - Hi, I am writing ETL routine (stored proc based) to fetch data from mysql and insert in mssql database. I am... Strange Month number value in table of Dates - I've been tasked with writing a script to populate a Dates table. This contains a row for every date in... Query taking more time - I have a Master table.This table contains two fields Listings(Master Table)-------- TableID EntityID 30047 100 30047 101 30047 102 In above table TableID (30047) contains 15... Subquery vs join - Hi All, We have a new junior developer who insists on looking up descriptions using Subqueries rather than joins.. Simple Example below... JOIN SELECT... How to create a dynamic project file connection - Hi, I am creating a SSIS project that will consist of a parent package with a number of child packages. The... 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] |
|
|
