Jeff Moden (10/7/2008)

---

Heh... then the correct answer for question #2 in regards to SQL Server 2008 should be "I wouldn't do that because I don't want the DBA to chase...

Denby (10/7/2008)

---

Wilfred van Dijk (10/7/2008)

---

A full backup is just a copy of every used page in your database. So if you have some sort of fragmentation in your database, it's...

That query still can't use any indexes due to the leading wildcards on almost all of the filters.

Do your users really enter middle portions of account numbers, phone numbers or...

The query I was trying is even simpler:

select CarrierTrackingNumber, ProductID, OrderQty, UnitPrice from Sales.SalesOrderDetail where CarrierTrackingNumber = '8639-4639-AA'

Missing indexes picks up that (CarrierTrackingNumber) INCLUDE (ProductID, OrderQty, UnitPrice) would be extremely...

Sanaullah (10/7/2008)

---

Hi,

AS the values are changing every second the in procedure we should use

WITH RECOMPILE, So wheen ever it is called it recompiles the query and get the last 50...

Jeff Moden (10/7/2008)

---

the limit on the number of indexes for a table is much less than that. (Teach a person to fish) Lookup "Maximum Capacity Specifications" in Books Online...

Quit the 8-5 job and started consulting.

I have hectic days where I work to midnight and I have mostly free days. It's awesome.

Good point. You may need the serialisable then. Leave the xlock. It saves SQL having to convert an updlock into an xlock for the insert.

As for the isolated, in terns...

Backup.. with no log shouldn't be run at all.

You're discarding log entries and breaking the recovery chain. Practically what it means is that if the latest full backup fails...

Is it possible that something could be using the backup file? An anti-virus, a copy?

Why are you doing a backup log with no log before the full backup? How often...

This is interesting.

I ran a very simple workload in 2008's DTA against the AdventureWorks database. When I ran it to my 2008 server, I got no results. When I ran...

Yes,...

Swirl80 (10/7/2008)

---

but, running a repair / rebuild will take roughly 10mins as opposed to an hour to restore from previous nights backup and all the transaction logs.....and what if the...

Sure, providing the column is declared nullable.

2) If I have...

That's the process ID (pid) of the SQL server executable. You'll find it in Task Manager.