Viewing 15 posts - 40,141 through 40,155 (of 49,571 total)
That syntax works fine in SQL. If it's not working in the SSRS query interface, maybe create a stored procedure that takes the parameter and call that from SSRS
declare @i...
March 29, 2009 at 7:20 am
Matt (3/29/2009)
Is this an acceptable amount or should I try to reduce this number?
Maybe.
Are they all used? Check the index usage stats DMV for that info, but note that it...
March 29, 2009 at 7:12 am
Take a look at this article over at Simple Talk. It goes into creating the trace scripts and running them. http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
If you need an hour on/hour off kind of thing,...
March 29, 2009 at 7:09 am
James Brown (3/28/2009)
Since the programming has not changed, my thought is that there are hardware problems. Can I get some options as to what the problem may be?
Typically corruption...
March 28, 2009 at 2:44 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic685614-265-1.aspx
March 28, 2009 at 2:40 pm
Kit G (3/27/2009)
Activity on the Thread seems to have diminished. Should I be worried? Is THE THREAD executing its plan to take over the world and that's why...
March 28, 2009 at 6:53 am
Gift Peddie (3/27/2009)
That is a better book the worst is a none SQL Server book but still Microsoft press an exam prep book comes with 89 pages errata. I...
March 28, 2009 at 6:48 am
Krishna (3/27/2009)
1.) There should be at least one clustered index for a table which should be Narrow, ever-increasing, unique
At least one?
5.)Think about Covering indexes to cover all the columns retrieved...
March 27, 2009 at 2:05 pm
Do not ever use the profiler gui when tracing busy production servers. It can kill th server. I've done that twice.
There's an article at Simple Talk that shows how to...
March 27, 2009 at 1:54 pm
What did you set the fill factor for when you reindexed? (If that's what the maint plans are doing. Impossible to tell from the commands you postd)
March 27, 2009 at 1:46 pm
Marios Philippopoulos (3/3/2009)
I run the following to get the object name:
SELECT object_name(99)I get the following: ALLOCATION
It's one of the GAM/SGAM/PFS pages. One of the allocation structures of the database.
This was...
March 26, 2009 at 10:48 pm
GilaMonster (3/26/2009)
Three days of major internet connectivity issues and every tech I speak to wants me to restart the machine and reset the modem.
Then, tonight, the crowning glory.
The error is...
March 26, 2009 at 10:44 pm
GSquared (3/26/2009)
March 26, 2009 at 2:22 pm
Luke L (3/26/2009)
March 26, 2009 at 2:19 pm
GSquared (3/26/2009)
Sounds like my last call to tech support.Me: My computer won't POST
....
I wouldn't have bothered in that case.
But then, I built my desktop myself, so for the PC...
March 26, 2009 at 2:05 pm
Viewing 15 posts - 40,141 through 40,155 (of 49,571 total)