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,743 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,743 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,513 reads
The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look...
2010-09-01
778 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
578 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,433 reads
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
481 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 Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers