Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

RIL_button( “http://sqlconcept.com/2011/11/22/administrating-sql-server-reporting-services-planning-documenting-and-troubleshooting/”, “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

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

November 22nd, 2011 | Tags: , , , , , , , , , , , , , | Category: SSRS, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

The 'smart' delete

RIL_button( “http://sqlconcept.com/2011/09/20/the-smart-delete/”, “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,

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

September 20th, 2011 | Tags: , , , , , , , , , | Category: Data Generation, Data Warehousing, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (5 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

How to query currently running SQL Server Agent jobs

RIL_button( “http://sqlconcept.com/2011/06/25/how-to-query-currently-running-sql-server-agent-jobs/”, “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

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

June 25th, 2011 | Tags: , , , , , , , , | Category: SQL Server Agent jobs, T-SQL | One comment - (Comments are closed)
Work on itWell, now...OKGoodGood job! (15 votes, average: 4.67 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

 
  Older Entries »