SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

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
  1. most_recent_sql_handle
  2. What's doing something?
  3. Get the query plan for just one query within a batch.
  4. Reads per database file
  5. Number of CPUs
  6. What's waiting?
  7. My transaction
  8. Held locks
  9. Starting point to find out who has a given transaction open
  10. 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.com

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

ADVERTISEMENT
3T

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

SQL Prompt

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

Featured Contents

 

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

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 »


 

Free eBook: SQL Server Execution Plans, Second Edition

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 »


 

How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory

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 »


 

Simple SQL: Handling Location Datatypes

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 »


 

From the SQLServerCentral Blogs - Get That Profiler Feel in Extended Events

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 »

Question of the Day

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.

SQL Server 2017 : SQL Server 2017 - Administration

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...


SQL Server 2017 : SQL Server 2017 - Development

Current Quarter - Hi Guys, I am using the below which does the following.  Show the data for the current month  unless today's date...


SQL Server 2016 : SQL Server 2016 - Administration

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...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

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...


SQL Server 2014 : Administration - SQL Server 2014

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...


SQL Server 2014 : Development - SQL Server 2014

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...


SQL Server 2012 : SQL 2012 - General

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?


SQL Server 2012 : SQL Server 2012 - T-SQL

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...


SQL Server 2008 : SQL Server 2008 - General

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...


Data Warehousing : Integration Services

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...


Database Design : Design Ideas and Questions

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 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