What the heck is sql traps :w00t:???

That's one of the biggest challenges when writting a question. Everything depends in sql server when talking about performance. And if you give out too many details then...

One more vote for the definitly use more ressource "issue thingie".

Using C or a+b in the query will have no difference at all. There will be a small hit...

Here's a different way to look at that problem... even if no likely use in real world

Build a table with whatever range of numbers you need.

Then

select top (@NbRowsNeeded) *...

Can yo uprovide more details about what you want to do and what you've done so far, maybe It'll jolt my mind into action.

Ray Mond (7/7/2010)

---

If your first STOPAT recovery was used with the STANDBY or NORECOVERY (which doesn't make much sense) options, you can restore subsequent transaction logs. You do need...

vinodvadla (7/7/2010)

---

Its not that way Lutz i am actually very new to SQL coding and i am not able to understand or get how exactly i can write the question...

as far as I know, you need to redo the full sequence with a different stopat parameter.

Unless maybe you need to restore a single [set] of table and not the...

Lowell (7/6/2010)

---

just hazarding a guess here, but could it be your SQL instance is 64 bit and the drivers are only 32 bit?

anthony.ventura (7/6/2010)

---

Hi, new to the forum, and have...

kchant (7/1/2010)

---

You could try running DBCC UPDATEUSAGE first and then using the system views to get an accurate row count, if you're using your original query with the WHERE clause...

UMG Developer (6/30/2010)

---

badatthis: Yes, that issue has been brought up more than once. And I think it goes further than that, even with a PK/clustered index you aren't guaranteed a...

Another simple exemple. I once remoted on a server and ALMOST hit the shutdown button rather than log off.

I caught myself in time but it's been known to happen....

A picture is worth a 1000 words, a screenshot of the page you have along with what you need to do would be usefull in helping you out.

As a "workaround". You can always use row_number() in your queries to get unique values, especially usefull if you need to have the identity reseed for groups

Ok, who here has NOT done that already?

nice one :w00t::-D