Viewing 15 posts - 5,596 through 5,610 (of 6,678 total)
ehlinger (3/1/2009)
You aren't missing anything. I just didn't explain the whole picture well enough. The reason it won't work to do filtering on the adjustments table is because...
March 1, 2009 at 11:43 pm
I really don't understand why you even need the #PointPartners table. Since all you are doing is filtering that table where the AdjustmentName is like 'PP_%' - and, you...
March 1, 2009 at 9:46 pm
I think I understand what you are trying to do, but I am not sure it is needed. Can you just create a new formatter procedure with the new...
February 27, 2009 at 3:47 pm
barunpathak (2/27/2009)
No..still not getting what i wanted to...
Okay, so what have you tried and why does it not work? Read the article in my signature and post some create...
February 27, 2009 at 3:33 pm
I ran into this issue before and found the only way to get this information was to get it from a server side trace. I was not able to...
February 27, 2009 at 3:28 pm
Okay - wasn't sure, but since your are on SQL Server the EXCEPT operator is available and can be used.
February 27, 2009 at 3:19 pm
Your query does not look like T-SQL, so I don't know if this will work in your product. In T-SQL we could use the EXCEPT operator, as in:
SELECT {column...
February 27, 2009 at 1:54 pm
One of the things I noticed is that the SPN record must match exactly how you are connecting to SQL Server. In other words, if your SPN is setup...
February 26, 2009 at 2:23 pm
The default max memory setting after install is 2TB, regardless of the amount of memory available on the server.
On x64 platforms - you want to always set the maximum to...
February 25, 2009 at 3:25 pm
noeld (2/25/2009)
Watch out for SQL 2005 has issues with ORDER BY in the definition of the views!
No, the only time it is not valid is when you use TOP 100...
February 25, 2009 at 3:23 pm
In addition to what GSquared stated, how many rows out of the 20,000,000 rows have a value in col2?
If most of those are populated, then SQL Server is going to...
February 25, 2009 at 2:16 pm
Jason Crider (2/25/2009)
What about the portability of not deal with a third party file extension?
What about your backup and restore scripts working anywhere...
February 25, 2009 at 2:12 pm
Besides compression, the number one reason we use Litespeed is speed.
I can backup my 350GB database, with compression to a 60GB file in about 40 minutes.
February 25, 2009 at 1:32 pm
steve smith (2/24/2009)
February 24, 2009 at 2:27 pm
Viewing 15 posts - 5,596 through 5,610 (of 6,678 total)