Viewing 15 posts - 16 through 30 (of 263 total)
Interesting technique, this might prove useful thanks.
I feel that the number of situations in which this will help are quite limited though... How many people have 120GB databases that really...
August 17, 2015 at 3:45 am
+1 for this. On 2 separate occasions in my relatively short career (<10 years) I've seen system access and audit logs that appeared to have been tampered with after a...
June 4, 2015 at 1:51 am
A thought just occurred to me.
It may not be a straight case of moving physical servers over to virtual...
Here, we have a datacentre license for windows so provisioning a...
May 8, 2015 at 7:34 am
we have, at last count, over 80 SQL instances. I don't know what they all are but these are what I do know;
Physical db servers (MSSQL):
3 bi database servers, 2...
May 8, 2015 at 2:15 am
When you look into the windows event viewer, what error message are you getting?
March 24, 2015 at 5:38 am
chris.puncher (3/18/2015)
I fell foul of too many articles along the lines of "Look at CTEs, they're fantastic" which never mentioned possible performance issues. That was the reason I...
March 18, 2015 at 9:36 am
ouch! Fortunately I've been able to avoid using recursion in my environment 🙂
March 18, 2015 at 6:29 am
Personally, I've not found CTEs themselves to be slow. I've found that enormous exceedingly complex queries over huge datasets can be slow. The thing is, in order to write those...
March 18, 2015 at 6:13 am
Stuart Davies (3/13/2015)
Worse one I've come across "If you need comments to understand this - you shouldn't be looking"
Guilty....
Here's an extract from some system documentation I wrote a few years...
March 13, 2015 at 5:15 am
I see this as history repeating itself. Only instead of physical theft of valuables, it's virtual theft of intangible values.
I think of the late 1800s where railroads in the west...
March 12, 2015 at 6:17 am
Gary Varga (2/26/2015)
February 26, 2015 at 4:53 am
Gary Varga (2/26/2015)
BenWard (2/26/2015)
February 26, 2015 at 4:18 am
About 4 or 5 years ago at the start of a new project we decided to start prefixing our object names with their type. For example; SomeObjectName became tblSomeObjectName for...
February 26, 2015 at 3:24 am
Ah yes I did mean columns.
silly mistake there!
December 29, 2014 at 1:27 am
Viewing 15 posts - 16 through 30 (of 263 total)