Viewing 15 posts - 31 through 45 (of 72 total)
Running solely in (ram) memory scares me as well, and almost dictates that you operate as a multi-node system.
I would hope that there is a "save to disk" operation that...
July 26, 2011 at 9:04 am
Agree with that as well I do.
Often what they say they want is not really what they want, or is incomplete. I will always let the person giving the specs...
July 25, 2011 at 9:50 am
I definitely agree with that. I have worked with too many people who design and finalize based on correct data being present, and have very little or no error prevention/handling.
Looking...
July 25, 2011 at 9:29 am
Ninja's_RGR'us (7/24/2011)
July 25, 2011 at 9:04 am
Good call with the Trained Habits.
I can relate very much to this as I do most of TSQL by hand (in Sql Query Analyzer) and my coworkers (who are more...
June 22, 2011 at 9:34 am
What I did learn today; you can use a string literal to do an alias, but you probably shouldn't because someday it will be deprecated.
From my experience, it is a...
June 21, 2011 at 10:52 am
The SELECT statement may be part of DML, it all depends on the context and who makes the decision. A straight Read-Only SELECT does no manipulation so it would be...
May 31, 2011 at 8:42 am
rothco (5/27/2011)
A good starting point in...
May 27, 2011 at 10:59 am
I have seen and have used JOINS based on multiple conditions
SELECT c.LastName, c.FirstName
FROM Contacts c INNER JOIN Areas a
ON c.PostalCode = a.PostalCode
AND c.City = a.City
WHERE c.TaxesPaid = 1
another...
May 18, 2011 at 9:54 am
If I still had the code available, I would share...
We had a dilapidated 200 box that would not delete the old backup files on an external drive... Needless to say...
April 19, 2011 at 10:03 am
I actually was going to look at it until I saw the mal-formed URL, and then I read it and wondered how much did he have to pay for kiss.com.......
April 1, 2011 at 8:53 am
What are the datatypes you are selecting?
Are you ordering the results; and if so, is that field indexed?
March 25, 2011 at 8:43 am
I will remember this method for future usage, could have used it a few months ago. Most of the data I work with is from various text editors and I...
March 18, 2011 at 10:31 am
Our #1 server is a file and db server for approximately 450 db-driven websites. Sql 2000 on a Win2003 Web edition, maxed at 2GB memory.
Our new file/db server which will...
March 11, 2011 at 9:11 am
I would probably start by installing an MS SQL Client such as the express version of SSMS and see if the client application can communicate with the SQL Server
March 9, 2011 at 9:37 am
Viewing 15 posts - 31 through 45 (of 72 total)