Viewing 15 posts - 16 through 30 (of 154 total)
I've used SQLVariant as an EAV when required to "Have the ability to add or remove columns from data objects without changing the data structure, and make sure the data...
April 3, 2016 at 4:32 pm
And why would you make a blanket statement like that?
Because as I said in the previous comment, shrinking logs should never be a matter of routine.
There's good stuff in...
June 1, 2015 at 4:49 pm
And it was going so well.
Features were being described that I could imagine myself using, and then I got to the bottom of the page.
Shrink logs.
Why? Why would you...
May 31, 2015 at 11:14 pm
I appreciate that this is an example for an exam, and learning how to PIVOT (and UNPIVOT) is important.
I haven't redone the performance testing recently, but from memory there was...
May 27, 2015 at 7:29 pm
Maybe a clarification is necessary.
WHY is shrinking the database weekly so bad?
Firstly, the database is likely to grow again throughout the week. Growing a database file can be an...
May 5, 2015 at 12:22 am
Just a really simple idea.
Try setting PAD_INDEX = ON and FILLFACTOR = 80 as an initial step.
It will grow the index fairly significantly but you'll avoid daily index rebuilds.
Jeff's suggestion...
May 3, 2015 at 10:49 pm
The shrink and regrow will result in these files becoming more and more fragmented.
All I can suggest is that you start providing statistics around the fragmentation of the database files...
May 3, 2015 at 10:42 pm
Just ran into this issue over the weekend on a user database (ID 16). We're running SQL Server 2012 (11.0.3128)
Fairly comfortable that we don't have corruption as I have run...
April 19, 2015 at 8:03 pm
For what its worth...
We have a redevelopment going on at the moment which is using GUIDs for all the clustered keys. Some of the data is generated through a distributed...
March 23, 2015 at 11:07 pm
Many years ago I found a comment by my boss in the code which read something along the lines of
-- Don't touch this code
-- It does fancy statistical maths on...
March 13, 2015 at 12:46 am
Well now I feel a little ashamed.
I put a duration as a time on a recent project. I had no idea the issues it would cause! We did encounter another...
February 1, 2015 at 5:43 pm
When we factor in our own desire to "progress" and "achieve", we see the issue with picking managers solely based on management skills. It creates a ceiling through which we...
December 10, 2014 at 2:51 pm
Chiming in a little late I know, but FWIW.
This comes back to a couple of rules that are surfaced very clearly in some of the Agile frameworks, but are still...
January 15, 2014 at 5:57 pm
Ultimately we will see more and more of this from the likes of LINQ and other ORM tools.
Admittedly these aren't particularly complex SQL most of the time, and we can...
November 13, 2013 at 7:33 pm
I've had many an argument with App Developers about how to access the data, and there's another rule I would like to suggest.
Don't try and sneak it in. You may...
September 24, 2013 at 1:07 am
Viewing 15 posts - 16 through 30 (of 154 total)