Viewing 15 posts - 45,916 through 45,930 (of 49,552 total)
Jeff Moden (7/6/2008)
I wonder how many questions they have on cursors now adays... If it's more than 5, I would flunk because I avoid them like the plague.
I don't actually...
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 7, 2008 at 12:05 am
That particular query shouldn't need tempDB space, as it has no query operators that require a work table. Sorts, hash joins, hash aggregates and other operators require space in TempDB....
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 7, 2008 at 12:03 am
Now we're getting somewhere useful.
Aprox how many rows would that query return? How many in the total table?
Ignoring covering for now (will get back to that once I have 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 7, 2008 at 12:02 am
Could you explain a bit more what kind of filtering you're trying 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
July 6, 2008 at 11:23 am
Vivien Xing (7/6/2008)
I think MVP is more valuable than the certificate.
And significantly harder to get. Plus it's about different things. MVP is about community involvement more than anything
Congratulations Gail!...
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 6, 2008 at 11:23 am
Ok, I have to ask. Why are you truncating and shrinking your log file?
If you don't care about being able to restore to a point-in-time, set the database into simple...
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 6, 2008 at 6:27 am
Is there any blocking? If you look at the results from profiler, are certain queries slow and other 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 6, 2008 at 6:19 am
Hmmm. Probably not. Sorry, I missed that it was the people using the 2000 box that were having problems.
Yup, is a good time for profiler. Also maybe start up perfmon...
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 6, 2008 at 4:22 am
I believe it is 1000, though I have not seen that officially confirmed and I don't know anyone who's received that. (Best I've done is 984 on a VB exam...
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 6, 2008 at 4:17 am
Jeff Moden (7/5/2008)
That's where you and I may differ... I don't ask questions that appear on the certification...
Nor do I.
What I mean is that is someone says 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
July 6, 2008 at 4:16 am
rbarryyoung (7/5/2008)
Secondly, to do anything with this, we need to see the table definitions and the table relationships.
And for performance problems, the index definitions are also very important....
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 5, 2008 at 12:22 pm
To clarify:
I do recommend that people get certified, but not because that it will not guarantee a job (it won't). But because in the process of studying for the cert...
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 5, 2008 at 11:21 am
bcp is a command line import/export tool. There are a multitude of command line options and switches. Books Online has a full list of all and some examples on usage.
Basically...
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 5, 2008 at 11:06 am
I have different ways I feel about certifications in different circumstances.
When I'm interviewing, I assume that the fact that a person has a certification means that he/she knows that area....
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 5, 2008 at 10:58 am
Doctor Who 2 (7/4/2008)
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 5, 2008 at 10:44 am
Viewing 15 posts - 45,916 through 45,930 (of 49,552 total)