Remove c
article thumbnail

tempdb Enhancements in SQL Server 2019

SQL Performance

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. Now that 2019 CTP 3.2 I have SQL Server 2019 CTP 3.2

Servers 95
article thumbnail

Connecting MongoDB to Ruby with Self-Signed Certificates for SSL

Scalegrid

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. servers.mongodirector.com:27017/test?replicaSet=RS-example-0&ssl=true" default: admin) auth_source: test.

C++ 100
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

SQL Performance

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Here’s the attempted solution using a CTE: WITH C AS. ( FROM Sales.

C++ 140
article thumbnail

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. These new applications are a great way for enterprise companies to test out PostgreSQL before migrating their entire infrastructure. Objective C.

article thumbnail

Mobile app automation testing Tools: An exhaustive list

Testsigma

Simform (as of 2019) stated that an average user has at least 40 apps installed on their phones while millennials have around 67 apps. So, there’s a solid reason why mobile app testing is a crucial step in any app development process. To ensure our users get a seamless experience across any device — we perform mobile app testing. .

article thumbnail

The challenge is on! Community call for creating the fastest number series generator

SQL Performance

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. Let’s proceed to performance testing.

C++ 114
article thumbnail

Islands T-SQL Challenge

SQL Performance

To test the performance of your solution, you’ll need to populate the table with larger volumes of sample data. L0 AS ( SELECT 1 AS c. numgroups AS INT = 1000 , @rowspergroup AS INT = 10000 , -- test with 1000 to 10000 here. My test machine has four logical CPUs, running SQL Server ® 2019 Enterprise.

C++ 136