Oracle_91 (8/30/2011)

---

Hi All,

What is the best order while creating maintenance jobs so that sql optimizer can pickup the best execution plan.

Daily i have 3 jobs configured to run in the...

First thing I'd look at is: what else is happening on the SQL Server at that time?

Look for

1. Maintenance tasks ie re-indexing.

2. other Backup operations causing disk contention.

3. Introducted...

It will connect and view but you can't manage it. for example modifing a table gives this

TITLE: Microsoft SQL Server Management Studio

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

Unspecified error

(MS Visual Database Tools)

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

BUTTONS:

OK

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

CodeOn

😛

And some of us just like to denormalise just for the fun of it.

😛

Sorry couldn't help myself

THERE IS NO BUSINESS NEED OR REASON FOR THE USE OF THE SA ACCOUNT BEING USED IN AN APPLICATION OR USER. Change it to something no-one knows and keep...

Snapshotting the mirror and then using the data using bcp or SSIS activities is not passive this is because the SSIS and creating and using of snapshots are considered productive...

Passive vs Active comes down to this.

Are you accessing the data for any purpose then NOT passive.

Are you using the "Passive" for reporting then NOT passive.

Are you log shipping as...

Passive... is a very relative term But, as far as SQL server licencing is concerned if you are 'using' it even readonly or DBA activity then this is deemed...

Craig Farrell (12/16/2010)

---

Hehehe, and as...

Paul White NZ (12/16/2010)

---

CREATE TABLE dbo.Example

(

row_id INTEGER IDENTITY NOT NULL PRIMARY KEY CLUSTERED,

data AS...

Yeah, sometimes... I think that this "View not ordered. why?" topic and the discussion that insued is a clear indication that mostly,

1. People want to be spoon feed.

2. ...

GilaMonster (12/16/2010)

---

Which are you saying is the myth? That the clustered index scan does always return in order or...

Craig Farrell (12/16/2010)

---

Michael Valentine Jones (12/16/2010)

---

There are a lot of people that think that if you do a "select * from MyTable" that it will return data in order by...

evald (12/16/2010)

---

Rarely...

250128836 (12/15/2010)

---

Please test Query SQL:

SELECT DISTINCT A.Status

FROM dbo.Test1 A

LEFT JOIN dbo.Test2 B

ON A.Status= B.Status

WHERE A.Status IS NOT NULL

AND B.Status IS NULL

Because of Number of rows in dbo.Test1 A more...