When we tried to run a few of their stored procedure. How we can fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached.
Alerting on Long-Running Queries With a SQL Agent Job
Alert on long-running queries with a five-minute SQL Agent job, a deduplicated log, and one Database Mail notice per new request.
How to Add Constraint With No Validation? – Interview Question of the Week #299
Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
Single Installer for SSMS and ADS – SQL in Sixty Seconds #138
Microsoft has recently released a single installer which now installs SSMS and ADS both together in a single Installation.
Find Outdated Statistics – SQL in Sixty Seconds #137
Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.
Arrow in Execution Plan – SQL in Sixty Seconds #136
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.
5 Questions Answered OUTPUT Clause – SQL in Sixty Seconds #135
I have decided to create another SQL in Sixty Seconds video discussing the OUTPUT clause. In this video, we will discuss 5 questions.