sql server – Asignación de variables de fecha planas en un case

me dan una mano con esta parte, estoy empezando a programar en sql server y mi intención es de la variable @AAAA tengo el dato año y lo quiero comparar con el campo falta decimal (8,0) que tiene fecha plana aaaammdd y quiero que el sql le asigne a la variable @fechaalta el valor 12 en el caso que @AAAA sea mayo o igual. en el caso que @AAAA es menor que a la constante 13 le reste los dos numero de la posición 5 (mes).
Esta sentencia tiene desde errores de sintaxis, hasta de lógica.

@AAAA decimal (4,0),
@Fechaalta decimal (8,0)

´´SELECT CAST(
CASE
WHEN @AAAA > LEFT(falta,4)
then set @Fechaalta = 12

             ELSE set (@Fechaalta = 13 - (SUBSTRING (falta. 5,2))                   

            END )

from (base).(dbo).(tabla)’

networking – How does a server receive every player input with a server-authoritative structure?

I’ve been having a lot of trouble understanding networking in fast-paced games. A server has a fixed tickrate, and the server receives input from clients at a fixed rate as well. Let’s assume that a client is running at 300fps but is sending 64 updates to the server a second.

Clearly, the client did not send data about every frame, which means that certain inputs were not sent to the server. However, in every networked first-person shooter, the server still seems to pick up every input.

enter image description here

In this image, a client presses W at a certain frame, but that frame’s data is not sent to the server.

A possible solution would be to send the server updates equal to framerate. But if a client is playing at a high framerate, they could be sending too much data for the server to handle.

So how does a server receive every input from clients?

sql server – EF core not fetching data from table based on it’s clustered index

I created an table with a clustered key on the CreateDate column like so:

CREATE TABLE Posts
(
    ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY NonClustered,
    Title (nvarchar)(800) NULL,
    Description (nvarchar)(max) NULL,
    CreateDate (datetime) NOT NULL Default getdate(),
);

CREATE CLUSTERED INDEX IX_Posts_CreateDate_Desc ON Posts(CreateDate desc)

Ef core generated this in the db context:

entity.HasIndex(e => e.CreateDate)
                    .HasName("IX_Posts_CreateDate_Desc")
                    .ForSqlServerIsClustered();

But yet, when I fetch the data from the data base it’s ordered by the ID primary key:

    IQueryable<Posts> queryBase(DbSet<Posts> p) => p.Include(x => x.InverseParent)
                                                    .Include(x => x.User);

    IEnumerable<Posts> posts = await base.GetAllByCondition(predicate, queryBase);

   //posts are ordered by the primary key instead of the create date
    List<Posts> postList = posts.ToList();

How Are SQL Server Clients Connecting?

This post is slightly different than my first post, because I overlooked a critical detail, which was I could find no evidence that any of the TCP ports were turned on. Here is some background:

I have a Windows 2016 server with an unnamed and a named MS SQL SERVER instances installed. TCP and Memory connections are turned on for both, until you get to the protocol section for TCP.

The unnamed instance was installed first, and hence was assigned port 1433. The firewalls on the server and the client (Windows firewall) are set to allow the necessary UDP and TCP traffic.

Here are two pictures denoting most of the port configurations for the unnamed instance. Please note enabled is set to No for all settings, there is no dynamic port, and the port used is 1433.

Unnamed Instance TCP Ports Partial 1

Unnamed Instance TCP Ports Partial 2

This database belongs to a vendor, whose clients are able to connect to the database, so I am trying to figure out that happens in the hope that information will help me to connect to the named instance.

I’ve tried all suggestions in the prior post, read on-line, and my named database was able to do an import from an older SQL Server database, 2008.

Using netstat, I can see port 1433 is in use, so there is no point in co-opting it. Should I just pick a port I know won’t be used, or is not likely to be used?

sharepoint server – Default List View Search box not working for few users in share point 2013

I have a list with default view on it. The default Share Point 2013 List view Search box works fine for few users. But for some users it does not work.Means if they try to search some item with Title value the result does not shows up.Although the users having problem are able to add/edit/delete item within the list.

Please help me on this thanks.

Thanks in advance!

New 2020 Dedicated Server Prices from $19/mo *fully managed*100% confidential* in Riga, Latvia | Proxies-free

We are a server rental company running our own private datacenter located in Europe (Latvia). New 2020 prices below:

* First term 50% off (for example: pay for 1 year in advance and get 50% off for a year!)

Coupon code exclusively for WJ users: WJ2020

Brand new HP and Supermicro servers, fully managed and 100% confidential.

Dedicated Intel Celeron Quad Core
4 core CPU
4GB DDR3 RAM
500GB HDD
1gbit port
Centos 6 / 7 / 8 (or Debian/Ubuntu/Fedora/FreeBSD/Windows)
1 clean IP
FREE 24h SETUP
FULLY MANAGED
@$19.50/mo.
Click here to Order Now!

Dedicated Intel Dual Core (Xeon, Core i3 or similar)
2 core CPU
8GB DDR3 RAM
1TB HDD RAID1 (or 128GB SSD)
1gbit port
Centos 6 / 7 / 8 (or Debian/Ubuntu/Fedora/FreeBSD/Windows)
1 clean IP
FREE 24h SETUP
FULLY MANAGED
@$24.50/mo.
Click here to Order Now!

Dedicated Intel Quad Core (Xeon, Core i5 or similar)
4 core CPU
16GB RAM
2TB HDD RAID1 (or 256GB SSD)
1gbit port
Centos 6 / 7 / 8 (or Debian/Ubuntu/Fedora/FreeBSD/Windows)
1 clean IP
FREE 24h SETUP
FULLY MANAGED
@$34.50/mo.
Click here to Order Now!

Dedicated Intel Quad Core Plus(Xeon, Core i7 or similar)
4 core CPU
32GB RAM
2TB HDD RAID1 (or 256GB SSD)
1gbit port
Centos 6 / 7 / 8 (or Debian/Ubuntu/Fedora/FreeBSD/Windows)
1 clean IP
FREE 24h SETUP
FULLY MANAGED
@$44.50/mo.
Click here to Order Now!

Dedicated 2x Intel Hexa Core Xeon
12 core CPU
64GB RAM
2TB HDD RAID1 (or 520GB SSD)
1gbit port
Centos 6 / 7 / 8 (or Debian/Ubuntu/FreeBSD/Windows)
1 clean IP
FREE 24h SETUP
FULLY MANAGED
@$54.50/mo.
Click here to Order Now!

Now a FREE Windows Server 2008R2/2012R2/2016 license with any config! (available on request)

Please visit our website: https://serveria.com or PM me for a personalized quotation.