Muhammad Furqan (2/21/2008)

---

firstly, i have mentioned DataAccess.Read at the top.

then why do is a CLR needed. here is the answer

i have a table like this

table=mytable

table_name column_name value

tableA col1

tableB col2

now the...

Muhammad Furqan (2/21/2008)

---

oh man ! you are missing a point.

i know about that simple query that you hace written, but problem with me is that the "table_name" and "column_name" are...

In dynamic SQL you can use the QUOTENAME() function to delimit your objects with [...]:

'USE ' + QUOTENAME('master', '[');

will give you

USE [master];

Off topic, the QUOTENAME() function has an interesting application...

andym0908 (2/21/2008)

---

Harsh yes. I can see how eyebrows might be raised at the question, and I might come across as a bit of a newbie. I am new...

colin Leversuch-Roberts (2/21/2008)

---

I'd suggest a training course - if you're really hosting a sql server this way you shouldn't be asking this question. I know this sounds harsh but data...

Jamie Longstreet (2/19/2008)

---

The question brought to light that circumstances exist where the estimated plan and the actual plan can be different. I'd be interested in seeing more topics on...

Thanks guys, I will follow your suggestions.

Thanks for the valuable input.

My question is can I have the SQL Server which hosts the datasource on Service Pack 2, while the reporting services and its databases are on SP1? I don't want...

Also keep in mind that AWE benefits only the data cache; other parts of memory utilization, such as procedure cache, do not benefit.

AWE memory is dynamically allocated according to the needs of your environment. Stress your server and you will...

Hi all,

What is the best way of preparing for the simulations in 70-431?

I do have the Microsoft certification book for the exam:

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft® SQL...

Jeff, I'd be interested in something like this as well, I'm based in Mississauga.

biju127 (2/19/2008)

---

Hi Pradeep,

As i had already mentioned there is also a another instance which is now in production.

Is the suggested method is the safer one?

If yes then what are the...

On the subject of SQL Profiler, SP:StmtCompleted should be one of the events to monitor.

I believe it is possible to actually trace the running of the code in a similar manner to how one would do so with .NET code in Visual Studio.

However, I...