|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Changing Database Names | |
In SQL Server 2017, how do we programmatically change the name of a database? I want to change database YYY to XXX in a way that will be supported in the future. | |
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) |
Properly loading the data frame I've got a CSV file that looks like this: "ProcName","cputime","reads" "GetCustomers","27784","312165" "GetCustomerList","43170","627272" "CalculateMonthlyTotals","48868","2705414" "CalculateMonthlyTotals","25868","2922859" I want to import this in RStudio, and run this: procs <- read.csv2("C:\\Users\\Steve\\Documents\\SQL Server Management Studio\\procexecutions.csv", header=TRUE) I then see this: > head(procs) ProcName.cputime.reads 1 GetCustomers,27784,312165 2 GetCustomerList,43170,627272 3 CalculateMonthlyTotals,48868,2705414 4 CalculateMonthlyTotals,25868,2922859 5 CalculateMonthlyTotals,38206,862347 6 GetCustomers,49426,3449650 Why do I see all the data in one column? Answer: read.csv2 defaults to a semicolon as the delimeter Explanation: The defaults for read.csv2 are different than read.csv. The function for read.csv2 is designed for non English locales where the comma is used as the decimal separator and the semicolon is used as a column separator. Ref: read.table() - https://stat.ethz.ch/R-manual/R-devel/library/utils/html/read.table.html |
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 |
SSIS Scale out deployment in a high availability cluster - Good day all, Just wondering if it will be possible to have a scale-out master and scale-out worker on primary and secondary in a high availability setup, were in the case of a failover the master on the secondary server would be able to utilize the worker on the primary server and the secondary server, […] |
SQL Server 2017 - Development |
Merge/Split/Switch partition's affect on indexes? - Hi All, Currently I have a partitioned table that is partitioned by date. On this table, I have 3 indexes that are not partitioned, each in their own filegroup. I'm now wanting to archive earlier portions of this partitioned data into another table of similar structure; when executing a Merge/Split or a Switch style archive […] |
SQL Server 2016 - Administration |
Buffer Pool calculation - Hello Colleagues. Could you tell me about how MS SQL Server 2016 SE determines memory size for Buffer Pool? May be there are a formula ? Thanks in advance. |
BPSORT + CXCONSUMER Waits - DEV vs QA server - I've got a process which does a lot of ETL type queries which runs fine on our DEV server but not on QA. SQL 2016 developer edition (prod is on Standard, haven't tested there yet) DEV = 4CPU, 16GB sql instance, maxdop = 2 QA = 8CPU, 32GB sql instance, maxdop = 4 On DEV, […] |
SQL Server 2016 - Development and T-SQL |
insert and update - Hi, need some advice. I have more than 20 columns and more than 50k rows. I would like to do insert and update. I did the merge in SQL from this example: http://www.sqlservertutorial.net/sql-server-basics/sql-server-merge/ I am having issue where it takes too long. More than 20 minutes. Is it because of the total rows? Any other […] |
Determining the length of a data type - On this website in at the beginning of the 3rd paragraph, we have: "Length for a numeric data type is the number of bytes that are used to store the number." When I run this code, the answer is 2. DECLARE @n int SELECT @n = 25 SELECT LEN(@n) The int data type has 4 […] |
Administration - SQL Server 2014 |
Reporting Server - I have reporting server which gets replicated from other OLTP server.However, the reporting server has low PLE and hig disk queue which make sense having low PLE could lead to high disk queue length and this trigger alerts. However, adding more memory on reporting server would help but it's reporting server so it would take […] |
FlushCache Error Message - While analyzing an issue, I stumbled on to a "FlushCache" error message (error log). There were many (both AM + PM). And this had been going on for quite a while. Had not seen this message before. First instinct was to check other production SQL Servers (VMs) to see if this was happening else where. […] |
StartDate & End Date parameters - Hi, I've created a view to populate data from existing tables In my report project I built using SSDT 2014, I created Dataset to read form this view. I also set a Startdate and Endate parameter with default calander values. The expectation is for the dates to filter the dates by above parameters. The Report […] |
SQL Server 2012 - T-SQL |
Need help with query where i need to aggregate an aggregate - Hi all, I have an inherited system which I can't do much with so (for now) i'm stuck with what i've got. Data is collected and inserted into a "storage" table at various times throughout the month which shows customers and how much storage they are consuming. I need to report on the TOTAL maximum […] |
SQL Server 2008 - General |
How to map the table data while inserting into another table in sql - table1 id value 2 20 3 30 4 40 5 50 6 60 7 null the above table has to be inserted into another table2 with following fashion i,e: it has to insert the value corresponding to 2 into col1 when id =2 ,col2 when id=3 and so […] |
How to map the table data while inserting into another table in sql - table1 id value 2 20 3 30 4 40 5 50 6 60 7 null the above table has to be inserted into another table2 with following fashion i,e: it has to insert the value corresponding to 2 into col1 when id =2 ,col2 when id=3 and so on. […] |
How to map the table data while inserting into another table in sql - table1 id value 2 20 3 30 4 40 5 50 6 60 7 null the above table has to be inserted into another table2 with following fashion i,e: it has to insert the value corresponding to 2 into col1 when id =2 ,col2 when id=3 and so on. […] |
Powershell |
run stored procedure from PS script - anyone have a script that will run a PS script to run a SQL SP and catch if it fails along with capture messages from the SP? Thanks |
Integration Services |
Import data from Word Custom Controls - I'm just wondering how hard this would be in SSIS... I got it to work in Access using Word automation/VBA (dirty word, I know!) I can loop through the Word file's ContentControls collection and map the names to fields in my table. Has anybody done this in SSIS? The lack of branching in Access is […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |