Viewing 15 posts - 541 through 555 (of 1,413 total)
I think you need to describe a little more exactly what you want to accomplish (or someone better with Oracle than me perhaps could help). Do you want your stored...
July 25, 2005 at 2:39 pm
I would be very interested in seeing that reference. In any case I do not think any difference in search performance would be noticable in almost any scenario you could...
July 25, 2005 at 2:35 pm
You will not see this error in SQL Server 2005, since SQL Server 2005 does not have Enterprise Manager. The new replacement for EM (and QA) is called SQL Server...
July 25, 2005 at 2:26 pm
There is no technical reason to define the columns in any specific order (in fact, in a truly relational DBMS there is no such thing as an order of the...
July 25, 2005 at 5:27 am
Is the table owned by owner1 or some other user (like user2)? It sounds like it is owned by user2, and in that case the ownership chain would be broken...
July 25, 2005 at 1:31 am
The artificial limit that SQL Server sets is 32,767 databases per instance of SQL Server. You should however stay far away from that. I have not seen any real guideline...
July 25, 2005 at 1:29 am
Well, it installs on systems that do not have the .Net Framework installed already. But then it would be installed by the SQL Server 2005 installation. Note that it is...
July 13, 2005 at 8:56 am
Even though I have some understanding of regular expressions, I did not write that one myself. I think I found it at Regular-Expressions.info, a very good resource.
July 13, 2005 at 8:53 am
Very true, and that is one of the reasons I see why it is important for more or less every DBA to at least have a basic understanding of what...
July 13, 2005 at 8:51 am
One thing that made me prick up my ears was the MS Tech Ed presentation that said that the CLR does not site on top of the OS and SQL...
July 13, 2005 at 3:53 am
I feel the same way. I am just as much a developer as I am a database professional, so I think I will have a very good perspective of this...
July 13, 2005 at 3:53 am
Hmm, not sure I quite understand what you mean with the "why" when a DBA alters a table. Anyway I do not see how CLR Integration would change any of...
July 13, 2005 at 3:50 am
If you have a bog standard SQL2000 function, for the sake of argument it multiplies one argument by another and you write a query that applies that function to records...
July 13, 2005 at 3:41 am
There is no way you can configure SQL Server to automatically notify your app for these events. Your best bet is to have your app, either externally or via some...
July 13, 2005 at 3:32 am
Nothing special there as far as I can see. Perhaps there are triggers that deletes the row?
July 8, 2005 at 3:52 am
Viewing 15 posts - 541 through 555 (of 1,413 total)