|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Managed Instance Backups | |
What type of backups can be made on an Azure SQL Database Managed Instance? | |
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) |
Log File Architecture Pages and Extents are used to store data in data files, with rows being stored on the pages. For a log file, how many log records in SQL Server fit on a page? Answer: The log file doesn't use pages. Explanation: The log file doesn't use pages. Log information is just stored in log records. These are strung together in the log file. 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 2016 - Administration |
Communication link failure but only once per week - Hello experts, I'm helping to troubleshoot an issue where the following error happens on an AOAG cluster, which disconnects applications from the database: SQL State: [08S01] SQL Error: [[Microsoft][ODBC Driver 13 for SQL Server]Communication link failure] I have seen various posts while Googling this error. The thing is, as far as the customer can tell […] |
SQL 2012 - General |
Noob SQLServer 2012 Question - Let me preface this with I am a sysadmin working on an SCOM 2016 install and have a question regarding an error message that keeps getting thrown via application event logs. An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\ACCESSACCOUNT', […] |
SQL Server 2012 - T-SQL |
Show only once repeated value in result a set - Hello Everyone, Here again I came with a question. Below is my query for a report that I want. It's working fine with no issues. SELECT TP.Location, TE.Name, TEI.imp_amount_approved_by_finance AS Amount, CONVERT(DATE, TEI.imp_fin_appr_date, 103) AS PaidDate FROM tbl_emp_imprest TEI JOIN tbl_Projects TP ON TP.Sno = TEI.imp_emp_location JOIN tbl_Employee TE ON TE.Sno = TEI.imp_id WHERE imp_amount_approved_by_finance […] |
SQL Server 2019 - Administration |
Need to extract all queries used across all packages - A developer is asking me to provide a list of all the "queries" (aka sqlcommand) as it is in the tables there. He is asking for ALL of the queries from ALL of the packages... Is there an extract I can run against the SSISDB to render this list of queries? (the developer was pulling […] |
SQL Server 2019 - Development |
Beginner Query SQL - I have a 120gig database. I want to analyse it with Power BI. (It's way to Large) This is data from a machine at a sampling rate of 0.5 sec. To do my analysis, 1 min to 15 min sampling rate would be ok. How can I make a query to do this? Or what’s […] |
How to handle rolling back changes if there is an error? - Hi everyone I have two stored procedures that update two tables. If one of the updates fails then I don't want either of the two stored procedures to run. If one was run then it needs to be rolled back. What is the best way to accomplish this? Should I handle that in the stored […] |
Print Statements - Hi I am creating SSIS pacakges to automate data collection. I want to print out statements to the console. I tried below but they are not working. Nothing shows up in the output window in Visual Studio 2019. How exactly do I get them to work? System.Diagnostics.Debug.WriteLine("debug"); Console.WriteLine("console"); Thank you |
extract columns from a string column - I would like to extract a street address to separate columns. For example, I have street fake data only these two patterns, I want to separate them to different columns. all the street name has one word house number, one word streetname, one word street type, and some of them has an apartment number, that […] |
Compare 2 rows in the same table and output result when conditions are met - I am newbie to SQL, tried searching for answers for similar question but couldn't find any. Sorry, if this type of question was asked before. I have a temp table as below: Drop TABLE if EXISTS #temp Create table #temp(ID int, Country VARCHAR(40), ItemCount int, DeliveryDate Date, Itemtype VARCHAR(40) ) insert #temp(id,Country,itemCount,DeliveryDate,Itemtype) Select 3012111,'Dublin', 100, […] |
Compare 2 rows in the same table and output result when conditions are met - I am newbie to SQL, tried searching for answers for similar question but couldn't find any. Sorry, if this type of question was asked before. I have a temp table as below: Drop TABLE if EXISTS #temp Create table #temp(ID int, Country VARCHAR(40), ItemCount int, DeliveryDate Date, Itemtype VARCHAR(40) ) insert #temp(id,Country,itemCount,DeliveryDate,Itemtype) Select 3012111,'Dublin', 100, […] |
Bulk Insert C# Code Error - I figured out the issue. Please ignore post. |
T-SQL (SS2K8) |
running OPENROWSET from sql function with parameter - Following function works if the parameter to harcoded as shown below. But i would like to replace the value with parameter. PO12345 - should be replaced by @IpRef. I am not able to figure out how to do that. --select * from dbo.ki_GetSupplyUsage ('PO12345') alter FUNCTION ki_GetSupplyUsage(@IpRef VARCHAR(100)) RETURNS TABLE AS return SELECT * FROM […] |
General Cloud Computing Questions |
What's your opinion about Google Cloud SQL? - Hii I wonder what your opinion about Google Cloud SQL is! We are a small company running our MySQL server on one of our vServer and everything runs fine. But we have a few concerns about our project in the future: Backups - we did not implement them yet and I don't want to keep […] |
General |
Python Pattern best practice - Ahoi, anyone can tell me if there is a pattern/best practice to handle this type of request handling? I am trying to handle the execution of functions by name. I found a pattern for classes using a dicitionary but i couldnt make it work like this. https://github.com/faif/python-patterns/blob/master/patterns/creational/factory.py What i have i have made work is […] |
Integration Services |
Issue with Execute SQL Task in Sequence container returning 0 results - I'm working on a package to update some local tables from a datalake we access. I've been able to write individual incremental update packages for each table. The general flow of the package is "Get Now" (UTC) - Get Max Modified Utc from local table, get list of changed ids from source table where modified […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |