SQL Server Bugs That Might Bite You
I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...
2014-12-10
495 reads
The Truth About Index Fragmentation
In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download...
2014-11-20
449 reads
Show Only Specific Databases
One of our customers is implementing a very large consolidation project in which they enable users to create their own...
2013-01-08
300 reads
SELECT Top 4 Bugs FROM DBAs IN SQL Server
I gathered the 4 most common bugs I find DBA are using in their code. Feel free to send me...
2012-11-11
454 reads
Parallel Processing For Pros
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
314 reads
Update Statistics and the new TraceFlag 2371
What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?
The Statistics life cycle
As a regular...
2012-01-18
360 reads
Pro and Cons of Parameter Sniffing
Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'
-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...
2012-01-02
418 reads
2011-09-03
336 reads
Answer to the Quiz
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-28
314 reads
Answer to the Quiz
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-27
433 reads
Blogs
Monday Monitor Tips: Finding the Hostname for Queries
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Can AI Read Execution Plans?
Yeah, yeah, second AI post in a row. I promise not to make a...
Streamline Dependency Management in Databases
By Chris Yates
In the intricate world of business, where precision and efficiency are paramount, managing database...
Forums
SQL Server is terminating in response to a 'stop' request from Service error
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Database Files on Shares I
Comments posted to this topic are about the item Database Files on Shares I
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers