Viewing 15 posts - 6,721 through 6,735 (of 22,211 total)
You either have to make the connection between the two using a piece of software, or, you need to export to a shared resource and then import from that shared...
February 19, 2015 at 4:51 am
Yep. Apply the latest service pack. It also applies to Express. It's the server properties that tell you what version the server is on and that's what counts for the...
February 19, 2015 at 4:49 am
shane.green 1227 (2/19/2015)
February 19, 2015 at 4:23 am
Lynn Pettis (2/18/2015)
The party is starting at the TitD. Be careful where you walk, you don't want to step on the single digit midget!
Yeah, but now you even start...
February 19, 2015 at 4:19 am
Lynn Pettis (2/18/2015)
... Mark one off, 9 days on the calendar to go. 9 days on the calendar to go, 9 days to go, ...
SINGLE DIGITS! WHOOOOOP!!
February 19, 2015 at 4:17 am
Yeah, if you're filtering, you need a clustered index. That's pretty standard. And, it should be the most common access path to the data. Where possible you should also look...
February 18, 2015 at 2:46 pm
Scott already said. You have two processors with 10 cores each. One has NUMA enabled and one does not. Two is the safest bet. I'm not a hardware expert, so...
February 18, 2015 at 2:44 pm
Local variables versus hard coded values versus parameters, you could be seeing parameter sniffing in action. The hard coded values will take an accurate measure of the statistics. The parameters...
February 18, 2015 at 2:39 pm
Maybe I missed the .sql on the second one. It had the standard name for a window. My bad.
February 18, 2015 at 2:36 pm
Is it possible it's coming in as read only? I work with various source control systems all the time and I'm not seeing a similar issue.
One difference between the two...
February 18, 2015 at 11:36 am
Compile time for the query and time to load everything into memory. Those are pretty standard costs that affect many queries the first time they're run.
February 18, 2015 at 11:24 am
On a side note, make sure you change the Cost Threshold for Parallelism to something other than the default. That's going to affect how your processors get used in as...
February 18, 2015 at 11:21 am
I would not look to replication as a DR or HA solution. It's mainly for data distribution for reporting, stuff like that.
Then, you need to break down HA and DR...
February 18, 2015 at 11:20 am
Oh, and I wouldn't just do something to a table without consulting with the developer. If I have to show them the before and after execution plans, resource use and...
February 18, 2015 at 11:13 am
Since neither of you are sure if the cluster will improve or hurt performance, I'd suggest an experiment to find out. The real question is, from the heap, are they...
February 18, 2015 at 11:12 am
Viewing 15 posts - 6,721 through 6,735 (of 22,211 total)