Viewing 15 posts - 1,366 through 1,380 (of 2,640 total)
dtc is usually pretty good at putting up an error message which is why I didn't list it, however, anything is possible!
February 6, 2007 at 12:57 am
as I said, a conspiracy to change us to americanised english !! I've always found that keeping to the three date types works well, the other is odbc time. to...
February 5, 2007 at 7:34 am
vs performance? No contest I'm afraid. With the growing size of disks and adoption of SAN technology the bean counters look more and more at storage as something to be...
February 5, 2007 at 7:28 am
hmm - my simple tests showed no relation between results and actual profiler trace.
February 5, 2007 at 7:19 am
I can only generalise about maxdop settings as any given situation may vary!! On a 4 way dual core ( with no HT ) when I had parallelism issues with...
February 5, 2007 at 7:18 am
generally the default options on install of sql 2005 does not allow remote access, you must configure sql 2005 to allow this. Check in BOL under installation.
the other two are...
February 5, 2007 at 7:09 am
I don't know how many rows this query returns but I figure it needs tuning. Why it times out I've no idea, proably a high cost plan / and/or loading...
February 5, 2007 at 6:04 am
can't say I've ever used this feature, and having run a few samples not sure of what value it is.
I'm not aware of this being available in 2005.
February 5, 2007 at 6:00 am
there's also a few threads on msdn forums, some errors are fixed in sp1.
One suggestion is to change the data type of the column or add/remove nulls. Make it work...
February 5, 2007 at 5:52 am
I'd also try dbcc updateusage(0) in the database.
Are the collations all the same
February 5, 2007 at 5:47 am
I'm not aware that there is a sql server install of British English, part of the plot to replace s with z and make us all speak as if we...
February 5, 2007 at 5:45 am
if you're making use of linked servers you should have some idea of the most basic steps to check a failure!!
February 5, 2007 at 5:36 am
check your user has a valid login on the correct databsae on sql 2005 , make sure the 2005 is running in mixed mode. ( e.g. can you login to the...
February 5, 2007 at 5:32 am
what did you have in mind?
You can run in 2000 mode initially. The most likely issue you might have is with how the optimiser works ( it's slightly different )...
February 5, 2007 at 5:28 am
you might want to check for cxpacket waits - suspect parallelism may be blocking. Try adding a maxdop 1 hint to your query.
February 5, 2007 at 5:24 am
Viewing 15 posts - 1,366 through 1,380 (of 2,640 total)