MonsterRocks,

This can be done using a feature in SQL Server that will update a variable and a table in the same statement.

CREATE TABLE #TAB2 (SNO INT, UNQ_ID BIGINT)

INSERT INTO #TAB2...

Gail,

Thanks. I'm looking forward to the next articles..

Todd Fifield

Chad,

There's a way to do this without table locking and such if you can add a dummy column the the Sequence table. (Unless there is some way to use...

Excellent article Gail. The diagrams were very simple and easy to eyeball.

I have one question about the leaf level of non-clustered indexes. Are they a double linked list?...

I would go with GSquared's solution.

However, if you want a quick and dirty way to avoid cross-firing triggers, stick this at the top of the triggers:

IF TRIGGER_NESTLEVEL() > 1

...

I've used this type of counter/sequence table logic for years and never had any contention problems. Explicit transactions aren't needed because everything is done in the update (quirky update)...

mrcmiranda_sg,

To further clarify what Craig said in his post, you may have hit a 'tipping point' in your query. Usually you would see this before 20M rows in the...

I'm really at a loss here. I set up some test conditions and they seemed to work just fine.

This was, however, using Access 2007 and ADO against a SQL...

Nadrek,

That said, I must maintain that in certain actual business cases, absolute accuracy is not required by the business use; simplified dashboards for management is an example of this (if...

Delinda,

It looks like the linked server has not been set up properly. It's not very hard to do once you get the hang of it.

In SSMS go to Server...

If I'm curious as to what's happening on this type of activity I usually just do:

SELECT COUNT(*) FROM Table WITH (NOLOCK)

You get an approximation of what's going on.

Like other posters...

GSquared - 12/28/2010

I'd tell the interviewer, "Okay, I'll bite. How do you do that?" These kind of questions aren't about technical proficiency. They're about problem-solving technique. Basically, translate it to,...

Christian,

Are you trying to Connect to them by using the little Connect drop down just under the Object Explorer in SSMS? These services don't show up automatically. You...

malleswarareddy_m,

I keep several folders inside my SQL tools folder just for trivia that I don't think I will ever use. In fact, the solution to your interviewer's problem may...

Nadrek,

I disagree that OLAP can allow for a small percentage of bad data. If I were to show the owners of companies that I consult for 2 different results...