Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Delete data - Just to get some thoughts. I am looking to delete data from a large table in SQL Server database that is part of availability group with 4 additional secondary replica's in Async mode. Other than performing delete in batches what other care should be taken. I am running against test databases and noticed the deletes […] |
SQL Server 2017 - Development |
MySQL To TSQL - Please assist in transforming this mysql code to tsq please? SELECT date(o.created_datetime) as Date, od.product_uid as 'Product UID', p.manufacturer Manufacturer, p.bmc BMC, p.brand Brand, od.label as SKUs, p.selling_unit as 'Unit of Measure', ROUND(if(od.amended_quantity is not null, od.amended_quantity, od.quantity)) as 'Units Sold', ROUND((if(od.amended_quantity IS NOT NULL, od.amended_quantity, od.quantity))*p.content,2) as 'Sales Volume', ROUND((if(od.amended_quantity is not null, […] |
SQL Server 2016 - Administration |
Profiler Trace - Hi, I am aware of capturing the trace for a single user database by adding the DB name in the column filters. If I have to filter the trace only for 2 user databases, how can I add one more database name in the column filter which says LIKE 'TESTDB' ( example) ? or just […] |
Help with detecting and sending alerts for lengthy blocking - Over the weekend we had 2 ETL jobs that were causing unresolved blocking with each other. One reading data the other inserting and updating. The jobs had been running for 45 hours in the blocked state. This was only resolved after one of the processes was killed. I'm looking for some help with the best […] |
Sp_server_diagnostics for WorkerThread - Hi there, I am seeing excessively high number of worker threads when running Sp_server_diagnostics. My question is around the 3 figures: "queryProcessing maxWorkers="704" workersCreated="756" workersIdle="206""and how to interpret them. As you can see from the above we are certainly exceeding the maxWorkers but I'm trying to understand if workerIdle comes into play here. Does this […] |
Database going to Recovery, while accessible. - one of the 3rd Party DB's is going to recovery state. Whithout any reason I could find. The log shows one DBCC CHECKDB after another is running on that database. Strange, I can access and query the db in ssms. I did repair_rebuild and it is working again, but after some time the problem arises […] |
SSIS package cant open and find - Hello when I log in get this error: What is another way find and open ssis package? |
SQL Server 2016 - Development and T-SQL |
Buy oxycontin 80m,xanax,Oxycodone,Ritalin,Diazepam etc WhatsApp:+1(312) 379-9621 - We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain killers,anxiety meds,depression meds,sleeping/sex aid pills,Steroids such as Hgh,Injectable steroids and Orals with safe and quick delivery to any part of the world without any custom issues..We do worldwide shipping to any clear address. Customer satisfaction is our greatest concern Shipping is […] |
ExecutionLogStorage Returns No Records - SSRS - Hello, I am trying query the log for SSRS. I queried ExecutionLog3 table but did not get any records. Logging is enabled and retention period is 60 days. The ExecutionLog3 / ExecutionLogStorage is expected to have the data logged into it. What could be the reason for it to return 0 records? Can it be […] |
Development - SQL Server 2014 |
how checksum works? - Could you please me how checksum work in the SQL statement ? below is an example. SELECT * FROM Tablename1 WHERE CHECKSUM(*) NOT IN (SELECT CHECKSUM(*) FROM TableName2) 2. and there is page checksum and database backup checksum, and what does it do while page checksum and database backup checksum? thanks! |
SQL 2012 - General |
How to make group to data on pivot sql server ? - I work on SQL server 2012 i need to make group by to pivot data repeated inside pivot so i need to make group by TO FINAL RESULT PIVOT this is my sql script meaning i need to group by to data result from excute @sqldata so How to do that please DECLARE @result NVARCHAR(MAX) […] |
SQL Server 2019 - Administration |
upgrade path to SQL 2019 - I read the upgrade path for standard edition to SQL server 2019, the oldest version is SQL server 2012 SP4. If earlier than 2012 it may need a version of middle to upgrade first, then to 2019. If this is s side by side installation and upgrade, like to a new server with SQL sever […] |
SQL Server 2019 - Development |
Archiving data to a read only file - Hi there I have a table for which archiving functionality is required. Now I have thought of writing sonmething in t-sql to use BCP to write to csv or caret delimited file There is a requirement that this file be made tamper proof and read only. Apart from setting the file attribute to read only, […] |
Filtering a hierarchy-related query - I've got a table with LOTS of data. It's a tree-structure (using hierarcyId datatype) and I want a query to get all of them UNLESS they have a parent that's flagged as "Inactive" in the database, then I want to skip everything that's inactive and below. I hope you get it. If possible I want […] |
Issue connecting to sql server 2019 - Hi All have been having issues connecting to Sql 2019 server this morning. Please see message I'm getting below. Any help would be greatly appreciated |