Viewing 15 posts - 4,621 through 4,635 (of 6,486 total)
The first error you got is usually a symptom of a rather massive memory leak (I kind of recall seeing it associated with an out of control virus scanner). ...
February 21, 2008 at 10:57 am
As to your quarters: I'd personally store the quarter info as a datetime (say - either the first or the last day of the quarter in question), and "reverse...
February 21, 2008 at 10:42 am
Like Steve mentioned - without an understanding of what you intend to DO with those numbers it's hard to say what's "right".
What can be said though it that...
February 21, 2008 at 10:37 am
Our appendix put systems (and apps on said systems) into a "tiered" system. Tier I - drop everything at all times. Tier II - urgent, Tier III "18 by...
February 21, 2008 at 10:25 am
The big issue with the "make everything generic so that the data provider can change" is that pretty much invariably - your performance will go right to the sewer. ...
February 21, 2008 at 10:09 am
Well - yes. However when you do that - you then need to go into manually doing pretty much all of the rest of the project (meaning you will...
February 21, 2008 at 9:52 am
stevecurrey (2/21/2008)
SELECT
months.monthid,
months.month,
months.realmonthid,
isnull(SUM(invoices.cinvoicesubtotal),0) AS Total,
isnull(clients.clientname,'')
FROM ...
February 21, 2008 at 9:45 am
The secondary aspect to response time is how long (on average) it takes for the problems to initially be discovered. Our standards were "call back within 15, connected and...
February 21, 2008 at 9:36 am
From googling that error - that seems to be a permissions error (outside of SQL Server). Meaning - more likely than not the SQL Server Service account OR...
February 21, 2008 at 9:14 am
Again - being tentative here. My understanding is that "out" is only to be used when the first argument is a view or table. Anything T-SQL there will...
February 21, 2008 at 8:28 am
As John mentioned - Cascade delete entails having a foreign key constraint (which means that every record in the child table MUST be related to something in the parent). ...
February 20, 2008 at 6:07 pm
What does the Event log show you?
The cluster service logs rather specifically what it's trying to do (system log, not app log). Did it even detect an...
February 20, 2008 at 5:59 pm
I have to be careful about this time of the day. Things are still eloquent in the peabrain - but they kind of come out as "just ditch...
February 20, 2008 at 3:27 pm
As to creating the root - you need to UNION it in.
it looks something ugly like:
SELECT 1 as Tag, NULL as Parent,
...
February 20, 2008 at 2:40 pm
Viewing 15 posts - 4,621 through 4,635 (of 6,486 total)