Lynn Pettis (4/18/2009)

---

My thought on his request told me he had a good idea what we might say, so he wanted us to hold off and see what others might...

Sure you are absolutely...

Hi Rob

Seems you try to create two schemata within one SQL file. The concept of the DB-projects is to hold one object in one file. You have to create two...

Hi

I don't try to give an answer for this question because...

I have a short question depending on the article I intend to write (CLR solutions to split strings).

What do you like more C# or VB.Net? It doesn't matter for me...

Sure!

Jeff Moden (4/18/2009)

---

Florian Reischl (4/18/2009)

---

I agree with Jeff. Sure, it is simple to have a look into the assembly with .Net Reflector. But since you are no C#/VB.Net/... developer it...

Hi

You can use DATEPART to get the weekday and the week:

DECLARE @t TABLE (Sno INT, Sname VARCHAR(10), Date DATETIME)

INSERT INTO @T

...

GilaMonster (4/18/2009)

---

Anyone got SQL 2000? More specifically Query Analyser?

If so, can you please get me a screen shot of the following.

Run the following:

SET STATISTICS PROFILE ON

GO

SELECT * FROM sysobjects

There will...

I agree with Jeff. Sure, it is simple to have a look into the assembly with .Net Reflector. But since you are no C#/VB.Net/... developer it might look strange and...

Paul White (4/18/2009)

---

I was thinking originally of the second approach - a T-SQL chunking loop. However, the data access from CLR idea is intriguing - it would be nice...

swathi.g (4/18/2009)

---

Florian Reischl (4/18/2009)

---

Hi

I'm no pro for MS-Access but did you have a look to BOL for "linked servers"? Look for "sp_addlinkedserver", there are some examples how to connect to...

Hi

I'm no pro for MS-Access but did you have a look to BOL for "linked servers"? Look for "sp_addlinkedserver", there are some examples how to connect to MS-Access databases. Sure...

Paul White (4/18/2009)

---

You gave my suggestion a much deeper analysis than it warranted 😉

By 'chunks' I meant something like...

The Test Framework

To simplify the tests I create one table “PerfMon” (delete the data if it already exists) and two procedures “usp_PerfMon_Init” and “usp_PerfMon_Write”. If you want to do the...