SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2010

Retrieving Report Names for SSRS Subscription Jobs

The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look at the jobs on the database server that Reporting Services is configured to use. At any rate, when the jobs are created, they are named with a very hard to… Read more

0 comments, 704 reads

Posted in BrianKMcDonald on 1 September 2010


A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK hint. They asked me what it was and my basic answer is this…Using WITH NOLOCK will return records as they currently are stored regardless of if someone is updating them… Read more

0 comments, 488 reads

Posted in BrianKMcDonald on 1 September 2010