MSDB Job History Duration Conversion
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...
2010-10-05
2,739 reads
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...
2010-10-05
2,739 reads
It's official! I am presenting a mini session for SQL Saturday in Orlando. My topic and some details are below:
Delivery...
2010-10-05
447 reads
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-01
1,512 reads
The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look...
2010-09-01
775 reads
A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK...
2010-09-01
535 reads
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
576 reads
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
12,226 reads
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
480 reads
First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...
2010-08-28
415 reads
I recently had to find a way to look up how many columns were in a table and which of...
2010-08-20
418 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers