SQL Server Storage best practices
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,425 reads
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,425 reads
What are exactly Database Managed Services?
The term is widely used and covers so many things simultaneously, so it is hard...
2015-07-07
971 reads
Managing SQL Server can be exhausting, so more and more companies today choose either to delegate this task to some...
2015-07-06
700 reads
If you`re using transactional replication on SQL Server platform on rather large and data intensive environment you may have faced...
2015-07-02
1,651 reads
It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script...
2015-06-22
2,353 reads
Form the first glance it may seem to be complicated to calculate price of hosting your database on Azure SQL. We`re simplifying this...
2015-06-17
575 reads
Databases today are the heart of any business. Holding literally tons of information they indirectly are responsible for managing personnel,...
2015-06-17
566 reads
Database design is a complex industry involving many technologies, software and specialists. The term “design” is a little bit misleading...
2015-06-11
446 reads
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Comments posted to this topic are about the item How a Legacy Logic Choked...
I have 2 tables: TBL_A and TBL_B each with the same 2 columns; ServerName...
Hey all, Bit of background — I’ve somehow fallen into the classic “overnight DBA”...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers