Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| SQL Server Collations - So can anybody tell me if they have experienced issues when running a SQL instance level collation at Latin1_General_CI_AS when any of their databases on that instance run under SQL_Latin1_General_CP1_CI_AS. Am I correct in saying the SQL_Latin1_General_CP1_CI_AS is the 'old style' collation? The reason I ask is that we have been installing a new environment […] |
| Event Notifications - Can these be set up to monitor for changes to table data? - Hello, I'm new to using Event Notifications, but it is my understanding that they can be helpful for monitoring a variety of different events. Can these also be used to help audit changes to table data? For example, if someone were to add a new record to a table, or update an existing one? |
| IndicatorsPool events causing memory pressure? - Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of memory. I think we appear to be experiencing some memory pressure as we seem to have plans dropping from the cache and I can see various clock-hands running (including CACHESTORE_OBJCP – EXTERNAL and CACHESTORE_SQLCP – EXTERNAL). When I check the Memory […] |
| SQL Server 2017 - Development |
| running openquery with local database and server credentials - Hi guys, I have an application that can only call views: The data it needs to access is from a stored procedure that uses temp tables so the only way to call the data is by using OPENQUERY CREATE VIEW [dbo].[myView] AS SELECT * FROM OPENQUERY(LocalServerName, 'EXEC LocalDatabaseName.dbo.mySproc') GO in OPENQUERY the Servername and Databasename […] |
| SQL Server 2016 - Administration |
| error while running Replication - Has anyone faced this error Agent message code 20037. The process could not bulk copy into table '"dbo" Source: Microsoft SQL Server Native Client 11.0 Number: Message: The system cannot find the file specified. |
| Development - SQL Server 2014 |
| date Different - I have table with : if today is 25/11/2020, then i need to retrive ID 5 because nearst date to today WeekDate is: 1/12/2020 then when today date is: 10/12/2020 script must retrieve ID 6 i tried the below but it is not working, please need help DATEDIFF(d, WeekDate, CONVERT(datetime, @CurrentDate, 103)) >= 0 |
| SQL Server 2012 - T-SQL |
| Points of consedering during "Transaction Processing" - Hello Everyone, Here I need suggestions while I am trying to do some transaction in sql. I am using "Microsoft SQL Azure (RTM) - 12.0.2000.8 Oct 1 2020 18:48:35". I am getting data from On-premises data-sources using Azure Logic App (recurrence). The logic app insert the data in my some of tables lets suppose tableHR, […] |
| SQL Server 2019 - Administration |
| Query SSISDB For Components - Evening All, I want to identify all SSIS packages deployed into SSISDB that contain a specific component. We have over 5000 pacakges deployed (and closer to 100,000 accross other servers) and I am looking to identify some packages that contain certain components -- one being the FTP task, and another some of the Azure Tasks. […] |
| Sql Server Specs Question - Hi, I have two different servers that I do a bulk insert on the exact same text file. One will take 3 hours to do a bulk insert on the file and the other one will take about 45 minutes. Is it due to the specs on the server itself or is there something I […] |
| SQL Server 2019 - Development |
| Primary Key/Foreign Key Same Field in 1:1 Relationship? - Hello~ DB Design question -- say I have a primary table, tCompanies, where the primary key is CompanyID. And I have another table, say tCompanyMetrics, where every field in that table has a one to one relationship with CompanyID. In tCompanyMetrics, do I need both a primary key field and a foreign key field? Cannot […] |
| Run Azure Automation Runbook Against DB Hosted on an Azure VM - Hi - has anyone created a PowerShell runbook which connects to a database hosted on an Azure VM? This is a new environment, so we allow internal traffic to flow freely, so i dont think it is a firewall issue. If i add the port number to the server name i receive an error 0. […] |
| Azure Data Factory |
| Setting variable in Pipeline - Hi all, I’m wondering if someone can help us out here as we are going round in circles. In short we are trying to; 1. Read a value from a SQL table via a stored procedure in a lookup task. 2. We want to use that value to set a variable so we can use […] |
| Reporting Services |
| Variable Based on Variable in Paginated Report w/ Native Oracle Connection - I have an SSRS paginated report where users need the ability to pick and choose which variables they want the report run with. For example, the query looks something like: SELECT * FROM CUSTOMER WHERE 1=1 AND CUSTOMER_NUMBER = ? AND CUSTOMER_STATE = ? The users need the ability to plug in a CUSTOMER_NUMBER parameter […] |
| Powershell |
| when use dbachecks, it has error: unable to find type [Pester.outputtypes] - hi there: When I type invoke-dbcCheck, it pops up error below: Unable to find type [Pester.otuputTypes] any help? cheers Hui |
| Job Postings |
| Operations Engineer with strong SQL skills based in Reno, remote (US) or Toronto - We are looking for an Operations Engineer with strong SQL skills, based in Reno, remote (US) or Toronto. This is an Operations-focused role at a SaaS company. We see this role sitting between Level 3 Support and development teams. More details here: https://careers.karbonhq.com/operations-engineer Must have: solid SQL Server skills with prior experience working on live […] |
