Initially, I've got to say that I agree with alzdba and the others. For a long time, I have seen people claim that you must qualify object names with explicit owners to get plan reuse to work, but I've never seen anybody who was able to demonstrate the truth of this claim. I almost answered […]
2004-05-10
Tnx for responding, Victor. You say: You may be getting this error message...There are non-clustered indices. However, it does not happen always, and it happens not always with the same tas/db. Do you know why it happens occasionally seemingly without pattern?
2004-05-10
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-05-06
Do youo still have the physical files? or those were deleted also? If those exist, just do an attach DB. If the physical files disapeared, I don't see any way you can get that DB back.A sysadmin could have an anser for files deleted and how to restore them afterwards, though. Sorry about that and […]
2004-04-29
Bad database design is the real problem here and not a SQL Server limit. Look into adding audit columns for creation and modification dates.
2004-04-28
Hello, The reason for the difference is that first one is looking for -- 'smith' -- and the second one is looking for -- smith -- . The value that you put into the table is -- smith -- and the value that is in the variable is -- 'smith' --. The first query uses […]
2004-03-19
I have used the xmlbulkload function with a VB script to import xml to SQL. I think I saw a KB article at Microsoft about it. Look there.
2004-03-18
Not to be picky, but what are you trying to do? It isn't very clear (at least to me).
2004-03-11
2004-03-05
what method do you use to run the package? I use global variables to hold the details and set the connection first, if you run the package from dtsrun in a stored procedure you can pass the global settings in.
2004-03-03
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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