Viewing 15 posts - 5,371 through 5,385 (of 18,926 total)
SQLRNNR (6/16/2011)
I have had similar happen to me - rebuild from scratch as Ninja said seems to work.
The the default fix for most M$ products :hehe:.
June 16, 2011 at 9:53 am
Did you run it for all 5-6 logs?
Maybe you have something else there.
June 16, 2011 at 9:34 am
When you have a real memory error in SQL Server's side you get an error in the sql error logs.
CREATE TABLE #logs (LogDate DATETIME, ProcessInfo VARCHAR(50), Txt VARCHAR(MAX))
INSERT INTO #logs...
June 16, 2011 at 9:03 am
makes no sens but it's erhm working...
happy hunting.
June 16, 2011 at 8:10 am
Google broken again?
http://sqlserverperformance.idera.com/tsql-optimization/understanding-sql-server-statistics/
June 16, 2011 at 8:09 am
What happens if you use that expression in a columnn?
Not the IIF, but just the first()?
June 16, 2011 at 7:29 am
The only thing I can think of it to try to rebuild the report from scratch, staring with that query.
Kind of a last ditch resort but I've seen it work...
June 16, 2011 at 7:05 am
tony.aguanno (6/16/2011)
Microsoft SQL Server 2008 R2 (RTM)...
June 16, 2011 at 6:54 am
tony.aguanno (6/16/2011)
MS .NET Framwork 5.5 SP1 and the reporting services configuaration tool that comes with it.
Not sure if this means that...
June 16, 2011 at 6:36 am
nsaireddymca (6/16/2011)
can any one show the prrof what is exact difference between char and varchar by writins syntax in our sqlserver
PLEASE START A NEW THREAD.
Thanks in advance!
June 16, 2011 at 5:32 am
Ahhhhhh, I had a spider encounter too while driving to work this morning (much smaller, but still just as surprising).
I saw it suddenly dangling about half / inch away from...
June 16, 2011 at 5:30 am
Ninja's_RGR'us (6/16/2011)
Jeff Moden (6/15/2011)
Just my 2 cents. I agree with Remi... the recompile will likely keep the hang from happening again.
Not the first option, I'd still like to see...
June 16, 2011 at 5:28 am
Jeff Moden (6/15/2011)
Just my 2 cents. I agree with Remi... the recompile will likely keep the hang from happening again.
Not the first option, I'd still like to see what...
June 16, 2011 at 5:24 am
mark.allen 70725 (6/15/2011)
The optimizer knows that TOP 0 and...
June 16, 2011 at 5:20 am
SwePeso (6/16/2011)
A SELECT INTO puts a table lock on each involved tables in your query to prevent schema alterations during the duration of...
June 16, 2011 at 5:19 am
Viewing 15 posts - 5,371 through 5,385 (of 18,926 total)