|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Counting the Groups in R | |
I have this dataframe in R:
> head(sales) Date Day Month Year Customer_Age Age_Group Customer_Gender 1 2013-11-26 26 November 2013 19 Youth (<25) M 2 2015-11-26 26 November 2015 19 Youth (<25) M 3 2014-03-23 23 March 2014 49 Adults (35-64) M 4 2016-03-23 23 March 2016 49 Adults (35-64) M 5 2014-05-15 15 May 2014 47 Adults (35-64) F 6 2016-05-15 15 May 2016 47 Adults (35-64) FI want to get a count of the distribution of rows by Age_Group. What function should I call? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Tempdb Default Size I've installed SQL Server 2017 with all the defaults (clicking next, next, next where I can). I took the recommendations for tempdb. This gave me 8 data files. If I fill up a single file, what is the amount of growth that will take place? Answer: 64MB Explanation: The default auto growth for each file is 64MB. Ref: tempdb database - https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-ver15 |
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 - Administration |
Very odd behavior with parameter sniffing, overall poor performance post CU19 - Hey all, Seeing something very strange. Overall performance on a SQL 2017 instance has dramatically worsen since CU19 was installed. Have historical records on nightly processing that shows that post CU19, report execution times went through the roof. One in specific, used to run consecutively in 1 minute. After CU19, it jumped up to 10 […] |
Replication - I am thinking to configure Always on or replication from two databases to 1 single database for reporting and consolidating the dbs . Current prod is on sql 2016 and planning to configure the reporting server with SQL 2017 and configure Always on between SQL 2016 primary and SQL 2017 secondary. My understanding is lower […] |
Connection time out SQL 2017 - Hi Team, I am getting this message while I try to connect to a new SQL Sever 2017 server : Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration […] |
SQL Server 2016 - Administration |
Keep track of who accessed\modified the database except application user\login - Hi, SQL version: sqlserver2016 standard . I am looking to keep track of the details for audit purpose who access to database, from which machine , and data modifications. event_time Client Machine Name\IP UserName\Loginname server_instance_name database_name schema_name object_name SQL statement Any help here ? Thanks. |
AD group access - persists after removed? - I have a strange problem regarding an Active Directory group that has access to a database. We have a AD group called APP_OP that was created a long time ago to give users access to specific databases used by an in-house application. So basically we created the group as a login on the server and […] |
What Are Your Thoughts on Sections 302, 401, and 409 regarding Data Integrity - DELETED. |
SQL Server Native client - Hi, Installed SQL Server2016 standard on Windows server2016 Standard, Later i observed that SQL Server2012 Native Clients also installed along with that. Is it safe to uninstall ? do i need to keep as it is ? Thanks. |
SQL Server 2016 - Development and T-SQL |
Import documents Saved in AccessDB into SQL server - I wonder if anyone has tried to do this Having been asked to examine the ability to upscale a database from the AccessDB one of our teams had developed I started looking at the information in it In one of the columns they have stored "Supporting Documentation" such as word documents and emails with a […] |
SQL Server 2019 - Administration |
Cannot create cloud witness for Windows cluster on Azure - All Windows firewalls are actually turned off. The Windows Cluster is the 1st step for my SQL AG setup but can't make it work. Any suggestions? Where else can I check? |
SQL Server 2019 - Development |
MacOs User connection to SQL Server from Excel - We have a financial reporting tool , which gets data from SQL server via stored procedure and works fine on Windows computers. (Please forgive me if I am using the wrong terms in the next few lines, I am neither IT nor native speaker): If they work on a Windows netbook, they logon on their […] |
Reporting Services |
Performance Dashboard and Server Dashboard - Hello All, I am wondering if anyone has been able to successfully recreate or find the RDL file for the Server Dashboard? I have been able to publish the Performance Reports Dashboard but upper management wants to only see what the server dashboard has to offer. This is a add-on that Microsoft allows you […] |
Date parameter input in UK format but at run-time changes to US format - Hi all I'm sure I've found a solution to this problem before but it may just have been updating the Language on the report to en-GB, which I've done on this report. I have a fetchxml report (yes I know...) where processingdate <= @ProcessingDate. The parameter input is in UK format but whilst running it's […] |
SQLServerCentral.com Website Issues |
User Forum is Terrible - Today is not the first time I've had problems with the SQL Server Central forums since they were changed (not sure how long its been). The new/current view is like a dumbed down view of a more complex user forum. There also is no FAQ or HOW-TO for the forum at least not that i […] |
COVID-19 Pandemic |
Daily Coping 6 May 2020 - Today’s tip is take a step towards one of your life goals, however small. My thoughts: http://voiceofthedba.com/2020/05/06/daily-coping-6-may-2020/ |
Sarbanes-Oxley |
What Are Your Thoughts on Sections 302, 401, and 409 regarding Data Integrity - MOVED TO SQL 2016 Administration section |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |