Viewing 15 posts - 4,876 through 4,890 (of 49,552 total)
How many physical cores per processor? 6?
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
August 31, 2015 at 6:59 am
I have three upgrades I need to do.
Server to Win 2012 R2
Desktop, currently Win 7, to Win 10 (nuke and reload)
Laptop, currently Win 8.1, to Win 10 (probably an...
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
August 31, 2015 at 6:23 am
Start with Perry's stairway, on this site, look at the left-hand menu, and Books Online (I hope I don't need to provide a link to that)
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
August 31, 2015 at 4:12 am
Without knowing what part of the world you're in, it's a little hard to recommend a 3rd party.
There's a lot of material available. Perry wrote a Stairway that's available here....
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
August 31, 2015 at 3:33 am
Don't use DTA, at best it'll over-index, at worst it could degrade performance.
The code needs to be tuned first, if it's written in a way that the query can'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
August 31, 2015 at 2:51 am
Please post the deadlock graph and the definitions for all procedures and tables mentioned in it.
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
August 31, 2015 at 2:49 am
Availability Groups should do most of that (though you'd still need to design a backup strategy to meet your business SLAs). If you've never designed or implemented a HA/DR solution...
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
August 31, 2015 at 2:48 am
Maybe, but it depends on a whole pile of things.
How the server is physically secured
How the server is configured
How SQL is configured
Server permissions
SQL permissions (server and database)
Custom permissions in 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
August 30, 2015 at 10:42 am
Ed Wagner (8/28/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
August 28, 2015 at 5:18 pm
Neither of those are bugs.
Tables are defined as unordered sets of rows. An ORDER BY on an insert affects the order that Identity values are assigned.
Order is something which...
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
August 28, 2015 at 5:02 pm
Lynn Pettis (8/28/2015)
IIRC, the THROW statement that was recently introduced also requires it be terminated by a semicolon.
Previous statement must be terminated. Can't recall offhand if the THROW...
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
August 28, 2015 at 12:08 pm
mar.ko (8/28/2015)
I don't care what anyone says, CTE's are temporary views
They're not. They are named subqueries.
If you consider them temporary views, you're going to keep running into situations where...
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
August 28, 2015 at 10:42 am
mar.ko (8/28/2015)
Honestly, that's kind of a dumb one....CTE's should persist for the duration of the procedure and be able to be referenced at any time.
That's not what a CTE is....
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
August 28, 2015 at 10:22 am
Kristen-173977 (8/27/2015)
Is this a scenario that could, however rarely, occur?
In theory, yes. Very unlikely, and very dependant on what indexes exist (the dup/missing rows can happen only on scans), but...
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
August 28, 2015 at 3:53 am
The one thing you should do is remove the extra log files. There is no benefit from multiple log files, SQL uses them in sequence.
Second, how many files depends on...
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
August 28, 2015 at 3:50 am
Viewing 15 posts - 4,876 through 4,890 (of 49,552 total)