Viewing 15 posts - 36,991 through 37,005 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic772119-147-1.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
August 17, 2009 at 1:49 pm
rjv_rnjn (8/17/2009)
GilaMonster (8/17/2009)
I saw a case just today. Client's DBA role had been outsourced (to a local company).Wouldn't that be like getting a contractor on-board?
No. Getting a...
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 17, 2009 at 10:19 am
RBarryYoung (8/17/2009)
GilaMonster (8/17/2009)
ta.bu.shi.da.yu (8/17/2009)
For instance, I was asking and saying a lot of dumb things about self-joins and outer joins a few days ago in another thread... 🙂
Those weren't dumb...
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 17, 2009 at 9:55 am
I saw a case just today. Client's DBA role had been outsourced (to a local company). The person responsible for all of their admin is just about straight out 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
August 17, 2009 at 9:50 am
Silverfox (8/17/2009)
Wow, I didnt realise there was a difference between a Consultant and a freelancer, you almost make freelancer sound like a bad word :crying:
No such insinuation was intended. Sorry...
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 17, 2009 at 9:03 am
Jeff Moden (8/17/2009)
Heh... yeah, but being the responsible person you are, I'll bet you went back and fixed it as soon as you realized the mistake.
He went 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
August 17, 2009 at 8:57 am
Look up the DMV in SQL Books online, see what the parameters are, pick the ones that are suitable for what you want to do.
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 17, 2009 at 8:52 am
dr_csharp (8/17/2009)
I mean putting DESC for every part of order by !
If you want to order by both descending, that's how it has to be done. If you specify
ORDER BY...
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 17, 2009 at 8:37 am
ta.bu.shi.da.yu (8/17/2009)
For instance, I was asking and saying a lot of dumb things about self-joins and outer joins a few days ago in another thread... 🙂
Those weren't dumb questions, 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
August 17, 2009 at 8:32 am
Brandie Tarvin (8/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
August 17, 2009 at 8:32 am
Silverfox (8/17/2009)
Not quite sure I understand how that works. Are you saying that you take books with you, based on a certain requirement.
If I'm going to do say an...
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 17, 2009 at 8:30 am
Since you're using SQL 2005, use the sys.dm_db_index_physical_stats view rather that ShowContig. Since it's a view, you can add a where clause to the queries to look for certain fragmentation...
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 17, 2009 at 8:12 am
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
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 17, 2009 at 8:11 am
Can't see any reason why it won't work, unless all the rows have the same value for Date.
Table definitions and sample data? (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
August 17, 2009 at 8:11 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic771724-338-1.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
August 17, 2009 at 8:07 am
Viewing 15 posts - 36,991 through 37,005 (of 49,552 total)