krishnaprasad14 (1/31/2012)

---

Thank you for the reply. But here we are not deleteing existed records in UNMATCH table.

[For example, today we got 3 records into Unmatch obkect and tomorrow may be...

Ah ok, that makes more sense 🙂

This KB has a few scripts that let you determine version numbers and edition of a SQL Server instance:

How to determine the version and...

Count the rows, put the result in a variable and send an e-mail if the value of said variable > 0.

What is SCCM?

Here you can find info on the different SQL Server 2008R2 editions:

http://www.microsoft.com/sqlserver/en/us/editions.aspx

Oh yeah, list is also a form of tablix, but it has more of a free-form layout.

More info here:

Tables, Matrices, and Lists (Report Builder 3.0 and SSRS)

Table and matrix are actually a specialisation of the tablix.

The tablix is the most general form, while the table is has only data on columns (like a table in a...

It seems that it's just not possible in SSRS to export over 65536 rows.

http://social.technet.microsoft.com/Forums/en-US/operationsmanagerreporting/thread/37f2b53b-121f-49a5-87cb-5ac539a4cb23/

However, a report containing more than 65000...

Which version of Excel does SSRS export to? If 2003, you have the 65536 row limit.

Using SSMS, in which version of Excel do you copy paste the results?

ps: keep in...

MysteryJimbo (1/31/2012)

---

Koen Verbeeck (1/31/2012)

---

How to: Encrypt a Column of Data

First google result for sql server...

Whoah, that's from 2006. That's old :w00t:

It doesn't even mention Microsoft as an ETL vendor. Tsk tsk tsk

SQL Kiwi (1/31/2012)

---

Koen Verbeeck (1/31/2012)

---

It's probably a language thing 😀

I understand that the optimizer can switch joins, but I'm confused by the "uneven rows" part.

I guess it doesn't matter if...

SQL Kiwi (1/31/2012)

---

This may be a language thing, but we are...

Tava (1/30/2012)

---

Sorry to jump on the OP's post but if SQL2012 will be released in the first half of the year when do the MS Certifications for SQL2012 begin.

I'm Currently...

Looks a lot like this one:

http://www.sqlservercentral.com/Forums/Topic1244005-391-1.aspx

The reply to the suggested solution is a bit worrysome though.

Thanks for support, but...

SQL Kiwi (1/31/2012)

---

The optimizer has to choose one row source...