In BOL, there is an entry concerning "Security Account Delegation". Search for it and you will find that this may be a fix you need to implement. Basically, it concerns allowing client connections to retain NT credentials when "hopping" servers. This typically applies to Windows 2000 servers/domains, and requires changes to EACH referenced server AND […]
2003-05-05
1 reads
2003-05-05
The code seems very complex and... "not SQL-like". It looks more like coding of nested function calls in a procedural 3GL. This is not really appropriate for SQL. God knows how well SQL compiler and optimiser are handling this stuff. I would recommend rewriting the code without using complex queries. It could be split onto […]
2003-05-02
I much prefer passing XML, nicer format, lots of flexibility. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-02
Sorry... I am doing an outer select because the inner select actually contains 3 similar select statements which are UNIONed together. And, they need to be sorted with a dynamic sort - so I was going to use as CASE statement as part of the ORDER BY clause. Regardless of the sorting issue, I'm normally […]
2003-05-02
I'm not sure about the nesting you are using? You simply select and then subselect with no qualification? What is this query supposed to do or is it just an example? Darren
2003-05-02
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!
2003-05-02
Ok, does the field HAVE to be a primary key to have a constraint on it?
2003-04-30
Thanks Rajesh This has worked and has got the report back to 2 mins. I have not set the DB to auto update I have scripted it into the extraction, so when it has finished inserting the 2.2 million records it will then update the stats for the whole DB Thanks again
2003-04-30
1 reads
I agree. If he chooses auto create statistics and auto update statistics in database option, will this work? To me this doesn't work. Could you explain why not. Thanks! Robert
2003-04-29
1 reads
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