|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Altering a Filegroup | |
I have a very large SQL Server 2017 database and I am very busy. I start a backup of my 1TB database that I know will take at least 15 minutes to run. While this is running, I want to perform some maintenance and add another file to my OLTP filegroup. What happens when I run the ALTER DATABASE command to add a new file? | |
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) |
A Pandas Series I have this list in Python: >>> a ['Ford', 'Chevrolet', 'BMW', 'Audi', 'GMC', 'Porsche', 'Toyota', 'Honda'] I have the Pandas package and I run this: >>>import Pandas as pd >>> pd.Series(a) Of these four choices, which one is output? 1: {0:'Ford', 1:'Chevrolet', 2:'BMW', 3:'Audi', 4:'GMC', 5:'Porsche', 6:'Toyota', 7:'Honda'} 2: {1:'Ford', 2:'Chevrolet', 3:'BMW', 4:'Audi', 5:'GMC', 6:'Porsche', 7:'Toyota', 8:'Honda'} 3: >>> pd.Series(a) 0 Ford 1 Chevrolet 2 BMW 3 Audi 4 GMC 5 Porsche 6 Toyota 7 Honda dtype: object 4: >>> pd.Series(a) 1 Ford 2 Chevrolet 3 BMW 4 Audi 5 GMC 6 Porsche 7 Toyota 8 Honda dtype: object Answer: 3 Explanation: A series is a one dimensional array with an index. Similar to a dataframe with one column. Ref: Pandas Series - https://www.tutorialspoint.com/python_pandas/python_pandas_series.htm |
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 |
which linux - I would like to try to install SQL server and PostgreSQl on a linux system. It is a test environment This is just for explore and learn linux and how to work with database. What linux system do you recommend, Redhat or ubuntu? Thanks |
SQL Server Training - Can anyone recommend the best place to get the SQL training when the company is willing to pay for it? |
Store Procedure... - Hi Is there anyone who can help me explaining, in real job field, in what kind of scenario I would need to use output parameters in my store procedures. And also I would like to know how data gets into tables, do we manually entered it or its gets inserted via back end file? Thank […] |
Is DBA responsible for ETL operations and cube creation in DW design project? - If a company wants to build a DW from sketch, is DBA responsible for schema design, ETL extraction and transformation process, loading physical data from different sources into a DW database? Or DBA is responsible only for physical design, and tools like SSIS or SSAS should be used by developers. Thanks |
SQL Server 2016 - Development and T-SQL |
Change data capture - is it possible Updates getting applied out of sequence - I am using the CDC objects in SSIS to do replication between two servers I have a large table that does not have a Primary key so must be set to all. Occasionally when I do validation between the two, the record count is correct but values don't add up. I am doing a simple […] |
Changing @ExecutionTime parameter value in SSRS subscription - Hi Everyone, Can you please guide me how to change @ExecutionTime parameter value in SSRS standard subscription and version is 2012? Thanks Kanagarajan S |
How to disable Upload options to end user in SQL SERVER REPORT Services 2016 v? - Hi Every one, Could you please help me to achieve this requirement? I am having a requirement like need to disable the upload RDL or IMAGE option to end user also, restrict to view hidden data sources list in reporting manager. Thanks Kanagarajan s. |
How to do Count of values on mutiple columns - I have the folllowing data in a table If OBJECT_ID(N'tempdb..#OutputTable', N'U') IS NOT NULL DROP TABLE #OutputTable CREATE TABLE [#OutputTable]( [MainHoldingID] [int] NULL, [OfferingElementID] [int] NULL ) ON [PRIMARY] GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT […] |
Administration - SQL Server 2014 |
error upgrade ssis - Hello everyone I proceed to update my ssis package from SQL server 2008R2 to 2016 during the upgrade wizard phase I got this message thank you for your help |
SQL Server 2012 - T-SQL |
In a t-sql 2012, I can trying to make a case statement work in an update statem - In a t-sql 2012, I can trying to make a case statement work in an update statement and I am getting the error ' Msg 207, Level 16, State 1, Line 5 Invalid column name 'TOT_ABSENCES'. from the following sql: UPDATE Milestone set TOT_ABSENCES = case when (details.TOT_ABSENCES is not null) or isnumeric(details.TOT_ABSENCES) = 0 […] |
SQL Server 2008 - General |
identify stored proc calls with missing input parameters - I'm checking to see if anyone has already written a stored procedure that can be run to identify any and all stored procedure calls from within a trigger or other stored procedure that are missing some of their input parameters. For example, if I have a procedure named SP_MyProc and three input parameters whenever I […] |
Free Webinar: SQL Server 2008 has gone out of extended support - Hi All I thought I would post, I'm not sure its the correct place, but thought I'd let you know that I'm putting on a free webinar on 31st July - midday UK time. With SQL Server 2008 and SQL Server 2008 R2 going out of extended support with Microsoft last week, the webinar will […] |
Error: Database is already open and can only have one user at a time - Any idea how to resolve this error? seemingly a nightly process loads data into my joebloggs_DB database, its then copied from jobbloggs_DB database to LIVE DB. Issue is sometimes the process fails with the following error: Error: Database 'JoeBloggs' is already open and can only have one user at a time. It looks like the […] |
Dynamic Pivot Query with three fields - Hi, I am creating a dynamic pivot query to produce a simple monthly table showing clients on the left column, calendar dates across the top and simple text in the middle. Table are CREATE TABLE [dbo].[TblClientActivity]( [ID] [int] IDENTITY(1,1) NOT NULL, [ClientID] [int] NULL, [LocationID] [int] NULL, [ADate] [date] NULL, [Outcome] [nvarchar](10) NULL) Data […] |
Integration Services |
Upgrade file SSIS - Hello everyone I have two dtx file SSIS develloper EN SSDT 2008 AND I'm going to migrate it in SQL2014 If I import these files through SSDT 2013 the files are well imported then if I click on the button upgrade all package i have this message At least one package has to be selected […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |