Viewing 15 posts - 37,591 through 37,605 (of 49,552 total)
Meaning that can you answer questions in a forum at work? That's building your brand, and arguably your employers as well. Can you edit a presentation at work that you'll...
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 17, 2009 at 7:52 am
Tara (7/17/2009)
Read locks don't block other readers. If you have on updates, you shouldn't have any blocking
as i said most of the time we only do SELECTS on the databases...
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 17, 2009 at 7:36 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 17, 2009 at 7:17 am
Tara (7/17/2009)
drop table #emp
select distinct EMPID
into #emp
from vwEmp_act
where (place IN ('21','25','51') or (empcd = '1' and jobcode = 'Y'))
AND empflag = 'F'...
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 17, 2009 at 7:11 am
Tara (7/17/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
July 17, 2009 at 7:07 am
Maybe give Microsoft's customer support a shout. I've heard of a case where the rebuild says it succeeded but didn't, not sure why that could happen. Calling CSS will be...
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 17, 2009 at 1:10 am
You need to find the actual error. There's nothing much of use there. Go to the job step, go to the advanced tab, there's an option there to output 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 17, 2009 at 12:55 am
Why no primary keys?
With performance problems, the first place to look is the queries and indexes, not the hardware. These two articles may help you get started.
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 17, 2009 at 12:55 am
Google for 'index rebuild site:sqlfool.com'
When the results page comes up, click on the 'cached' link. Voila.
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 16, 2009 at 3:04 pm
JC (7/16/2009)
we are talking USAF here 🙂Government !
Ok, you didn't say so before.
Something I used to use to get past the bank's security (which may or may not...
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 16, 2009 at 2:18 pm
Because they rebuild all indexes every time they're run regardless of whether or not the index needs rebuilding. It's a waste of time and resources to rebuild an index that'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
July 16, 2009 at 11:55 am
Gaby A. (7/16/2009)
Gail, don't know how you managed not to snap at this person.
A great deal of patience and gritted teeth. I should have gone into more detail on my...
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 16, 2009 at 11:44 am
Personally I wouldn't use the maint plan rebuild unless it's a small database. Get one of the index rebuild scripts that only rebuilds if the fragmentation's excessive. There's one 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
July 16, 2009 at 11:16 am
Grant Fritchey (7/16/2009)
GilaMonster (7/16/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
July 16, 2009 at 11:14 am
Maybe....
Now I've got that out of the way, some details. Auto-update ensures that the stats will get updated once more than 20% of the table has changed. That's a large...
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 16, 2009 at 10:03 am
Viewing 15 posts - 37,591 through 37,605 (of 49,552 total)