Viewing 15 posts - 22,426 through 22,440 (of 49,552 total)
No, that should work. The internal versions of 2005 SP3 and 2005 SP4 are the same (and iirc, 2005 has a more sensible error message about downgrade restores)
Could be 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
November 8, 2011 at 1:14 pm
Fragmentation is solely and only a measure of how 'out of order' an index's leaf pages are based on the index key. That's all it is.
So if index X (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
November 8, 2011 at 7:53 am
Dev @ +91 973 913 6683 (11/8/2011)
1.Parsing
2.Compilation
3.Selection of Execution Plans
4.Execution / Fetch
5.Format & Display
But based on Gail’s comment it looks like Step 2...
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 8, 2011 at 7:48 am
derekr 43208 (11/8/2011)
ThanksWould that still apply even if the 2 indexes were covering the same columns?
Yes. An index's fragmentation is a function of that index's leaf pages, the percentage of...
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 8, 2011 at 7:42 am
You haven't answered either of my questions.
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 8, 2011 at 7:30 am
derekr 43208 (11/8/2011)
How does...
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 8, 2011 at 7:27 am
Ok, you're going to need to give us a lot more info first.
What's larger than it should be, the log file or the data file?
What recovery model are you using?
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 8, 2011 at 6:45 am
SQL Kiwi (11/8/2011)
Dev @ +91 973 913 6683 (11/8/2011)
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 8, 2011 at 6:41 am
Clustered indexes enforce physical sort order of rows
Nonclustered indexes can't be built on a heap
Nonclustered indexes on a heap can't be 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
November 8, 2011 at 6:38 am
Dev @ +91 973 913 6683 (11/8/2011)
Gail, I will accept your comments if I find any supporting documents on MSDN. I don't find any (I googled it as well).
http://msdn.microsoft.com/en-us/library/ms190439.aspx
As 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
November 8, 2011 at 6:34 am
gsuvarnarekha (11/8/2011)
In sql server 2000 DTS packages were stored in mater database (in tables)..
No, they were stored in msdb, in the table sysdtspackages. The exact same table is in SQL...
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 8, 2011 at 5:54 am
gsuvarnarekha (11/8/2011)
what am asking is if minimal information stored in t-log means how can we recover the data when we set database as bulk recovery...
Did you read those articles?
What 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 8, 2011 at 5:53 am
Dev @ +91 973 913 6683 (11/8/2011)
Per my understanding, Compilation just verifies syntaxical errors & object dependencies (permissions & availability etc.)
Syntax and object existence is done by the parser 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
November 8, 2011 at 5:50 am
http://msdn.microsoft.com/en-us/library/ms179314.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
November 8, 2011 at 5:48 am
gsuvarnarekha (11/8/2011)
I had better if u will give our own words in short..
What, you want me to rewrite or summarise Books Online?
Read through the BoL pages, if you have specific...
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 8, 2011 at 5:45 am
Viewing 15 posts - 22,426 through 22,440 (of 49,552 total)