Viewing 15 posts - 12,391 through 12,405 (of 49,552 total)
Core of your problem
Estimated rows 1
Actual rows 2887406
That's on the index seek for the REsult table. Probably stale or missing stats, could be parameter sniffing, without more details pretty hard...
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
July 13, 2013 at 12:54 pm
Edit again...
That looks like a default constraint. As such you won't find it in the DMV that lists foreign key constraints.
To alter the column you need to drop all constraints,...
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
July 13, 2013 at 12:54 pm
New persopn (7/12/2013)
here sql server log file usage is showing as 100% in task manager but internally it is showing as 1mb only how to solve this issues.
What do you...
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
July 12, 2013 at 10:12 am
nagkarjun1 (7/12/2013)
take a back up once.then perform DBCC shrink command.
No.
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
July 12, 2013 at 10:11 am
It won't be fragmentation as the query optimiser does not take fragmentation into account when costing the queries. It might be stats, the insert will trigger an auto-update which is...
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
July 12, 2013 at 6:14 am
Sean Lange (7/11/2013)
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
July 12, 2013 at 6:11 am
To be honest, I'd test out indexes on a table no matter how small it is (OK, maybe not a 1-row table). If the index improved query performance, keep it....
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
July 11, 2013 at 5:17 pm
Firstly, shouldn't
SET @query = 'SELECT * FROM OPENQUERY(' + @query + ','
actually be
SET @query = 'SELECT * FROM OPENQUERY(' + @linked_server + ','
?
As for the syntax error, print out...
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
July 11, 2013 at 11:05 am
The default trace automatically cleans itself up. It retains 5 files of no more than 20MB each, when it creates a new file it automatically deletes the oldest file.
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
July 11, 2013 at 11:02 am
dwilliscp (7/11/2013)
I thought WHERE is used to filter the rows then the group by is done..
That is indeed how it works.
but what I am seeing is that the count, and...
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
July 11, 2013 at 10:35 am
Sapen (7/11/2013)
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
July 11, 2013 at 10:16 am
timwell (7/11/2013)
1) is it OK to rely on a copy of the .mdf and .ldf files as a backup?
No.
2) if the current version becomes corrupt can you go back to...
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
July 11, 2013 at 10:09 am
Now out of ideas...
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
July 11, 2013 at 7:43 am
Lowell (7/11/2013)
So how do you create a fully contained database?
You don't. 2012 only allows partially contained.
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
July 11, 2013 at 7:38 am
If you don't have a backup then you cannot get the old values back. Unless you did the update in an explicit transaction and that transaction has not yet been...
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
July 11, 2013 at 6:25 am
Viewing 15 posts - 12,391 through 12,405 (of 49,552 total)