A business I support recently purchased an add on to the pos software they use. It uses .net 3 and sql server express 2005.<BR><BR>Their support tech came out and installed some new hardware (not ...

If I have a SQL server process that has been running for some time, are there any methods to determining how much memory it really needs to run? I have a couple of low usage databases and I want to ...

The `DBCC MEMORYSTATUS` command provides a snapshot of the current memory status Microsoft SQL Server and the OS. It provides one of the most detailed outputs of memory distribution and usage in SQL ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

After you set this variable, when the memory usage of a tidb-server instance reaches 32 GB, TiDB will terminate the SQL operation with the largest memory usage among all running SQL operations in ...

In a move to speed online transaction processing (OLTP), Microsoft is adding in-memory capabilities into its SQL Server relational database management system. The next version of SQL Server will ...

Microsoft released to manufacturing the latest version of its SQL Server database, SQL Server 2014, on March 18. SQL Server 2014 will be available to customers as of April 1. The newest version of SQL ...