|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Costs in Python | |
I have a dataframe in Python, using pandas. In this dataframe, I have a column called "Cost". I can see this with this code:
sales['Cost'].head()This returns a few values: >>> sales['Cost'].head() 0 360 1 360 2 1035 3 900 4 180 Name: Cost, dtype: int64What does this code do? sales['Cost'] *= 1.05 | |
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) |
The I in ACID What does the I in ACID stand for when related to relational databases? Answer: Isolated Explanation: The I stands for Isolation. Each transaction is isolated from others. Ref: ACID - https://en.wikipedia.org/wiki/ACID#:~:text=In%20computer%20science%2C%20ACID%20(atomicity,errors%2C%20power%20failures%2C%20etc. |
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 |
Table Partition in Sql Server - Hi Team, we have a table like 1.5 tb in size and around 800 cr records. I would like to make it as partitioned table. to make partition we need to drop and recreate primary and FK constraints will take more time. we need to perform this on more tables. so is there any approach […] |
SQL Server 2017 - Development |
How to performance tune ssis pkg when dev environment isnt as good as prod - Hey everyone, my dev envoronnebt has 56 GB of memory and 4 virtual processors with a speed of 2.29 GHz. My prod environment has 163 GB of memory and has 8 virtual processors at 2.29 GHz. I can update pkgs on my dev environment to run multiple data flows using Modulo and that pkg runs […] |
SQL Query Help - CHARINDEX - Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT INTO #tblTest1 values (1,'abc/efg','OS') INSERT INTO #tblTest1 values (2,'xyz/tgf','OS') INSERT INTO #tblTest1 values (2,'tgf/xxx','OS') INSERT INTO #tblTest1 values (3,'ccc/ppp','OS') INSERT INTO #tblTest1 values (4,'ddd/tqm','OS') INSERT INTO #tblTest1 values (5,'mpg/eee','OS') create table #tblTest2 (SName varchar(50)) INSERT INTO #tblTest2 values ('efg') INSERT INTO #tblTest2 […] |
SQL Server 2016 - Administration |
Best way to replicate 1 table from Production DB to Dev Db - I'm sure there are a dozen different ways that this can be accomplished and many things that will make some better that others. I have a VM win2012R2 SQL2016dev 'dev' and a box win2016 sql2016ent 'prod' Developers cannot have any access to prod, and have full access on dev. I would like to provide them […] |
SCOM alert offline/recovery pending/suspect... but DBs seems fine - Hello experts, We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert: Database is in offline/recovery pending/suspect/emergency state I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is […] |
SQL Server 2016 - Development and T-SQL |
Select Statement Where Column Does Not Exist - I bulk insert a file into a temp table each month. The file has about 60 fields but sometimes 2 or 3 fields are missing (if they are missing its the same all the time). I'd like to use the same procedure to read the temp table, whether it has 57, 58, 59 or 60 […] |
How to grant only read(Select) permissions to the Group of Users - I have a business requirement where Business Users are all available in Group "TradingBusinessUsers" , Now i want to grant select permissions to all tables for the users in the group "TradingBusinessUsers" and also users are allowed to create table on their own Self-schema and manage their tables. Can anyone help me to solve this […] |
Is it possible to display Date in between in cube without multiplying the Data? - Ahoi, I have to display "discount" as a measure in my Cube. The basic structure is: DateFrom DateUntill DiscountMeasure The request is: Have a Date and display the DiscountMeasure. My question is: Is there a better way to solve this than creating a dataset for each day between DateFrom and DateUntill? I was hoping […] |
SQL Server 2012 - T-SQL |
Need help formatting BCP output - Hello, I have a bcp script that generates stored procedure code output as shown below. bcp "select RTRIM(LTRIM(c.text)) FROM sys.objects AS o INNER JOIN sys.syscomments AS c ON o.object_id = c.id WHERE o.type = 'P' AND o.name = 'sp_ic9av0_dx_length'" queryout "\\dbserver1\j$\Backup\NG Sps\sp_ic9av0_dx_length.sql" -t -c -r "\t" -SServer1 -T -dMyDb There is a formatting issue in […] |
SQL Server 2019 - Administration |
Update - I have a Use case like. We migrated around 1000 millions of rows into around 5-6 tables. client requirement frequently change to update some columns. Is there any best way to Update those tables other then Batch/looping updates. We tried disabling all the index but still it's taking too much time. Even we have 5-8 […] |
Page File. Set Value, or let Windows Manage it ? - I friend at another company said they got an out of memory error on their Production SQL server. It has 24 Gig of RAM and a 4 Gig page file. Their hosting company said they can increase the page file to a set value, or let Windows manage it. If Windows manages it, is there […] |
SQL Server Hardware Recommendation - Hi, I'm looking for a recommended Hardware Spec to run SQL Server 2019 Enterprise on. Our software vendor has suggested the below, but was looking for other people's thoughts. Our Database is currently sitting on a SQL2000 database - it's around 300GB in size and is accessed by around 90 people at a time. […] |
SQL Server 2019 - Development |
Change color scheme for Admin account in SSMS - I was reading one of Brent Ozar's posts about SSMS, and he was talking about "never use the sa/admin account unless you need to", so I was wondering if there is a way (I know there is) to change the background color or the color of the window for just the SA/admin account, so I […] |
DateDiff for only @p_start_date and @p_enddate - So I am trying to get the datediff for parameters selected, even though the 2 dates could span 60 days, for an example I have 2 dates available(2018-01-05 11:08:00) and unavailable (2017-10-30 05:05:00) I only want the datediff where @p_start_date = 2017-12-01 and @p_end_date = 2017-12-31 those are the selected parameters. |
Integration Services |
Access Files Stored in Box.com - Has anyone created an SSIS package which grabs data from one or more files stored on Box.com? I would be interested in hearing how you got on. Did you get the Box API working from a script task? Any issues adding DLLs to the GAC? |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |