Viewing 15 posts - 4,336 through 4,350 (of 49,552 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...
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
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...
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
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...
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
November 9, 2015 at 11:05 am
Is the instance running on the active node?
What errors are shown in the SQL error log?
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
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...
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
November 6, 2015 at 8:30 pm
To be honest, I've started to use full words for the time components. I've mixed up mm and mi one too many times.
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
November 6, 2015 at 5:30 pm
Luis Cazares (11/6/2015)
Steve Jones - SSC Editor (11/6/2015)
Luis Cazares (11/6/2015)
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
November 6, 2015 at 5:10 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.
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
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...
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
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...
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
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...
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
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...
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
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"...
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
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...
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
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?
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
November 5, 2015 at 11:06 am
Viewing 15 posts - 4,336 through 4,350 (of 49,552 total)