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,251 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
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
In a previous post we went through how to use Docker Build Cloud to...
Comments posted to this topic are about the item Realities of Predictive Analysis
Just came across something weird. Was wondering if anyone else has ever seen this....
My database was in suspect mode, and when I checked using DBCC CHECKDB, it...
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers