It does appear to be a "known" issue. It also says fixed in SP1 c.. The decision tree viewer in the DHTML viewer samples was broken by a last...
Thanks Satya. I'll check the AS2005 newsgroups. This is nothing custom and not an upgrade or anyting. We've followed the steps exactly as the help...
From my experience, unique yes, clustered is not required. But if you are going to use a clustered index, use it at the time of the snapshot. Your...
We also use spotlight (for over 2 years, on multiple servers, multiple sql versions) and have never seen that behaviour. Perhaps there is some...
Glad you found it. My next suggestion was going to try your computer on a different network drop and a different computer on yours. Seems like you...
We are just starting to get into the 2k5 mining tools. (and are very eager to keep going). We can create a project, we can run a project, however, as...
As mentioned, this is a huge subject and performance issues can be for a huge number of reasons. We are continue to work to make our performance...
Way to go!!! I only seem to make it here once a month or so, unlikely I'll ever get near that number. Hopefully I can pick it back up again (getting...
Pavan, what issues are you having with the 'getting the cubes'? We had a few cubes in 2k and were only able to move one of them using the migration...
Here is a link for the full job posting http://www.recruitingsite.com/csbsites/teligencecareers/JobDescription.asp?JobNumber=145776 Here are some...
Not sure what you mean, but if you're talking query then I think so (added left join since you may not have figures for those time frames) select...
In our place we have a manager for HR related items and a Team Lead for the rest. Our manager is responsible from an HR perspective for 10 people (4...
Not sure, but try this select t1.date, t1.amount, t1.series, sum(t2.amount) from MainTable t1 Join MainTable t2 on t1.series = t2.series and...
Exists is almost always faster - this of course is dependent on the index(es) in the table contained in the exists clause. In some cases, depending...
Most of this would work as is, except the date calculation. Not knowing for sure how your dates are stored, I'm not sure totally how to do it. If...
I think this is a great idea. For those concerned with safety, it would be easy to decline an interview. As for pictures, the only ones I have...
Way to go Derrick! The best way to become fluent in a language is emmersion. So if you have the basics, you could go at any time. I used to be...
I like it! Chris
Have you considered putting this into an sproc? Then having the DTS call the sproc?
What are you looking for? Auditing logins? Auditing modification txns? Auditing selects?
Separate names with a comma.
