Viewing 15 posts - 18,931 through 18,945 (of 49,552 total)
If you want my help, I need to see the details. The generic description is not enough. At least post the insert statements and list the indexes (as sp_help shows...
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
April 20, 2012 at 6:28 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Have you checked for blocking.
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
April 20, 2012 at 6:18 am
Of course you have to. How else would the indexes get rebuilt?
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
April 20, 2012 at 6:15 am
SQLKnowItAll (4/20/2012)
@Gail Now I am confused, I thought that we cannot rely on that for determining the usefulness of an index?
You can, I never said otherwise (see blog...
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
April 20, 2012 at 6:13 am
Expert is not something you call yourself (unless you want to look arrogant and cocky). It's something other people call you. It comes from lots and lots of experience, not...
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
April 20, 2012 at 6:02 am
Online index rebuilds is not a feature that you enable, it's just an option on an ALTER INDEX statement
ALTER INDEX ... REBUILD WITH ONLINE = ON rebuilds the index online,...
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
April 20, 2012 at 6:00 am
That was completely unnecessary. All you had to do was move the files and bring the database back online.
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
April 20, 2012 at 4:38 am
Read my instructions again.
GilaMonster (4/20/2012)
Once you've run that, take the database offline, move the files, then bring the DB back online.
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
April 20, 2012 at 4:19 am
Mike John (4/20/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
April 20, 2012 at 4:13 am
A once-off shrink is fine, as long as it is once-off (run once, not regularly) and you shrink to a size that still leaves enough free space in the files...
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
April 20, 2012 at 3:55 am
For a user database it'll work if you change the file name to where you want the files to be. Once you've run that, take the database offline, move 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
April 20, 2012 at 3:51 am
In recovery just means SQL's running crash recovery on the databases. It will do that to every database every time SQL starts up.
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
April 20, 2012 at 3:50 am
Taking a guess since I don't know Oracle code (This is a MS SQL Server site)
Is the combination of TO_CHAR(WHEN_OPENED,'MONTH,YYYY'), OID_silverpop_open and site_id unique perhaps? If so, then the count...
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
April 20, 2012 at 3:49 am
Not necessarily a small problem on the disk, you can't conclude that. Could be a huge problem that's only shown up once so far.
No, nothing really from SQL. Check windows...
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
April 20, 2012 at 3:42 am
Lynn Pettis (4/19/2012)
preetham gowda (4/19/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
April 20, 2012 at 3:40 am
Viewing 15 posts - 18,931 through 18,945 (of 49,552 total)