Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. This post helps you get the most out of the feature.
This challenge invites you to identify the largest sequence of alphabets from a string.
Unlike the hierarchical database model, which created a tree structure in which to store data, the network model formed a generalized 'graph' structure that describes the relationships between the nodes. Nowadays, the relational model is used to solve the problems for which the network model was created, but the old 'network' solutions are still being implemented by programmers, even when they are less effective.
Do you need to setup a SQL Server development environment in short order? Are you familiar with the options available? Are they all laborious? Are you facing security and data privacy issues? Do you have sufficient storage? Attend this information-packed session to learn about the best ways to build, manage and protect your sandbox development environment.
This editorial was originally published on Oct 12, 2006, published today as Steve is out today at the PASS Summit. Today Steve talks about the productivity that comes from having multiple monitors.
BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group with the .LastChild and .FirstSibling functions.
Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.
A task was set before our team to find the first Tuesday after 10 days from a specific date. This article shows how we accomplished that.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Tlp/Wa_Cs:0817-866-887 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal Sudirman...
WhatsApp:0817-866-887 Jl. Dr Ir H Soekarno, Ruko promenade. 8 Surabaya 60298, Kedung Baruk, Kec....
WhatsApp:0817866887 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers