GilaMonster (1/15/2009)

---

Only one at the moment. I'm considering buying a basket-hilt rapier (local weapons shop has a nice...

It seems that the server replaces the derived table with the real table. I wrote a small script and got the same error as you got. You can...

noeld (1/14/2009)

---

On SQL Server 2000 CHECK CONSTRAINTS were enforced "BEFORE" the insert actually took place apparently on 2005+ there are issues with this as you have already verified. There are...

We were not talking about rebuilding the clustered index....

DBA (1/14/2009)

---

hello, I have a quick question, I am creating a couple of new nonclustered indexes to a highly used table (Mostly reads, few writes). I know that when...

SimonD (1/14/2009)

---

CHECK constraints happen BEFORE the command occurs. It is triggers that happen AFTER the command occurs, hence why CHECK CONSTRAINTS are recommended over triggers when you are dealing with...

The problem is because the check constraint is checked after the insert. At that time it finds a record in the table and rollback the transaction. You’ll need...

Few years ago I wrote a script with vbscript that opened the packages then looped through the package’s object and for every connection object that was found, it checked if...

You can define the trace using the profiler in the regular way. After you define it, you can export the trace’s definition to a text file by going to...

select @@servername

Adi

Let’s try to figure out why there are different query plans. Are there any different set options that are being used when you query the database in the second...

Do you have the same query plan in both servers? Are there problems with other databases on the second server? Is there any modification with the workload on...

You can not use the row_number function in the where clause, so you need to work with common table expression that uses row_number function in the select list and then...

Here is another way of getting the beginning and end of a sequence. The downside of this way is that it assumes that there are no gaps in the...

You can identify rows with primary key or with another unique value in the table. What do you mean by saying odd records? Do you mean according to...