Viewing 15 posts - 20,101 through 20,115 (of 49,552 total)
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/Topic1257698-1633-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
February 24, 2012 at 4:18 pm
Are you absolutely sure you're running the query in the same database? (database 7)
It's not an issue of aging out of memory, the partitions aren't plans, they're persisted objects.
Could a...
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
February 24, 2012 at 4:07 pm
Also check the ACLs on the files themselves, and the ownership.
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
February 24, 2012 at 3:56 pm
It's not a good idea to shrink the database regularly at all. The shrink after the full backup is probably playing havoc with index fragmentation as it is, forcing 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
February 24, 2012 at 2:50 pm
Well this is the first case I've heard of this problem restoring on 2012, so if it's a bug it's a rather specific one...
You did do the restore WITH RECOVERY,...
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
February 24, 2012 at 2:46 pm
It's not quite midnight...
In my scenario the old server had a single processor. So SQL could only run a single query at a time (sure, several could be waiting for...
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
February 24, 2012 at 2:45 pm
Re multiple indexes each on their own column: http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
In the scenario you describe I would go for 2 indexes:
LastName, FirstName, DoB
DoB, LastName (just so that we have a different leading...
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
February 24, 2012 at 2:40 pm
PaulB-TheOneAndOnly (2/24/2012)
Opus (2/24/2012)
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
February 24, 2012 at 11:16 am
Then you're going to need to fix the data first, SQL can't tell that 'John Smith' and 'John Smith' are the same person.
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
February 24, 2012 at 11:14 am
SELECT DISTINCT LASTFIRST FROM #mytable
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
February 24, 2012 at 10:36 am
Run management studio as administrator (as in right-click icon -> Run as Administrator)?
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
February 24, 2012 at 10:35 am
As a nonclustered index that would certainly be better than a clustered index. Maybe take a read through those articles, they do cover the question of columns and column ordering.
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
February 24, 2012 at 9:37 am
Like can use an index providing the wildcard is at the end.
The combo of surname, firstname and dateofbirth is a very poor choice for clustered index. A clustered index should...
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
February 24, 2012 at 9:23 am
For system databases, backups and integrity checks for all three, also index rebuilds (as for a user database) for msdb. Neither master nor model should change enough to warrant reindexing.
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
February 24, 2012 at 9:22 am
Oh yeah, that was fun.
@GilaMonster, so you don't have your own experience - you just read some posts about some guys, right?
Oh well, we tried.
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
February 24, 2012 at 5:19 am
Viewing 15 posts - 20,101 through 20,115 (of 49,552 total)