Viewing 15 posts - 4,876 through 4,890 (of 49,571 total)
How many physical cores per processor? 6?
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...
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)
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....
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...
August 31, 2015 at 2:51 am
Please post the deadlock graph and the definitions for all procedures and tables mentioned in it.
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...
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...
August 30, 2015 at 10:42 am
Ed Wagner (8/28/2015)
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...
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...
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...
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....
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...
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...
August 28, 2015 at 3:50 am
Viewing 15 posts - 4,876 through 4,890 (of 49,571 total)