Use Int Identities where you can. Make them a primary key, and build a proper relational database with enforced foreign keys and then you wont have data integrity issues. If your entity has an attribute that is unique: create a Natural Key. Using ISBN as the key wouldn't be a good idea if its repeated […]
2005-01-18
Okay, next time we have a sophisticated discussion at the lowlands of a language, it should be in German. I'll stick to my school english and avoid slang.
2005-01-12
Comments posted to this topic are about the Question of the Day for 29 Oct 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=376.
2004-09-23
1 reads
Peter,Thank you very much for your quick reply. Your solution is close I think, but I will need to do some testing on it to see if it can be adapted. Your solution gives the number of overlaps per day. I need to find the number of overlaps for any given time period during that […]
2004-07-20
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-06-25
Yikes, glad I'm not working in that environment! I would hate to have to do this but... you could write a simple VB app to put/save a file into a blob field in the database. Then put the VB app on the server and client. When you need to copy files put them in using […]
2004-01-28
2 reads
"Everything is fine apart from the fact that i get an error message when creating a linked server from another SQL 7 cluster server to one of the nodes in the SQL 2000 cluster."What do you mean creating linked server to one of nodes? I assume you try to create linked server to one of the […]
2004-01-14
Temporary stored procedures with # are local and are visible only to the connection. Therefore, when you create the temp sproc, the connection can access it, even though you're using dynamic SQL, which creates the sproc in a totally different batch. Temporary tables using # are local in scope, but that's not to the connection, […]
2003-12-19
1 reads
That's what I really hated when I was professionally developing. Commonly you don't have the time to implement an efficient solution, but rather an effective one. It's was one of the reasons why I quit my job. Now I have much more time to develop what I want to (don't know if my solution got […]
2003-12-16
quote: I was mistaken. We use this process for two main reasons: 1. If we have to change NULL to NOT NULL 2. For SQL Server 6.5 Boxes. I overlooked the "ADD" part... CREATE TABLE #Test( Id int NULL) INSERT #Test DEFAULT VALUES UPDATE #Test SET Id = 0 WHERE Id IS NULL ALTER TABLE […]
2003-11-18
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers