Carl B. (11/8/2013)

---

Hi Sean,

It would be simpler to process all the tables. But let's say you can avoid rebuilding indexes on 5 to10 really big tables, it would reduce a...

Carl B. (11/7/2013)

---

Hi Gail,

Yes. The contexte is the following :

Application upgrade...

curious_sqldba (11/7/2013)

---

Keith Tate (11/6/2013)

---

That is simply the name of the output (one of them) from the Compute Scalar operation right before the sort. Also, you have some carnality issues with...

http://technet.microsoft.com/en-us/library/ms143432.aspx

Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed...

Instead of building one statement to execute, I would execute each statement into a temp table.

CREATE TABLE #Indexes

(DatabaseName SYSNAME,

TableName SYSNAME,

IndexName SYSNAME NULL,

Reads INT,

Writes INT,

Rows INT);

DECLARE @DatabaseName VARCHAR(50)

DECLARE @sql NVARCHAR(MAX)

DECLARE...

You need to cast DM.DOCNUM in your where clause

and CAST(DM.DOCNUM AS VARCHAR)+'-'+G.USER_GP_ID not in

This will work for your sample data

New table definition

-- Add an IDENTITY ID column and a CategoryID column

CREATE TABLE books

(ID INT IDENTITY(1, 1) NOT NULL,

CategoryID INT NULL,

book_name VARCHAR(10),

code VARCHAR(3),

qty INT,

day...

Even with a category your next problem is row order. You mention a requirement to identify subsequent rows but there is no column that will allow you to identify subsequent...

These are internal expressions produced when SQL Server executes the query.

We certainly don't get those kind of opportunities living in Africa, I envy...

It's not possible with that design. You have no way to relate a book to a category at all. At the minimum you need a column to indicate the relationship...

Bazinga

I suspect parameter sniffing.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

Do you want to update a notification or a step command?

Notification

sp_update_job [ @job_id =] job_id | [@job_name =] 'job_name'

[, [@notify_level_email =] email_level ]

...

What about just sending the path to the app and letting the app worry about fetching the image?