Viewing 15 posts - 4,336 through 4,350 (of 49,571 total)
Depends if they're linking to or republishing. If they're linking, there's no plagiarism there, that would be like saying we can't link to Books Online from blogs.
If they're reposting the...
November 9, 2015 at 11:16 am
GabyYYZ (11/9/2015)
Okay, now that I've click-bated the MVP's, knowing full well the answer is "It Depends"
Yup, it does. Hence you'll get n different opinions in x posts (where n >=x)
I...
November 9, 2015 at 11:13 am
Extended stored procs don't typically show useful wait info, because as soon as the extended proc starts to run, it's outside of the SQL scheduler control. You'll probably see a...
November 9, 2015 at 11:05 am
Is the instance running on the active node?
What errors are shown in the SQL error log?
November 7, 2015 at 11:24 am
Sure. Speak with your VM admin about how the physcal NUMA nodes are mapped. The later versions of VMWare handle NUMA config.
As for cost threshold, 5 (the default) is stupidly...
November 6, 2015 at 8:30 pm
For that you either need a unique index on a computed column (A Coalesce of the two would work in this case), or a filtered index.
November 6, 2015 at 5:03 pm
In general, you want something like the number of physical cores in one NUMA node, 1.5* that or 2* that. The idea is that you don't want queries paralleling across...
November 6, 2015 at 3:49 pm
If you've been working with SQL Server for a few months, it's far too early to specialise. Learn the basics of your job for now. Once you can handle off...
November 6, 2015 at 11:27 am
Is that once an hour query going to affect performance for the part of the hour it's not running?
Let's say the once an hour query runs for 5 minutes. Does...
November 5, 2015 at 10:17 pm
So keep tuning resource-intensive queries until they stop complaining.
It's often not the query with the highest reads per execution, but the one that uses the most resources in a unit...
November 5, 2015 at 9:28 pm
If an object is added with a filegroup specified, then it goes into the files in that filegroup. Probably all of the files in that filegroup. Google "proportional fill algorithm"...
November 5, 2015 at 2:30 pm
Yes, a function on a column in the where clause means SQL scans the table, but if you need to filter on the length of a column, there aren't...
November 5, 2015 at 11:32 am
If you want to check the length of a string and filter on that length, then LEN works fine. Why are you looking for an alternative?
November 5, 2015 at 11:06 am
Viewing 15 posts - 4,336 through 4,350 (of 49,571 total)