VIEW to list running and completed jobs
This view will list all completed and running jobs. It give running times, current step (if active) and average run times for steps.
2019-07-22 (first published: 2019-03-21)
1,758 reads
history
Charles Bachman and Pointer Chains
Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer chains were used to traverse data in the NDL standard and referential integrity that we use today.
2018-03-21
2,756 reads
Update Trigger to Store Only Updated Column and Former Value
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,076 reads
Show Job Run Snapshot
Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.
2012-10-19 (first published: 2012-09-17)
1,107 reads
Stairway to T-SQL DML Level 2: History of Structured Query Language (SQL)
Let’s step back in time and discuss the history of Structured Query Language, or what most SQL Server professionals just shorten to SQL. Fasten your seatbelts, crank up the time machine and travel back in time to follow the history of SQL and Microsoft SQL Server from its early years to where they are today.
2011-10-21
13,453 reads
Job History with Timeline
Similar to many other Job History scripts, but unique in that it has a timeline.
2010-06-01 (first published: 2009-04-03)
3,199 reads
RE: Output parameter returning NULL. Randomly.
Then I think you will benefit from reading this small article. It talks about cache miss that is caused by calling the same proc with different syntaxe. This is not a great performance booster, but every little bit can help on a busy server... But as you can see it can be the cause of […]
2005-05-27
RE: system tables have logins that have been deleted
Thanks, I have a function working that produces a list of orphaned users. I used VB then to check box the ones I needed resloved and the ones I needed removed. I also have several queries that will go through various system tables (sysusers, sysprotect, sysobjects, sysmembers,ect) to pull the information I need. Then I copy […]
2005-03-22
RE: Downgrading SQL Server Enterprise to Standard edition
KlK,The reason for this is Money. Server 1. Just doesnt need Enterprise edition.Server 2. Now has an instance that is used on the web and also doesnt need Enterprise edition, but needs 2 processor licenses (diff. £30000).Licenses were bought but the company split in 2 so these original licenses have gone.Hence me having to downgrade […]
2004-01-15
RE: Data Driven Query
- Are you running any scripts?- what Patch level is your Server at?- can you let it run with the Full file and in the option task select source rows error- have you thought about Bulkinsert Task as a workaround ?
2004-01-05
2 reads
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers