Viewing 15 posts - 15,481 through 15,495 (of 49,552 total)
Yes, it is necessary. Rebuild the system databases, start SQL, restore the backups of the system DBs.
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
November 28, 2012 at 12:47 am
Why?
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
November 28, 2012 at 12:46 am
Simon-413722 (11/27/2012)
It seem this article states offline index rebuild will drop the existing index before creating a new index?
Not sure where you saw that. Paul stated in the first section:
Index...
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
November 28, 2012 at 12:36 am
Can you post the graphical plans please?
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
November 27, 2012 at 1:18 pm
You can also edit all the procs (slow, I know) to log to a table when they are executed.
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
November 27, 2012 at 11:40 am
PiMané (11/27/2012)
If a table as an index with Col1, Col2, Col3 and includes Col5, Col4, Col7 (by this order) this index is obsolete if we have another index with Col1,...
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
November 27, 2012 at 8:45 am
Could you perhaps be a little more specific about what you're trying to do?
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
November 27, 2012 at 8:44 am
Internal Revenue Service?
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
November 27, 2012 at 8:43 am
No, the problem is not because there are two statements. It's because if you run that more than once, the second, third, etc executions will fail because the column already...
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
November 27, 2012 at 7:29 am
It's not seconds (anymore). It's a meaningless, unitless number.
It was originally based off of seconds on a specific benchmark machine back when the QO was initially developed, back sometime in...
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
November 27, 2012 at 7:25 am
And from the other instance?
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
November 27, 2012 at 7:17 am
opc.three (11/27/2012)
Select count(*) with no where-clause means the entire table will require a scan.
It's a view, not a table (stated as such in a different thread).
Naga, as Opc stated...
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
November 27, 2012 at 7:16 am
Is the amount of data in the two tables the same (not the amount returned, the amount in the tables)
Are the hardware specs the same?
Can you post the xml 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
November 27, 2012 at 2:18 am
Write your queries to fetch just the data that you need. Fetching data to the front end that you don't need and discard is a waste of time, resources, network...
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
November 27, 2012 at 1:40 am
http://www.google.com/search?q=allocation+contention+TempDB
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
November 27, 2012 at 12:14 am
Viewing 15 posts - 15,481 through 15,495 (of 49,552 total)