|
|
|
|
|
|
|
Question of the Day |
Today's question (by Evgeny Garaev): | |
Database snapshots | |
Can you detach and re-attach a database snapshot on SQL Server 2019? | |
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) |
Parquet What is the Parquet format for data files? Answer: A columnar oriented file format Explanation: Parquet is an OSS format from the Apache foundation that is used in Hadoop. This is a columnar oriented format that allows better performance across certain types of queries. 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 - Development |
Replication - not all columns are updating - I've set up replication but I'm having difficulties in my testing. I've changed 3 fields in the publication database, but only 1 of those 3 fields updates in the subscriber database. I've verified that all 3 fields are in the article. I've looked at the replication sproc and it looks fine for _UPD and _INS […] |
SQL Server 2016 - Administration |
using sftp in SSIS - Hi, I have SSIS packages for my SQL 2016 that currently use the FTP Connection manager. I need to switch these to use sftp instead of ftp and I'm seeing lots of articles stating that SSIS does not support this and most are using WinSCP or scripting to get around this issue. I'm wondering if […] |
Backup failed - I cant figure out why backup failed Here is my error: Executed as user: NBHDHQDOMAIN\svcempsqlserver. ...0 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 12:40:50 PM Progress: 2021-04-20 12:40:54.16 Source: {DCE40FB3-F026-44F4-8B33-183461DFFA93} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2021-04-20 12:40:57.51 Source: Maintenance Cleanup Task Executing query "EXECUTE […] |
automatically remove people from report subscriptions - Hi, How can we automatically remove people from report subscriptions when they are disabled or don’t exist in AD? We have Reporting Services standard and data driven reports and we are trying to find a way to automatically remove users when they don't exist in AD anymore. I have read up on the [sys].[sp_validatelogins] stored […] |
Azure SQL Server Specs and Encryption - Hello~ I administer a database application (Azure SQL Server Back End/MS Access Front End) At the moment, we have only one server, and we recently encrypted a few sensitive fields in our db. After a week of user testing with encryption, everything seemed fine, but of course, when we went live, things went terribly wrong […] |
Login - Multiple AD groups - Hi All If a user belongs to 2 AD groups, both of which are logins in SQL Server. What determines which group the user is coming through when connecting to SQL. I'm trying to troubleshoot a possible permissions issue in SQL. User1 is part of ADGroup1 & ADGroup2. ADGroup1 & ADGroup2 are logins in SQL. […] |
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 […] |
SQL Server 2019 - Administration |
Polybase and External table - Hi - we have 2 SQL Server 2019 instances, both with Polybase installed. I created an external table in a database on instance A and pointed it to a table in a database on instance B. Steps take in database on instance A: create master key in user database create credential create datasource using that […] |
Where To Set Up SQL Server - Background: We have MS Access database split with backend tables that we want to convert to SQL Server and still use MS Access front end. We currently only have OneDrive and I know we can’t put SQL on OneDrive. We do not have a network set up. So we are looking for the best way […] |
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 […] |
General |
How to get the sum of hrs. logged for today, past 1 week, this month, & quarter. - Dear SQLServerCentral members, Hello, and good day. Hope all is well. May I asked for the help of any one regarding this matter. Here is the sample table I have with the client (Please see the attached file). Since there is only one table that has a datetime field (in SystemAppUse table) and whether it […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |