Viewing 15 posts - 40,216 through 40,230 (of 49,552 total)
keil.asta (3/22/2009)
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
March 22, 2009 at 11:00 am
The first thing I'll suggest is that you merge the date and time columns. Storing them separately means a lot of extra work to do comparisons or calculations.
So, 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
March 22, 2009 at 10:18 am
naimish_2005 (3/22/2009)
I got this software from online sharing website.
??????
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
March 22, 2009 at 7:42 am
Paul Randal (3/22/2009)
Yeah - forgot to put a smiley in there 🙂
🙂 I was worried there for a moment
For a 2576 error, the only time the first IAM page...
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
March 22, 2009 at 7:33 am
I've got a small collection of SQL books (10 in total). Disclaimer: Some were given to me by their authors, some are to be given away at usergroup meetings.
These aren't...
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
March 22, 2009 at 7:21 am
Paul Randal (3/22/2009)
Because I wrote the code.
😀
Maybe I should have asked how I could tell that from that error, not having your unique advantage. 😉
It's also documented 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
March 22, 2009 at 6:48 am
Paul Randal (3/21/2009)
These errors indicate that the first IAM page for an index does not have an entry in sysindexes. This commonly occurs when...
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
March 22, 2009 at 1:59 am
Jeff Moden (3/21/2009)
[font="Arial Black"]E. Using DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a database[/font]
Or, since this is 2005, sys.db_db_index_physical_stats and ALTER INDEX ... REBUILD/REORGANISE
Both showcontig 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
March 22, 2009 at 1:58 am
RBarryYoung (3/21/2009)
#1 depends on how often you will use these 3 different vehicle types at the same time, versus how often you will want to use them separately
Also how similar...
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
March 21, 2009 at 11:20 am
These look like homework/interview/exam style questions. Are they?
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
March 21, 2009 at 9:30 am
plavec (3/21/2009)
query = viewim trying use indexes on tables use from view.
datamodel is strong that may be email will be better
Then please post the definition of the view, the definitions...
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
March 21, 2009 at 9:26 am
""Sameer"" (3/21/2009)
If you have questions about these tables, please contact the instructor for clarification.
Please contact the instructor? Are you asking us to do your homework for you?
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
March 21, 2009 at 6:38 am
achleshsoni (3/21/2009)
A lot of things could be the cause like memory pressure, poor plan reuse, auto update stats, reindexing, ddl etc.
None of the things you list there will cause...
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
March 21, 2009 at 4:37 am
It's not necessarily one query. It may be that there are a number of queries all using excessive CPU.
Check sys.dm_exec_requests to see what's currently running and what cpu they've useds....
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
March 21, 2009 at 2:59 am
I was wondering why there were so few posts lately... I haven't seen more than 4 pages in any of the 'recent posts' options for at least a week.
This morning,...
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
March 21, 2009 at 2:50 am
Viewing 15 posts - 40,216 through 40,230 (of 49,552 total)