Question:

Does the database and SSRS have to be at R2 level or can the data be in SQL Server 2008 and then say a seperate instance of 2008 R2 running...

mzak (7/22/2010)

---

Some interesting results!

I first tested the suggested hypothesis of declaring/setting the pi/180 as a constant in the T-SQL udf.

Average time = 1444.4 milliseconds

Then I tested using no declared variables...

mzak (7/21/2010)

---

Kevin Rathgeber (7/21/2010)

---

I have a comment regarding your T-SQL

In trying to keep all things equal, Shouldn't you declare a variable at the beginning of your function to hold the...

I have a comment regarding your T-SQL

In trying to keep all things equal, Shouldn't you declare a variable at the beginning of your function to hold the value of PI()...

Here's what I think most people are missing on this matter:

1. Dynamic SQL is not the problem, Injection IS.

2. SQL Injection uses Dynamic SQL, but the two are...

ksh (2/18/2010)

---

what is being argued about? The tools were created to fulfill certain needs and are there to be used. Some tools are be better suited to certain...

RBarryYoung (2/18/2010)

---

Kevin Rathgeber (2/18/2010)

---

RBarryYoung (2/18/2010)

---

Kevin Rathgeber (2/18/2010)

---

RBarryYoung (2/18/2010)

---

Dynamic SQL is not preferred, but saying that it should be "avoided at all costs" is far too strong and just is not...

RBarryYoung (2/18/2010)

---

Kevin Rathgeber (2/18/2010)

---

RBarryYoung (2/18/2010)

---

Dynamic SQL is not preferred, but saying that it should be "avoided at all costs" is far too strong and just is not correct. There...

RBarryYoung (2/18/2010)

---

Dynamic SQL is not preferred, but saying that it should be "avoided at all costs" is far too strong and just is not correct. There are many, many...

Josep (2/18/2010)

---

Kevin and Andy,

I wouldn't like to be missunderstood: I absolutely agree with you. I only use dynamic sql when I cannot avoid it, as a last option. It has...

Your dynamic sql example seems to be a one off or just a script you run, however, just a note as a developer and from an applications point of view;...

Is that word allowed on this forum 😀

Hi Jeff.....I just read your solution regarding the sequence tables. Very good explanation. I have one minor concern (very minor). You have indicated having the transaction starting...

While on the whole Kerberos subject here...Have you ever run into a problem where it appears that Kerberos appears to just stop working (not sure if it is reverting back...

Gherry Taylor (2/13/2009)

---

I have been passing table names in SQL Svr 2000 for a couple of years, now. Perhaps, this isn't what you are taslking about but the following...