Sure. This is the classic example

CREATE PROCEDURE AllOrSearch (

@SomeCode VARCHAR(30) = NULL

)

AS

IF @ID is null

SELECT * FROM SomeTable

ELSE

SELECT * FROM SomeTable WHERE SomeColumn = @SomeCode

If on...

If it's an identity, why are the users allowed to enter a number? With identities, SQL allocates the numbers, not the client app. Also, with an identity, if a row...

Have a look at uniqueidentifier with the newsequentialguid default. It may do what you want with no modifications at all.

Marcia Q (10/16/2008)

---

If you run the checkdb command without any repair arguments, does it actually DO anything to the database? Is it correct to say that without a repair...

The maint plan that checks ingegrity runs checkDB. There's no need for a manual job if the maint plan's doing it

DBADave (10/16/2008)

---

The reason we turn off Auto Create/Update stats is because the Database Tuning Advisor can kick off Update/Creation during production time. If you’re running a massive job during...

The from clause

What you're considering isn't possible unless you have access to the source code of the SQL engine itself. There's no procedure that's called to insert rows into a table. Even...

Since you're reading all rows and all columns from the table (select * with no where clause), there is no way to get that particular query faster. It has...

This is a SQL Server site, not a MySQL site. You may have better luck at somewhere like dbforums

Reuse of a number has nothing to do with indexes. I'm guessing it's an identity column. Is that so?

Why do you want to be able to reuse numbers that have...

Well, if someone's shrunk your TempDB database down, it's certainly going to have an effect. Fix that and see if it makes a difference.

There's a lot of paralleling going on...

Not directly, no. The closest is the identity column and the ROW_NUMBER function, though neither is a direct replacement.

You can't easily get...

There's a chapter on it in "Inside SQL Server 2005: T-SQL Querying"

Noting, of course, that Backup log will break the log chain. It will no be possible to restore to a...