Viewing 15 posts - 3,151 through 3,165 (of 49,571 total)
rodjkidd (4/29/2016)
SQLBits - make sure to say hi ... It will be good to catch up with the usual mob (Gail, Steve, Grant etc... 😉 )
Errr....
http://sqlinthewild.co.za/index.php/2016/04/26/upcoming-conferences/
April 29, 2016 at 8:02 am
Start by doing a full workload performance test, or you'll likely be posting a similar thread to this afterwards: http://www.sqlservercentral.com/Forums/Topic1781716-3412-1.aspx
Once you've got all the testing done and fixed the queries...
April 29, 2016 at 6:07 am
BLOB_EATER (4/29/2016)
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
April 29, 2016 at 5:58 am
Brandie Tarvin (4/29/2016)
I'm a bibliophile. I love books. But we're in the middle of an upgrade and I...
April 29, 2016 at 4:30 am
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
April 29, 2016 at 3:57 am
Take a full or differential backup.
April 28, 2016 at 3:58 pm
Phil Parkin (4/28/2016)
Does anyone have The Ball today?
Mine just reads "Maybe"
April 28, 2016 at 3:57 pm
N_Muller (4/28/2016)
Or is it a hit and miss in terms of queries that perform poorly.
This.
If there was only a couple of known patterns of queries that always got performance degradations,...
April 28, 2016 at 3:57 pm
Yup, cardinality estimator changes.
Most queries show a performance improvement, or stay the same under the new CE. A smaller number show degradations. It's why I tell people they MUST test...
April 28, 2016 at 11:23 am
Luis Cazares (4/28/2016)
SELECT count(1)
FROM sap_plant
where lastupdate >= @StartDate
and lastupdate < @EndDate + 1; --No need to change the value from the 'parameter'
I'd recommend against using that "date...
April 28, 2016 at 8:26 am
Jeff Moden (4/28/2016)
river1 (4/27/2016)
I have a proc running every day that reorg/rebuild indexes. If reorg then also updates the stats
Ah, careful now. Specifically, REORG does NOT rebuild stats. ...
April 28, 2016 at 8:14 am
Eric M Russell (4/27/2016)
at this point you might as well use symmetric key encryption instead of hashing.
I disagree. If you're using symmetric encryption and the key is compromised, all...
April 27, 2016 at 1:16 pm
Don't guess as to the cause of a problem. You need to do enough analysis and investigation to be sure of the cause before you decide on a solution. Otherwise...
April 27, 2016 at 1:11 pm
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
April 27, 2016 at 5:12 am
SHA2_512 is the strongest hashing algorithm on SQL 2012. Use that unless you have a good reason to use a weaker algorithm. Edit: and salt it.
SHA1 has been out of...
April 26, 2016 at 3:15 pm
Viewing 15 posts - 3,151 through 3,165 (of 49,571 total)