Viewing 15 posts - 13,441 through 13,455 (of 49,552 total)
Why do you think it has unrelated tables in?
The optimiser will NOT use a plan for one query for another query. It cannot. For ad-hoc queries the plan matching is...
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 18, 2013 at 6:11 am
The point of an index is to reduce the number of rows needed for the query as early as possible. To do that, the index needs to be seekable 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
April 18, 2013 at 6:03 am
Neither of those indexes are at all useful for the first query, only the one on person is useful for the second.
Index column order matters. It matters a lot. 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
April 18, 2013 at 5:21 am
Zeal-DBA (4/18/2013)
But what if client ask to create at least one index on each table which are not even suggested by missing index DMV.
Ask why he wants to create them....
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 18, 2013 at 4:52 am
Ananth@Sql (4/18/2013)
on millions of records is completly different from running the query on small datasets as i think.Hence i want to run the query on millions 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
April 18, 2013 at 4:50 am
Why don't you run the query and see which index and execution plan it will use? If you would like help understanding why SQL picked the specific plan that it...
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 18, 2013 at 2:05 am
Maximum memory supported by SQL 2000: http://msdn.microsoft.com/en-us/library/aa933149%28v=sql.80%29.aspx
It is dependent on the operating system and SQL edition, ranging from 2 GB up to 64 GB.
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 18, 2013 at 2:01 am
Connections to a database will not give you the 'database inaccessible' error message. If you're getting that error when backing up, then the database you're trying to back up is...
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 18, 2013 at 12:02 am
prashanthreddymr (4/17/2013)
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 17, 2013 at 11:54 pm
With only 4 GB, I'd recommend adding the /3GB flag to boot.ini, not /PAE and not enabling AWE. When/if you add more memory to go over 4GB, then AWE is...
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 17, 2013 at 2:47 pm
curious_sqldba (4/17/2013)
GilaMonster (4/17/2013)
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 17, 2013 at 2:29 pm
CheckDB always creates a snapshot, on all editions, it's in the same directory as the database files are and that cannot be changed. Only on Enterprise edition can you manually...
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 17, 2013 at 1:58 pm
curious_sqldba (4/17/2013)
However i am still not clear what 'Hidden Snapshot' means?
Exactly that. It's a database snapshot that's hidden from view (not in the system 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
April 17, 2013 at 10:36 am
Yes, you can take a snapshot of a database on a different drive and CheckDB that. It won't have any effect at all on the IO load 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
April 17, 2013 at 10:35 am
sqlfriends (4/17/2013)
For clustered index scan, because this is a view of schema binding
Schema binding does not cause table scans.
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 17, 2013 at 10:33 am
Viewing 15 posts - 13,441 through 13,455 (of 49,552 total)