|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Flipping the plot | |
I load the Motor Trend cars dataset in R Studio and then plot some data.
> data(mtcars) > stripplot(cyl~mpg, mtcars)I get a plot like this: I want to switch the data to this plot: Which code will give me this? | |
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) |
Starting with Full Text Search How do I enable Full Text Search in a SQL Server 2019 database? Answer: You don't enable FTS in a database Explanation: All SQL Server databases are full text enabled by default. Ref: Get Started with Full Text Search - https://docs.microsoft.com/en-us/sql/relational-databases/search/get-started-with-full-text-search?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 |
Removing a SQL node from a cluster - First and foremost - I AM NOT A SYSTEMS ADMIN I'm a DBA. My windows admin and I built a sql cluster to do availability groups. It was both of our 1st time building for AG. It was a total success. Then we pointed our 3rd party software at it and it couldn't deal with […] |
SQL Server 2017 - Development |
How to show the MIN Date Value in a query - After reading many posts, this is what I learned. SELECT MIN(StartDate) AS MinDate FROM Schedule WHERE WorkCenterID = 'LAY-W' AND ScheduleID = '5' GROUP BY StartDate It produces all three values. I just want the Minimum Date Value to be returned. Thanks! |
SQL Server 2016 - Development and T-SQL |
Excessive run time - Hi I have a number of queries that select data and put the data into a table. Data flow from one database and is loaded into another table in another database using a SSIS data flow task. I've noticed that on a good day, it works through them all fairly quickly (around 30-40 mins) […] |
Development - SQL Server 2014 |
Using an Integer parameter in a WHERE clause - I have a simple query which has one parameter (@Amount); if I use it like the pasted code below, it works just fine: DECLARE @Amount int, @Client varchar(500) SET @Amount = '1170' SET @Client = 'Google' Select * from Invoices where Client like '%' + @Client + '%' and InvoiceAmount = @Amount But what if […] |
SQL 2012 - General |
Rows to Column - Hai all I have one table one column. I have 10 rows that table . I want output, segregate one column to three column rows accordingly Create table #test(Name varchar(20)) insert into #test values('one') insert into #test values('two') insert into #test values('three') insert into #test values('four') insert into #test values('five') insert into #test values('six') […] |
SQL Server 2019 - Administration |
Move mdf and ldf on separate disks - Hello Forum, Inside my database server I have 3 harddisks. Sadly there is no more free space to mount additional disks. So I set up: * Disk 1: OS, SQL-Server executables incl. master, model, msdb and tempdb * Disk 2: mdf for User DB * Disk 3: ldf for User DB For testing I installed […] |
How to integrate TFS into SSMS? - Hi all, In our old version of SQL Server and its SSMS we used to have Team Foundation Server integrated into SSMS. The setup was done through Tools/Options/Source Control/Plug-in Selection. But now we are migrating to SQL Server 2019 and new SSMS is missing this option. Or I am missing something? Thanks |
Switching from Server/CAL to Core license. Do we need the core install? - We are changing our licensing model and with 2019 there are different installs for Core or Server/Cal I asked the MS rep if this is simply a key change or does it require a new install. I couldn't get a concrete answer out of him. Seems like as long as we pay for the core […] |
Error when attempting to do initial backup for log shipping - We have several databases that we log ship from our primary production SQL instance to a reporting instance. We've been doing this for years now and it's been working almost flawlessly most of the time. However, we've come across an issue. Over the weekend, we had a power outage in our DEV environment. The host […] |
SQL Server 2019 - Development |
Clustered vs Nonclustered Columnstore Update Performance - Hi Everyone, I'm experiencing horrendous update performance with Clustered Columnstore Indexes (CCI). Whilst our current Nonclustered Columnstore Index (NCCI) setup is not going to win any update-performance awards, it works sufficiently well. In my test setup, I can update 1 mil rows in about 90 seconds using NCCIs. Inserting 1 mil rows (both for CCI […] |
Incremental/Delta Import into SQL - Hi Community, I need a solution for a problem. I have excel files which needs to be imported into a SQL Database. I tried the below method using SSMS. When SSMS is connected to the chosen instance of SQL Server, right-click on the desired database and navigate to Tasks > Import data option from the Tasks submenu: The problem is the […] |
Import data from PostgreSQL to MS SQL Server - I am trying to import data from the PostgreSQL into the MS SQL Server database, using SQL Server Import and Export Wizard. During the column mapping I get the following error: The column attribute "COLUMN_SIZE" is not valid. The column attribute "DECIMAL_DIGITS" is not valid. The column attribute "COLUMN_SIZE" is not valid. I modified the […] |
Comparing two sets of value sets - I have two columns that I need to check for a given set of values: SELECT * FROM test t WHERE t.col_a IN ('a','b','d','g','t','s') OR t.col_b IN ('a','b','d','g','t','s') What I'm wondering is if there is a shorthand method to determine if either col_a or col_b have a value in the set without repeating the set […] |
SSRS 2016 |
SSRS MS Report Builder: How to repeat all item labels - I am working on creating a report like below where I would like there to be no empty spaces in rows - so a employee number should show on every row - even if it is repeating the same information. Here is my design view, I have not grouped the report by anything but still […] |
Integration Services |
SSIS not calling powershell script - I have an SSIS package that I've had to alter to call a powershell script to do SFTP. We have other SSIS packages that do the exact same thing and they work fine. But for some reason, when trying to run this package in the VS 2010 shell on the Windows 2012 R2 server, it […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |