Viewing 15 posts - 20,416 through 20,430 (of 49,552 total)
Kim Killian-SiteDataView (2/9/2012)
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
February 9, 2012 at 2:35 pm
shawnjohnson (2/9/2012)
USE DBA_DB_COPYGO
ALTER TABLE [dbo].[XXX] DROP CONSTRAINT XXX_PK WITH (MOVE TO FG_NEW) ;
GO
ALTER TABLE [dbo].[XXX] ADD CONSTRAINT XXX_PK PRIMARY KEY(RateKey) ;
GO
That leaves a small gap in which duplicate data can...
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
February 9, 2012 at 2:27 pm
Did you run more than once and discard the first results (plan and data caching)? Did you run multiple times and average the times (especially elapsed time does vary due...
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
February 9, 2012 at 2:23 pm
bvsc (2/9/2012)
First It will look into the page where Location = 'MyLocation' stored..
From there it look 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
February 9, 2012 at 12:39 pm
Nataraja Sidgal (2/9/2012)
Change the recovery model from simple to full or full to simple - this will reset all the bitmaps.
Changing recovery models won't affect the differential bitmaps, the mechanism...
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
February 9, 2012 at 12:07 pm
bvsc (2/9/2012)
As LID is the Primary Key I wanted to make sure LID be the first in the where clause.
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
February 9, 2012 at 12:05 pm
Check the *file* permissions and ownership, not the folder. The file permissions would have been changed when the database was detached, as documented http://msdn.microsoft.com/en-us/library/ms189128.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
February 9, 2012 at 10:29 am
I should also add that in the cases where there's other apps on the server (SSIS, IIS, etc) you'd probably want to reduce the max server memory.
In cases where there's...
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
February 9, 2012 at 9:49 am
They may well have increased it. MS Learning refreshed the exams every now and again.
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
February 9, 2012 at 8:49 am
Anything in the error log?
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
February 9, 2012 at 8:32 am
They do not sell email addresses. Steve has made that very clear a number of times
Something that has happened before is that people click on an article in the newsletter...
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
February 9, 2012 at 8:30 am
Actual row count is the sum of the rows affected across all executions. So if the operator affected 10 rows each time it executed and it executed 200 times, 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
February 9, 2012 at 8:26 am
logicinside22 (2/9/2012)
Congratulations Emmiejames...Can you tell us how many question they ask now in this exam?
It varies, the questions are selected at random from a pool, so there's no fixed number....
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
February 9, 2012 at 8:21 am
sqlzealot-81 (2/9/2012)
Will there be a situation for kernal memory pressure?
Yes, as an example when there's more than 8GB physical RAM and /PAE is on.
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
February 9, 2012 at 8:12 am
sqlzealot-81 (2/9/2012)
To my understanding not only outside SQL, even within SQL also, for an example: Extended procedures, CLR functions etc...right?
Nope, those are all part of the user-mode SQL Server process...
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
February 9, 2012 at 8:12 am
Viewing 15 posts - 20,416 through 20,430 (of 49,552 total)