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 […] |
