GilaMonster (9/21/2011)

---

Dynamic SQL for the Select, not the exists.

The point is that you need the query with the column name to only be parsed if the exists returns true. Both...

GilaMonster (9/20/2011)

---

The error comes from the algrebiser as it binds the query to the objects involved, it appears before execution, that's why the EXISTS doesn't help

You can change the select...

Sean Lange (8/29/2011)

---

Roust_m (8/28/2011)

---

Hi,

Just was wondering, from the best practices point of view, are there any disadvantages in using table valued parameters for your SPs in the application. E.g.:...

GilaMonster (7/14/2011)

---

There are 2 SQL 2008 MCITP certifications. Each one requires 2 exams.

MCITP SQL 2008 Database Administrator.

This requires that you have already written 70-432 MCTS: SQL Server 2008, Implementation...

calvo (7/13/2011)

---

You would be correct in your assumptions. The MCTS is a pre-req for the MCITP and they have separated administration and development.

Administrative track-

70-432 MCTS: SQL Server 2008, Implementation and...

I will check the version tomorrow, when I come to the office.

Why does it have to be the primary only? I reckon, the backup should continue as long as...

That extra "from" is related to commented out select statement.

I worked this out:

delete MyDB1.[dbo].[Company]

-- select top 10 * from

from MyDB1.[dbo].[Company] c1

left join MyDB2.[dbo].[Company] c2

on c1.CompanyID = c2.CompanyID

WHERE c2.[CompanyID] is...

I am disabling the indexes on indexed views so this is not a problem. The problem is with "NOT IN"

I am trying something like this:

delete

-- select top 10...

No, all the columns are identical, the only difference is that the subscriber has few extra columns.

Michael Valentine Jones (11/29/2010)

---

You may also see a message in the SQL Server Error log like the following that has the name of the host it is running on. ...

I need to be able to tell what happened in the past. ...

Steve-3_5_7_9 (11/29/2010)

---

Windows Server 2008 Cluster Manager also will bring up the event log related to the "Critical Events" for the cluster. This might be a quicker way to parse...

Well, I've tested it. I've created a new database with an empty compressed table and did an insert of 1GB of data. The data file went up to...

My logic is: with row compression, your varchar(1000) column may turn into char(100), so more records will fit into a single page as the page remains the same 8KB size...

$320 per 50GB...