mv ٠〳comment ٠〳answer
  • Member for 3 years
  • Last seen more than a month ago
3 answers
6 votes
821 views
Keeping data in old Database (SQL 2008) identical to new Database (SQL 2016)?
7 votes

Converted from comments: According to Replication Backward Compatibility, Transactional Replication will not work between a 2016 Publisher and a 2008 Subscriber, but Merge Replication would be ...

View answer
3 answers
4 votes
867 views
SQL Server: Multiple Availability Groups, one cluster, how do I keep the primary cluster node as primary?
6 votes

Converted from comments: Are you referring to the core cluster resources? If yes, the answer is no, failover of the cluster role for the availability group would not impact the core cluster ...

View answer
1 answers
2 votes
73 views
OBJECT_ID(...) function vs join on sys.tables and sys.schemas
Accepted answer
4 votes

Converted from comments: The only thing you should really be aware of with OBJECT_ID is that it's database-context sensitive, and you may also need to supply that if you're querying across databases, ...

View answer
3 answers
0 votes
733 views
How did you split strings before string_split()
3 votes

From comments: The built-in STRING_SPLIT() function was added in SQL Server 2016, not 2014. And for me, I go the SQLCLR route because I am not using Azure Single DB or AWS RDS and thus have no ...

View answer
1 answers
10 votes
182 views
Could I have an undetected deadlock?
Accepted answer
2 votes

From a comment left by David Browne - Microsoft "Undetected deadlocks" usually means "undetectable deadlocks", eg where session is blocked by a SQL Server lock, and the other is ...

View answer
2 answers
7 votes
8k views
MS SQL Server: Do multiple queries in a batch ever execute in parallel and if so what happens when the second query is dependent on the first?
2 votes

From comments: The answer "no" is not specific to SQL Server. Any relational database system that respects the rules of ACID is required to execute statements in one batch sequentially, or ...

View answer
2 answers
2 votes
945 views
Does Log File contain both committed and uncommitted transactions?
Accepted answer
2 votes

SQL Server uses write-ahead logging so that changes (committed or not) are always written to the log file prior to being written to any data file. Records written to the transaction log do not ...

View answer
2 answers
2 votes
119 views
A very strange thing in the tempdb
2 votes

Perhaps the "Shutdown" is in reality a Hibernate? Apparently, Windows can do this by default, but it is supposed to end user processes, according to https://www.howtogeek.com/262325/why-is-windows-...

View answer
1 answers
1 votes
315 views
executing a stored procedure on a monthly schedule
2 votes

Use Oracle's DBMS_SCHEDULER to schedule a job to run monthly.

View answer
2 answers
-2 votes
36 views
MySQL Upgrade Procedure in a production environment
1 votes

Converted from comments: As a first step, it would be good to test the upgrade process using a VM. If one cannot be easily made, then upgrading either a development or UAT environment would allow you ...

View answer
1 answers
4 votes
864 views
Stored Procedure triggered by Service Broker can't access another database in SQLServer 2017
1 votes

From comments: I don't believe the behavior has changed between SQL 2016 and SQL 2017. It may be that the SQL 2016 database was TRUSTWORTHY whereas the SQL 2017 database is not or has a database ...

View answer
1 answers
5 votes
530 views
What are the downsides of running DBCC FREESYSTEMCACHE ('TokenAndPermUserStore') hourly?
1 votes

From Comments: This sounds like a prime candidate for a Microsoft Product Support engineer. - Max Vernon We experienced the same issue and our final decision was to use DBCC FREESYSTEMCACHE (&#...

View answer
2 answers
2 votes
180 views
Custom Deletion for Ola Hallengren Scripts
1 votes

From Comments: Set up a separate job (or an intermediate step) that copies the backups you want to a different location. Then Ola's cleanup won't have any idea about the copies. - Aaron Bertrand

View answer
1 answers
6 votes
435 views
SQL Server 2019 Performance issue with large INSERT
1 votes

From comments: To all intents and purposes, those plans are identical. As such, I'd focus more on differences in the physical set up and server settings. If the query optimizer for 2016 and 2019 are ...

View answer
2 answers
1 votes
345 views
SQL Server query with Linked Server running without Parallelism
1 votes

From comments: The easiest way to start troubleshooting this is to add OPTION(USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE')) to the query that isn't going parallel. It could be a cost based decision. ...

View answer
1 answers
3 votes
586 views
Memory usage grows on SQL Server Analysis Services 2012 until cubes fail to process
1 votes

From a comment by Robin Blondon: I tested with with SP1 through SP4 and it looks like SP4 is the only one that has this issue. I submitted a bug report On Azure Feedback. The suggested advice would ...

View answer
3 answers
1 votes
161 views
Parameterized Dynamic TSQL - Dynamic Parameters
1 votes

From comments: I think you need to take a step back and look at what you want to actually achieve with this. You are walking down a path with many known issues. For troubleshooting, performance, ...

View answer
2 answers
2 votes
11k views
SQL Native Client 11 - SQL Server 2017
1 votes

I just installed the ODBC client for SQL 2017 for a python process yesterday. It seems to be working just fine. MS has stated the ODBC driver would be deprecated for at least 7 years now. I'm not ...

View answer
1 answers
10 votes
525 views
Incorrect process utilization from System health extended events?
Accepted answer
1 votes

Values for disk and processor % counters that go over 100% Should be divided by the number of processors or disks present in the system. So 100% means it is using 100% of one processor. 250% would ...

View answer
1 answers
0 votes
110 views
revoke and apply privileges on current active sessions
1 votes

Assume that you revoke a privilege when the user is executing some long-time query which needs in this privilege for successfull execution. This will cause unpredictable break and may result into data ...

View answer
2 answers
1 votes
3k views
Locale is incompatible error in Postgresql 10 when replicating from Ubunu to Win 10
1 votes

You can't copy a data directory (which is what pg_basebackup does) between two different operating systems. The missing locale is just one symptom. If you need to replicate between Linux and Windows ...

View answer
1 answers
-1 votes
36 views
Raid Reconfiguration of SQL Server 2016 Box
Accepted answer
1 votes

You need to check the file named errorlog for details to why it failed. Possibilities are that it cannot find the files for the master database (pointed out from the registry) or that it can find ...

View answer
1 answers
1 votes
2k views
Postgresql: Select a table from different database and different host
1 votes

The second error message means, that your Postgres on db_name2 is not configured to allow connections from IP_db1. Unrelated to this problem: with modern Postgres versions it's usually better to use a ...

View answer
1 answers
1 votes
44 views
Reducing the number of tables used - mySQL
1 votes

You have 2 entities (taxes and groups) joined as M:N. 3-table structure for to store this data is optimal in most cases. Additional recommendations: 1) declare id field in val_taxes and ...

View answer
1 answers
2 votes
14k views
'OraOLEDB.Oracle' provider is not registered on the local machine - Oracle Database Client 12C
1 votes

From comment by Wernfried Domscheit: Have a look at this instruction to install both 32 bit and 64 bit on one machine: stackoverflow.com/questions/24104210/…. Note Oracle OLEDB provider is not ...

View answer
1 answers
0 votes
314 views
Upgrade SQL Server 2008 R2 to SQL Server 2012 and then set up data replication to SQL Server 2016
1 votes

Yes, you'll be able to configure Transactional Replication with 2012 as the Publisher and 2016 as the Subscriber. However, there are some changes made in replication procedures (that get created at ...

View answer
1 answers
1 votes
52 views
Upgrade SQL 2008R2 to SQL 2016 on windows server 2012R2
1 votes

Well, once you upgrade there is no going back. So that's a big danger in doing in place upgrades and why so many people don't do it. Some straight up won't do it for production. In place also has more ...

View answer
4 answers
1 votes
1k views
How to quantify or locate command timeouts in Azure SQL
0 votes

Taken from a comment: This type of information isn't usually collected by SQL Server (or Azure SQL Database). If you don't have some sort of monitoring software then it will be hard to confirm. I ...

View answer
1 answers
1 votes
109 views
The best practice for SQL + NoSQL database design
0 votes

From comments: This question is incredibly open-ended and has an entire branch of the industry devoted to it, namely data-architects and program-architects. The best thing to do is to pick ONE ...

View answer
1 answers
1 votes
37 views
Mongo Cluster sharded replica cluster design question
0 votes

From comments: mongoS doesn't need much memory/CPU (or even its own machine) and can be located (installed) on the config servers. config servers don't need that much memory, even when mongoS is ...

View answer