…so the job failed….again…you know the one – that darn Integrity Check job: Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete ...
2015-11-18 (first published: 2015-11-16)
11,482 reads
Every time I install a new version of SSMS I make a handful of changes to the default setup. For...
2015-11-16
1,148 reads
Automatically name primary key constraints
There are some things you see when writing t-sql code and schemas that just look sloppy,...
2015-11-16
451 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look sloppy, one of those is unnamed constraints, what you...
2015-11-16
9 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
50 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
33 reads
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
705 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
223 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
219 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
326 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers