Viewing 15 posts - 1 through 15 (of 41 total)
Alex Gay (9/7/2012)
I've got to that age where as long as it works, reliably and consistently I'm happy.
Same with me. At work we have recent Lenovo equipment which works quite...
September 10, 2012 at 4:40 am
The question is quite old now, but I just see it right now.
I was creating a schema a while ago which you could find in the attachment along with the...
August 25, 2012 at 8:52 am
"Cloud" sounds to me to be a great marketing word. It could mean a lot of things or services but what they have in common is transferring private or company's...
August 20, 2012 at 8:24 am
Graham-1036457 (11/13/2011)
We know that Stored Procedures names are prefixed with sp_, but is there a prefix convention such as tbl_...
November 16, 2011 at 5:23 am
I had two at work, but gave one back as it did not work for me as I suffered from headaches and eye pains due to that. One large monitor...
October 28, 2011 at 6:03 am
smolak (5/20/2011)
1) Process bugs
2) Data related bugs
3) Misunderstanding user requirements
I don't believe that "the lack...
May 25, 2011 at 8:39 am
roger.plowman (5/25/2011)
Users never know what they want. IT doesn't know the user's job, so *they* don't know what the user wants either.
I guess getting a very clear and detailed picture...
May 25, 2011 at 8:01 am
CELKO (11/26/2010)
Older, experienced SQL programmers use the original syntax so they can see n-ary relationships. ACCESS programmers have to do JOIN predicates in the ON clauses then filter in the...
December 10, 2010 at 7:32 am
karl-heinz (12/2/2010)
upps..thank you for your help, it works!
I was just thinking:
DROP Index table_name.index_name
also must be:
ALTER INDEX index_name ON table_name.index_name REBUILD;
but I was wrong...
In SQL Server index names must be unique...
December 2, 2010 at 7:01 am
Brigadur (11/23/2010)
Thanks Philipp for the nice poster! Really handyCheers
You are welcome!
November 23, 2010 at 2:45 am
Here you could find a poster about normalization:
http://www.tf-informatik.dk/FreeStuff/rettigNormalizationPoster.pdf
November 22, 2010 at 7:37 am
I guess you would receive more input if you give information about your hardware, SQL Server version and the time you mention as "forever".
A CROSS JOIN can be expensive...
November 15, 2010 at 8:44 am
Just fyi - you could also use BETWEEN instead of WHERE ... >= AND ... <=
November 10, 2010 at 5:39 am
You could also use a calendar table and fill it with the date ranges needed and join it in your queries.
November 8, 2010 at 8:00 am
Jeff Moden (11/1/2010)
What I'm even more concerned about is lost learning due to the fact that certain programs and formats are no longer available.
For long term storage anything in...
November 2, 2010 at 6:31 am
Viewing 15 posts - 1 through 15 (of 41 total)