Get Information on Current Traces Running
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
936 reads
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
936 reads
I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events...
2014-10-16
928 reads
If you want to create sample random samples when dealing with date calculations to test your results, you can easily...
2014-08-12
513 reads
Common date values you may need to reference that you may not want to write from scratch each time.
Hope...
2014-08-12
1,046 reads
A step by step explanation on one way to get a consecutive period of months, which could easily be adapted...
2014-05-19
648 reads
Ran across a comment the other day that scalar functions prohibit parallelism for a query when included. I thought it...
2014-02-11
848 reads
If you run across migrating or copying a database structure for some purpose, yet need to change the database references...
2013-08-13
1,924 reads
I’ve never really used the F1 key for help files with most applications. I was surprised at the usefulness in...
2013-07-24
858 reads
If you have a set of columns inside your table that you want to allow nulls in, however if one...
2013-07-18
1,225 reads
When dealing with large amounts of objects in a database, navigation can be tedious with SSMS object explorer. This extender...
2013-07-16
735 reads
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Good Morning All, We are facing replication latency issue. I checked for blocking, long...
Comments posted to this topic are about the item Life's Little Frustrations
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