Viewing 15 posts - 5,281 through 5,295 (of 9,643 total)
One option is to get SQL Server 2008 developer edition and use the ability in SSMS to run the same query against multiple servers at once. See this article.
Something...
April 23, 2009 at 7:43 am
Shark Energy (4/23/2009)
The table is reindexed every night before the job runs....
I have tried dropping and recreating the indexes at the start of the job.
Re-indexing BEFORE you truncate and...
April 23, 2009 at 7:24 am
Can you post your complete restore command?
What happens if you do Restore HeaderOnly From [backup device]?
April 23, 2009 at 7:17 am
I have always used audit tables and triggers for this type of auditing. Yes, you could cause a problem if the application code is using @@Identity to return the...
April 23, 2009 at 7:14 am
Can you post some example code? Since 2005 came out I have seen CTE's as the recommended method for doing this, but without seeing your code it is hard...
April 23, 2009 at 7:05 am
I just want to make sure I understand your architecture. You have Reporting Services installed on ServerA and the Report Server databases installed on ServerB, correct?
If this is correct...
April 23, 2009 at 7:02 am
What is the final goal of this process? Is there any reason why you can't JOIN on your id's table within the stored procedure returning all the rows in...
April 23, 2009 at 6:48 am
Is there any possibility that the source data was changed during the time the report is being looked at and then the "new" report is run? How major is...
April 23, 2009 at 6:35 am
Oops, I read your question the way I would have asked it. I can't find a registration deadline anywhere on the Summit web site.
April 22, 2009 at 8:48 pm
Until May 1st it's $1195, but if you use the SSC3D registration code you get $100 off AND an invite to the SSC party. See this: http://www.sqlservercentral.com/articles/pass/66318/
April 22, 2009 at 8:44 pm
Okay, I am going to make a suggestion that I always make in these situations. Create a calendar table. That will simplify things greatly. Something like this...
April 22, 2009 at 9:43 am
Here's the way I understand it, and I could be wrong, so don't take this for the definitive answer. Check out Gail Shaw's[/url] and Kimberly Tripp's[/url] blogs, they have...
April 22, 2009 at 8:43 am
Indexes either speed up or slow down the Updates (how's that for being specific) and will slow down the insert, especially for a clustered index.
For example in your test data,...
April 22, 2009 at 8:26 am
According to Grant Fritchey's book SQL Server 2008 Query Performance Tuning Distilled, I know you are on 2005, but I think it still applies, if your average Pages/Sec < 50...
April 22, 2009 at 8:21 am
What do you mean by "logged user"?
Have you looked up Create Procedure in BOL?
April 22, 2009 at 6:51 am
Viewing 15 posts - 5,281 through 5,295 (of 9,643 total)