Viewing 15 posts - 31,816 through 31,830 (of 49,552 total)
Personally I detest all forms of prefixing. It makes things harder to read, not easier, and in most cases the object type is obvious from how it is used. 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
July 15, 2010 at 5:41 am
You can't.
In theory, if you have a complete understanding of the page structure of the database file and you know exactly how the version code is stored on the database...
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 15, 2010 at 5:37 am
Lowell (7/15/2010)
also i'm under the impression that verswion is more tied to the SQL the db is restored on...
It's both. A SQL 2005 instance can only work with databases 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
July 15, 2010 at 4:53 am
Can you query sys.dm_db_index_physical_stats and see if the sizes agree?
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 15, 2010 at 4:42 am
You should not even be thinking of changing the system tables. It's quite likely to cause more damage than it fixes.
If this is about that corruption case from 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
July 15, 2010 at 4:37 am
Note: 2 year old thread.
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 15, 2010 at 4:19 am
And what, when totalled comes to that 540MB? Data size, index size, unallocated size, sum of those?
If you run DBCC UpdateUsage, does anything change?
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 15, 2010 at 4:17 am
How are you measuring the total size of all tables?
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 15, 2010 at 4:11 am
y.koteswarrao-652921 (7/15/2010)
This is an interview question can we create a primary key on table without cluster index?
Yes.
I think it not possible.............Can we forceble ignore the cluster index while creating...
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 15, 2010 at 2:01 am
SpiderDK (7/15/2010)
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 15, 2010 at 1:53 am
sumit.agrawal (7/15/2010)
Meanwhile you can check whether dropping and recreating indexes will help....
It will not.
Dropping and recreating indexes only works when the corruption is in the nonclustered indexes. When that's 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
July 15, 2010 at 1:52 am
doobya (7/14/2010)
I am having same problem...
Please post your question in a new thread and include the stored proc definitions, table and index definitions and both execution plans.
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 14, 2010 at 11:34 pm
Nat Na (7/14/2010)
About Parameter sniffing, I only saw it happens in procs. Is it possible for querys from appl?
Can happen any time there's parameterised queries.
And how can I...
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 14, 2010 at 11:34 pm
Homework? Interview 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
July 14, 2010 at 11:26 pm
gago.99 (7/14/2010)
Dense Index, Sparse Index,
Not SQL indexes
Covering Index, Unique Index,
These aren't index types, they're just properties of an index and covering isn't even that. One index can be covering...
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 14, 2010 at 11:21 pm
Viewing 15 posts - 31,816 through 31,830 (of 49,552 total)