Viewing 15 posts - 24,466 through 24,480 (of 49,552 total)
I can't see any reason why that won't run, it compiles fine on my SQL 2008 instance.
You haven't perhaps got a temp table called #data created already in the session...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 10:00 am
ps. (8/4/2011)
Is sql denali available for production?
Denali has not been released, currently it's at CTP 3 and only TAP customers are permitted to use it in production.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 9:51 am
There's no such product as SQL Server 2010.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 9:49 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 9:48 am
It means the query voluntarily relinquished the CPU because it had exceeded it's execution time slice. Bottom line, your queries are very CPU-intensive and probably need optimisation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 9:26 am
The rebuild probably changed the execution plans. The queries had the potential to deadlock anyway, so you can't really say the rebuild caused it.
p.s. 80% fragmentation is incredibly high. The...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 9:24 am
Actually, ignore most of that for now. Can the windows team re-mount those drives? Or are they gone for good?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 8:37 am
Restore from backup.
Oh, wait...
Short answer, you're probably screwed. To be sure, check the SQL error logs and post ALL the messages that relate to that DB. Need to know exactly...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 8:36 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 8:09 am
daveriya (8/4/2011)
the thing is i cannot show my data ,its confidential ,i can show my execution plan,but when i save it comes with query,is there any way i can show...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 8:07 am
daveriya (8/4/2011)
if you dont want to help,dont comment
If you want help, read the article that explains what we need to solve this kind of problem. Screenshot of execution plan !=...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 8:06 am
hxkresl (8/4/2011)
My research would indicate this is the cause of trying to insert more data than a column can accomodate:
Yup.
But, line 1 is only referring to the very first line...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 7:25 am
murali.jillellamudi 85871 (8/3/2011)
Do the backup file systems really need to be in the SQL Cluster.
Yes, because otherwise SQL can't write a backup to them. All drives used by SQL (backups...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 7:23 am
And several more possible reasons are given and explained in the article I referenced.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 7:22 am
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/Topic1154184-150-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2011 at 6:51 am
Viewing 15 posts - 24,466 through 24,480 (of 49,552 total)