I am not 100% certain this...

RID Index: Yes my all in one partition is...

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

|--Nested Loops(Inner Join, OUTER REFERENCES:([Bmk1000], [Expr1007]) WITH UNORDERED PREFETCH) ...

I've been experimenting... riddle me this...

My misbehaving share table is partitioned (with LightSpeed, this is 2005 environment) into 183ish partitions.

Here is what I did I just copied my 92 million...

Attached are the query plans...one that shows the index seek (when only indexed columns are included in the select statement), and the second with the table scan (a numeric column...

Thank you Jason. There are no clustered indexes... (there could be... I just don't know about clustered indexes with the partitions so I have not ventured down that road...

Here's another example of fetching a random set of rows.

We have 2 uses for this:

1. Sometimes our Credit Union Customers want to do random drawings/giveaways during the...

Ah, there's no higher form of flattery than plagiarism... So I was once told when a Fortune 500 company "used" my materials.

In the "some good can come from this" category,...

Thanks for the reply Benjamin. Yeah, I'm still lurking around.

I had forgotten about this post. We did finally convince the IT guys to disable Sophos and we reran...

Well I'm glad I wasn't completely crazy... I had the concept right... but obviously I missed a piece.

Thank you SO much for that code. I ran your example as...

I don't. I only included that to illustrate that if I open up access the user can query the table. Ideally, I do not want to grant select rights...

It seems to me that without the cypher key, it doesn't; I can tell the method you used to encrypt/decrypt, but I do not believe there is enough information there...

I have done 3 SQL Server migrations from obsolete hardware to new over the past 6 months and have used sp_help_revlogin with little trouble to move the users and permissions...

I thought about using a temp table as a solution, however, accessing this data will be a fairly common task for a bank of "average" report writers; teaching them to...

We have an application that uses the DTS infrastructure to import data from a variety of ODBC accessible data sources into a sqlServer warehouse repository.

Excel spreadsheets have always been a...

Within an hour of posting I found it... Yes, you can modify GlobalVariables via .NET code and then execute the DTS Package programmatically.

However... you need to pay attention to data...