BenWard

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 264 total)

RE: The Case of the Shrinking CFO, err Database

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

August 17, 2015 at 3:45 am

#1820373
RE: Architecture for Auditing

+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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

June 4, 2015 at 1:51 am

#1802899
RE: How Virtualized?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 8, 2015 at 7:34 am

#1796569
RE: How Virtualized?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 8, 2015 at 2:15 am

#1796477
RE: SQL Service not starting after Windows Upgrade

When you look into the windows event viewer, what error message are you getting?
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 24, 2015 at 5:38 am

#1785917
RE: Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

chris.puncher (3/18/2015)
Ben and jhood,
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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 18, 2015 at 9:36 am

#1784812
RE: Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

ouch! Fortunately I've been able to avoid using recursion in my environment 🙂
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 18, 2015 at 6:29 am

#1784739
RE: Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 18, 2015 at 6:13 am

#1784734
RE: The Worst Comments

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 13, 2015 at 5:15 am

#1783824
RE: Data Breach Danger

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 12, 2015 at 6:17 am

#1783551
RE: Building Small Habits

Gary Varga (2/26/2015)
Hungarian Notation is one of those things that seems like a good idea. Having dealt with examples like a variable in a statically typed language called b[BusinessTerm] which...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 26, 2015 at 4:53 am

#1780186
RE: Building Small Habits

Gary Varga (2/26/2015)
BenWard (2/26/2015)
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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 26, 2015 at 4:18 am

#1780168
RE: Building Small Habits

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 26, 2015 at 3:24 am

#1780151
RE: I'm arguing with BCP

Oooh clever solution!
Thanks for your help 🙂
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

December 29, 2014 at 7:31 am

#1766768
RE: I'm arguing with BCP

Ah yes I did mean columns.
silly mistake there!
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

December 29, 2014 at 1:27 am

#1766670

Viewing 15 posts - 16 through 30 (of 264 total)