If you've been using SQL 2000 for a few years, you shouldn't have too many problems getting certified in SQL 2008, at least to MCTS level. After all, that only...

As others have suggested, using a firewall to block access to all but the IP addresses of people who need access is the best idea. Also though, it can help...

Hi

It sounds like you're talking about paging. This page has lots of useful code for doing paging and is worth a look. It contains code for SQL 2000, as well...

As Wayne points out, table definitions and some sample data insert statements would be handy, but I came up with this quick demo which hopefully contains the seeds of what...

Hi

Finally solved the problem!

Collation proved a dead end, so I went back to the set options. I added a table to the database to record the output of the @@OPTIONS...

Jeff Moden (6/30/2010)

---

Heh... I plain forgot about that possibility because...

I think I'm getting closer, so bear with me.

I actually found another similar stored procedure on my system that didn't use the correct index either when called from the application...

sujeetps (6/30/2010)

---

Have you tried using the index hints ? you can provide the index name which you want to be used, in the select query. Try it on your mysterious...

OK, more information (I feel a bit like I'm talking to myself, but sometimes that's how you solve problems!):

I have another server, with effectively the same databases on it, and...

Totally forgot to mention, (not sure if it's relevant or not), but the underlying table is in a different database from the view.

Other stored procedures making queries on the same...

Jeff Moden (6/29/2010)

---

Yes... Google for "Parameter Sniffing" for the reason caused by multiple causes...

Ok, an update, so that anyone with the same issue finding this post in a couple of years doesn't get frustrated by the lack of conclusion. 😎

The problem appears to...

paul.knibbs (6/28/2010)

---

We had a 6-way replication scheme going on at one point--we just used...

Hugo Kornelis (6/28/2010)

---

Good question!

One possible use of negative seed and positive increment is to increase the number of values before you run out. With data type int, the maximum value...

Changing the subject somewhat...

Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.

I'd therefore be interested to hear if...