Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps us provide outstanding service to our customers, identify potential...
2018-11-07
10 reads
How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When...
2018-11-01 (first published: 2018-10-24)
2,479 reads
“We don’t want to know that it’s broken, just that it’s working.” “We want our database to always be available.”...
2018-10-08
420 reads
SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you...
2018-09-19
279 reads
Situation Good index management is key to success. Having too many unused indexes around slows down your system. It is not...
2018-07-07
507 reads
Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV’s [crayon-5c335dbc1c266788449988/]...
2018-07-07
391 reads
You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.
The...
2018-05-20
1,758 reads
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
1,357 reads
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
120 reads
Enable dark-theme for SSMS Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS). Reading time +/- 10 minutes References www.sqlserver.info...
2018-03-14
429 reads
By Steve Jones
I wanted to do some testing of SQL Server 2025 on my laptop. I...
By Kevin3NF
If you’re responsible for a SQL Server instance, you need working, consistent backups. Not...
Over the years, I’ll admit, SQL Server has come a long way in making...
Hello SSC, Wishing everyone happiness and health and hope you are all doing well!...
Salut l'équipe, Lors de l'exécution parallèle d'opérations DELETE sur la table [YourTableName], j'ai observé...
Comments posted to this topic are about the item Can You Ask for a...
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) , creditlimit INT , discount NUMERIC(4, 2) , lastorderdate DATETIME , lastorderamount NUMERIC(10, 2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT); GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers