Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

I just had another article published at simple-talk.com: “Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting“.

The article is a deep dive into the configuration, security and performance of SSRS and is closely related to the SSRS Performance Dashboard which I recently developed.

 

Feel free to explore the article and to take a look at

Continue reading […] Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting […]

 

The 'smart' delete

Deleting rows from SQL Server database table is not as simple as it sounds.

The ‘straight forward’ delete – go delete, no matter what!

Yes, there is the DELETE statement:

?View Code TSQLDELETE table_1 WHERE ColumnName = ‘some_value’

What is the problem with that?

There are several problems:

transactions and logging
disk space
time consuming
locking and concurrency
IO throughput
parallelism, if present

So, it depends how

Continue reading […] The ‘smart’ delete […]

 

How to query currently running SQL Server Agent jobs

Today I went on a quest to discover a way to list all currently running SQL Server Agent jobs. As every other quest, this one also started with Google-ing.

Within 2 minutes I found this great post by Brent Ozar on SQLServerPedia. Why is this post so great? It is so great because Brent figured

Continue reading […] How to query currently running SQL Server Agent jobs […]