Viewing 12 posts - 16 through 27 (of 27 total)
Use ReportServer
SELECT TOP 10 * FROM dbo.ExecutionLog
That should give you what you're looking for.
January 21, 2009 at 12:20 pm
You are right! Outer joins are not allowed in indexed views. Those things are picky. I've never worked with them before but I'm learning.
I think I'll go the route of...
December 23, 2008 at 3:13 pm
The Kimball Group is what I have used. The books in the upper right hand corner of their home page basically serve as the testaments in my data warehouse Bible.
December 22, 2008 at 2:10 pm
You could use the "EXECUTE AS" statement. It will let you change the execution context of the session.
EXECUTE AS USER = 'testUser'
SELECT * FROM dbo.TestTable
December 11, 2008 at 5:45 pm
Proper indexes are key to any production database and there is enough information to write a book on the subject. I'm sure there is already one out there already! But...
December 11, 2008 at 5:37 pm
I think that might do the trick, thanks Loner!
April 18, 2008 at 10:25 am
The problem I encountered wasn't that Reporting Services was delaying sending the proc to SQL Server. I also ran a profile and ran an sp_who2 which showed the proc was...
March 11, 2008 at 5:13 pm
Just for fun, throw a "WITH RECOMPILE" into your stored procedure.
I've had the same problem with a proc working fine within SSMS but when run in Reporting Services the proc...
March 11, 2008 at 4:23 pm
Would the modify_date in sys.objects do the trick?
select top 10 * from sys.objects
where type = 'P'
and modify_date >= '2/01/2008'
February 19, 2008 at 9:47 am
This was a great article and reminded me of many of the reasons I moved back to a DBA role.
I was in management for three years and overall it...
February 18, 2008 at 11:25 am
Hey Peter, man, check out channel 9!
Sorry, I couldn't resist.
January 25, 2008 at 9:39 am
I did a couple things to improve our cube processing time.
First, during the cube process I ran a profiler on our data source to uncover the queries that were...
January 22, 2008 at 9:17 am
Viewing 12 posts - 16 through 27 (of 27 total)