Lempster (5/23/2014)

---

One thing to be aware of is that Database Mirroring is now deprecated. I'm not saying don't use it, but that Microsoft intend to remove it in a future...

pxt_ce (5/21/2014)

---

Hello masters,

we are facing one issue from last 3 days.

During job execution (SSIS) we are getting Login TimeOut. with the following error. Request your master help.

Error:

SSIS Error...

Minto Minto(quendans) (5/20/2014)

---

Hi

We are planning to add an extra node to the existing cluster environment.Before that we want to check CPU usage ,Memory usage and etc.

Can any one please suggest...

ramana3327 (5/22/2014)

---

Hi,

I am working with the SP tuning. I want to know clearly about the temp tables.

Some people say

Instead of Select * into #table, it is always better to...

Agree!

sql-lover (5/22/2014)

---

SQLRNNR (5/22/2014)

---

The query is a relatively low cost but is going parallel.

It looks like you might have set maxdop to 2 but left the cost threshold at 5.

You might...

SQLRNNR (5/22/2014)

---

The query is a relatively low cost but is going parallel.

It looks like you might have set maxdop to 2 but left the cost threshold at 5.

You might want...

GilaMonster (5/22/2014)

---

Table definitions, index definitions please.

Are the business users happy with the chance of getting incorrect results from this query from time to time?

And, what's the point of this?

AND (''=''...

James Mace (5/21/2014)

---

I really don't know what you mean, so here it is:

ON compression

These are FULL backups

NO we are not backing up to multiple files,

Our database use two files (Data...

pgmoschetti (5/21/2014)

---

TheSQLGuru (5/21/2014)

---

I agree that synchronous database mirroring is probably the way to go here. Decent hardware should be able to keep up with 30 actions per second without...

I understand your situation but I think your workaround will create more problems than a...

pgmoschetti (5/21/2014)

---

I have a control room with the following configuration:

- 2 PCs running the control software, each with its own SQL Server Database for data store (the 2 databases are...

ChrisM@Work (5/21/2014)

---

-- Read (and aggregate) table variable @Result only once.

-- Note that a row will match more than one filter.

-- Note use of NULL in case expression for averages -...

Got this error:

Msg 1072, Level 15, State 1, Line 22

A REMOTE hint can only be specified with an INNER...

I take that back.

The new code seems to be more slim and faster on the remote server ...

... but there is more data traversing the network.

:ermm: