Viewing 15 posts - 16 through 30 (of 59 total)
>>>They can very easily take a grandparent->parent->child operation that would take 1000s of calls to the database in your scenario and turn it into one query.
In a long career...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
October 29, 2009 at 11:56 am
This solution is based on the premise that security is important enough to take the time to implement. If time is more important than preventing unrestricted access to the...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
February 7, 2009 at 1:06 am
Browser is IE 6 - Windows 2000 Server SP4 -- this is my machine for maintaining legacy applications.
My standard for application design is NOT to have to step outside to...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
February 5, 2009 at 6:25 am
Thank you, Phil Factor! I will be sure to keep the link to NET reflector where I can find it quickly. Now, can you explain those windows? ...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
February 5, 2009 at 5:52 am
What is the name for the window with horizontal scroll bar in which the code is presented? Text of article -- window with code -- more article text --...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
February 5, 2009 at 5:04 am
If your databases have many concurrent sessions and/or queries that touch millions of records, would you give up process threading on 8-processor machine to go to a VM where your...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
December 7, 2008 at 12:38 pm
So application developer A writes the CTE -- or the derived table -- then application developer B writes it slightly differently a month later in another application. Modularity? ...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
December 6, 2008 at 3:35 pm
The CTE is the way programmers get around not having database permission to create a view. Application programmers and "architects" who think "who needs a DBA?" write queries from...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
December 1, 2008 at 2:51 am
The people responsible for architecting the "solutions" for a business should be about the business' data primarily and about the tools/technology secondarily. (I was a statistical data analyst before...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
August 13, 2008 at 7:16 am
I think using Excel as the interface for selects from SQL Server is so much better than programming a dinky new interface. I'll save this article as a guide...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
August 12, 2008 at 10:07 pm
"... arguing that code reuse doesn't work.." -- I'm not sure whether that refers to stored procs useful for only one application in a database that supports more than one...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
August 4, 2008 at 6:03 am
Thank you, previous poster.
I would bet the author of the app that creates slow-running SQL who knows where (1) says "I would never let **users** run ad hoc queries against...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
July 31, 2008 at 8:11 pm
Which job role does the ER diagramming? The DBA job title **started** with ER diagramming 25+ years ago. Why should the DBA hand over ER diagramming to a...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
July 31, 2008 at 11:29 am
Of course a DBA works at the logical level. That's what ER diagramming is. Application developers who aren't at all familiar with ER diagramming? No wonder... ...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
July 31, 2008 at 10:48 am
A good DBA **is** the data architect because she understands ER, DBMS performance, and SQL Server sysadmin.
What? says the app developer, commit to a specific DBMS platform? ...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
July 31, 2008 at 10:00 am
Viewing 15 posts - 16 through 30 (of 59 total)