|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The TUF File | |
What is a .tuf file in SQL Server? | |
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) |
Large Database Files What is the largest a single database file can grow to in SQL Server 2019? Answer: 16TB Explanation: A data file has a maximum size of 16TB. Ref:
|
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 |
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 […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |