Viewing 15 posts - 24,241 through 24,255 (of 49,552 total)
Table definition (create table statement), index definitions (create index) and execution plan 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
August 11, 2011 at 2:59 am
ajit_padhan (8/11/2011)
Could you please fwd if you have any dumps of 70-448. If so it would be great if you can send the doc to my apadhan@rediffmail.com id.
Dumps are cheating....
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
August 11, 2011 at 2:48 am
drew.georgopulos (8/10/2011)
i was trying to avoid the overhead i thought i saw in the execution plan, but something you said piqued my curiosity:
could it be possible to...
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
August 11, 2011 at 2:43 am
If the data file has enough free space in it to accommodate the new data, it won't have to grow. Since you say the mdf is larger than the ldf,...
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
August 11, 2011 at 2:40 am
No.
Please go and read the article that I linked for you over at SQL Team.
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
August 10, 2011 at 2:37 pm
With a read only database no locks are taken anyway.
Please run this and post the results.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
August 10, 2011 at 1:53 pm
You can't depend on a clustered index to return data in a specific order without the order by. With the order by and the index, SQL will be able to...
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
August 10, 2011 at 1:53 pm
Ninja's_RGR'us (8/10/2011)
Ok, building a table... I just thought this would make a darn good point in the conversation for people reading this thread :Whistling:
It's 10pm here. Not doing any...
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
August 10, 2011 at 1:42 pm
Ninja's_RGR'us (8/10/2011)
...and which one does auto_update stats run?
None of them. All of those are manual stats updates
As for 'which behaviour does auto update have', well, is the SQL Server there...
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
August 10, 2011 at 1:32 pm
What happened to the full backups? A differential backup cannot have run unless a full had already run, so there must be one somewhere.
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
August 10, 2011 at 1:29 pm
A restore sequence must always start with a full backup. All the differential has is the extents modified since the full. It's not restorable on its own.
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
August 10, 2011 at 1:13 pm
Ninja's_RGR'us (8/10/2011)
Paul Randal (8/9/2011)
Sounds like memory corruption of a log block changing 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
August 10, 2011 at 12:23 pm
Err, dunno, what are you trying to calculate?
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
August 10, 2011 at 12:06 pm
Ninja's_RGR'us (8/10/2011)
sp_updatestats AND updatestats X keep the current sampling rate
UPDATE STATISTICS TestingRangeQueries idx_TestingStats WITH SAMPLE 50 PERCENT
DBCC SHOW_STATISTICS(TestingRangeQueries, idx_TestingStats) WITH STAT_HEADER
-- Rows = 1000000, Rows Sampled = 498191. Close...
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
August 10, 2011 at 11:56 am
doug 40899 (8/10/2011)
Ok so I was told just a moment ago that both hour and minute would need to be included in my SP. What's the syntax for that?
With 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
August 10, 2011 at 11:43 am
Viewing 15 posts - 24,241 through 24,255 (of 49,552 total)