Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...
2017-10-12 (first published: 2017-10-07)
11,737 reads
In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication...
2017-07-31 (first published: 2017-07-18)
2,780 reads
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on...
2017-07-27 (first published: 2017-07-14)
2,160 reads
Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You...
2017-07-21
16,046 reads
Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...
2017-07-20 (first published: 2017-07-10)
11,686 reads
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,576 reads
One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...
2017-07-03 (first published: 2017-06-26)
4,158 reads
Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to...
2017-06-29
1,096 reads
In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...
2017-06-28 (first published: 2017-06-20)
1,524 reads
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...
2017-06-16
2,955 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hello All, I have recently joined a project, where main, core tables with millions...
Long time listener, first time caller. I have a problem that my usual bag...
evening All hoping someone can shed some light - I have a (originally) 2...
How many table hints can I include in a query?
See possible answers