Viewing 15 posts - 6,736 through 6,750 (of 22,211 total)
I'd love to see the plan that indicates a missing index. I've had a hard time getting interesting plans out of the memory-optimized queries.
You can create indexes. There are non-clustered...
February 18, 2015 at 7:14 am
Selectivity is how unique any given value on a column or set of columns will be. This information is stored with the statistics for the index you create. The most...
February 18, 2015 at 5:48 am
Any Threadizens going to make SQL Rally before SQL Bits. I'll be at both (which means I'll miss Wednesday at Rally).
February 18, 2015 at 5:36 am
Jeff Moden (2/18/2015)
Steve Jones - SSC Editor (2/17/2015)
Grant Fritchey (2/17/2015)
Not mentioned is the OS. If I only have two drives, the OS on one and everything else on the other.
Any...
February 18, 2015 at 5:34 am
Not mentioned is the OS. If I only have two drives, the OS on one and everything else on the other.
February 17, 2015 at 1:39 pm
Then all I can suggest is the standard stuff. Make sure you're queries are filtering on criteria where there are indexes. Add indexes if necessary. Update the statistics, possibly using...
February 17, 2015 at 12:30 pm
Without the execution plan, nothing but vague guesses are possible.
February 17, 2015 at 11:28 am
Ed Wagner (2/17/2015)
Steve Jones - SSC Editor (2/17/2015)
February 17, 2015 at 11:25 am
I don't think there's a way to query Hadoop from SQL Server yet. I know they're working on it. In the meantime, there is a connector for SSIS.
February 17, 2015 at 9:30 am
Neither Full nor Differential backups will remove completed transactions from the log. You must use Log backups, not shrinking. In addition to Gail's link, here's another[/url].
February 17, 2015 at 6:57 am
Yeah, I'd think the person that just lost their work might be on board now.
It can be difficult to get across the idea of treating a database like code, but...
February 17, 2015 at 6:53 am
Start using source control for database development in the same way as app dev. That's the best way to get things done and you can easily recover from problems like...
February 17, 2015 at 5:20 am
Or extended events. You can also use those in 2008 and greater for monitoring.
February 17, 2015 at 5:18 am
Assume the right answer is always in the Perfmon Counters themselves and anything else is an interpretation on top of it and make allowances accordingly. Not a great answer, but...
February 17, 2015 at 4:46 am
The DMV is not the performance counter. It's just a view on top of them. It might not resolve in the same way as going directly to the performance counters...
February 16, 2015 at 4:24 am
Viewing 15 posts - 6,736 through 6,750 (of 22,211 total)