Enforcing constriants often prevents actions. Most of the time it prevents 'illegal' actions. But sometimes it prevents actions, which are functional.

In general I am in favor to enforce constraints in...

Sean Lange (7/31/2015)

---

You should avoid the sp_ prefix on your procedures. It is reserved for MS and denotes it as a system procedure. The performance issues are mostly corrected but...

All thanks for your contributions.

Luis Cazares, thanks for your solution. Next monday I'll study it and try it.

Although not simple, I probably could wrap this up in a stored procedure.

If...

;

With

A as (

SELECT

ROW_NUMBER() OVER(PARTITION BY PartNumber, MfgSerialNumber ORDER BY InspectionDate desc) subnumber

,*

FROM TestGroup

WHERE PartNumber...

Thanks again.

Did not realise that a select top 1 would count as a 'scan'.

I do use the TOP a lot, but not in a production environment. (At least not without...

GilaMonster (7/30/2015)

---

Nope.

A key/rid lookup is done to fetch columns which are not present in the index used. It's not related to a seek, you can get index scans with key...

GilaMonster (7/30/2015)

---

Lookups aren't related to seeks. Lookups will only be > 0 on a clustered index or heap. It's the number of key lookups/rid lookups done.

Updates are any modification. Insert,...

A similar question has been answered before see :

http://www.sqlservercentral.com/Forums/Topic508540-1291-1.aspx

Jack Corbett (7/14/2015)

---

Backing up a SQL Server database is an online operation so you don't have to suspend operations on the database in order to get a backup...

Thanks, get some 'false positives' for calls to stored procedures in the master, but this is working...

Used the code:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A_test]') and OBJECTPROPERTY(id,...

Sorry that I was not clear.

I would like a list...

Hello, thanks for your attention.

While messaging in this forum I came up with the following sollution:

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

-- Solution method 1

-- Create a temptable of an actual table, where the identity column...

Sean Lange (12/12/2014)

---

Generic tools in a database are fraught with problems. They sound really cool but in practice they usually are pretty bad. They are incredibly difficult to build because...

I am building a generic tool. *)

The tool can be used on tables which are not in existence yet.

Ben

*)

More specific...