SQL Server needs to pick one and only one access path for your SELECT statement. Since there are 5 columns being compared it will assume that every one is being used all the time which will never be the actual case due to the CASE statements embedded into the WHERE clause.As for a "better" way, what […]
2004-09-20
Have a look at www.pscode.com
2004-09-07
Well, I don't see a way to do this in one easy step. So, I would load the AS400 data into a staging table.From the staging table, you may need to then populate another table that crosstabs the data from the original staging table. Then, you can query from that to populate the final destination […]
2004-08-12
Agreed, simply is good and remember some basics. I think one of the options used a function on the column before testing ! Optimisers don't like this and are unlikely to utilise available indexes.Sometimes simple approaches look more verbose in terms of lines of code, but believe me, several months down the line having to […]
2004-07-10
Hi,Try change Aritmethic abort setting from connection property.1. Run SQL Server Enterprise Manager2.right klick on server, select properties3.select connection tab4. check mark on ANSI warning,ANSI padding,ANSI nulls, Aritmethic abort
2004-04-14
THANKS much !!! (Yes, it isn't that large a database when you think about, compared to the others we have on this system it is one of the largest).Obviously I need to do a couple of practice restores on dummy databases to get this down.My big concern was after 3 hours, and having no gauge […]
2004-03-31
Hi,I want to get the last occurance of a string/char in a given string.is there any implicit function for doing so similar to CAHRINDEX that returns the first occurance. Thanks in advance-Prasad
2004-03-25
1 reads
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-03-22
This one puts the output into SQL commands that you can cut and paste into a new query and execute. -- af_revPermissions-- Verify existence of af_revPermissions procedure. If it does exist, -- drop it, so that it can be re-created. if exists (select * from sysobjects where id = object_id(N'[dbo].[af_revPermissions]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) begin […]
2004-03-18
Hey Gary,Generally most users hit Active Topics and see the list of all new topics. Therefore in the future you only need to post once. Someone will get to it!
2004-01-23
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