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
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
Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON
2019-06-21 (first published: 2017-10-12)
8,091 reads
High availability solution with cross cluster support using the new Distributed Availability Groups
2016-11-14
2,770 reads
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
Other advantages of instances- better security not using the deafulat TCP port- each instance has its own tempdb- plus you can have MSDE instances (with its limitations eg 2GB database size) and decreas licensing costsDisadvantgaes- harder to manage- application connectivityAdam
2005-02-23
Fact tables tend to be a lot bigger than that but actually it all depend on the application so your case may be ok. To estimate the size you need to have an estimate of the expected growth and keep that in mind for future needs. For an estimate of the space you need to […]
2005-02-17
Sorry, I'm not that much into VB anymore, but after reading your link, have you tried adVarLongBinary? But I think there are MS hosted newsgroups about VB and databases. Maybe worth a try to find a workaround if you don't want to change your app logic.
2004-12-02
When I say this :CREATE VIEW A AS SELECT NAME, NO,ADDRESS ,DESCRIPTION FROM TEST WHERE IS_TRUE='F' ORDER BY NAME I get the message as below :The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified. If i use Top n, I have to specify the n […]
2004-11-30
2004-11-18
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers