npatel0130 (10/8/2009)

---

We are implementing ESB using BIZTalk and rewriting ATL code which populates the SQL DB for the customer. Customer wants to use BAM PORTAL. We have solution to...

What's the reasoning for pushing the data from the SQL server, rather than using an external component to pull it out?

You tend to get a LOT more options, better securability,...

Don't know if this is the BEST way, but it's one of the ways:

declare @basemonth datetime

set @basemonth = '20070612'--set this to start at least one month BEFORE your start

;with n1...

17058 = "access denied" or "cannot access a resource"

1814 = cannot create tempDB/disk full.

Still - it's interesting that the errors occurred in that error. Having the access denied to a...

Fail over to the other instance. If it...

The drive is offline - until your cluster can connect to it, there really isn't much SQL server can do?

(btw - the correct salutation in this case would be "Ma'am". don't let Quaigon Jin fool you)

repent_kog_is_near (10/3/2009)

---

Matt

I do not need to plan any other process on the dedicated drive for TempDB. What I am asking is if SQL or Windows Server will need any extra...

Here's a bit more expansive an example (where there is more than one crit)

declare @x xml

set @x='

<root>

<Clause Tag="4" IsLeaf="0" Operator="OR">

<Clause Tag="2" IsLeaf="0" Operator="=">

<Clause Tag="0" IsLeaf="-1" Operator="">Fruit</Clause>

<Clause Tag="1" IsLeaf="-1" Operator="">Apple</Clause>

</Clause>

<Clause Tag="2"...

This should get you started (on the shredding out part). depending on how many levels you have, this could get rather ugly.

declare @x xml

set @x='<root><Clause Tag="4" IsLeaf="0" Operator="OR">

<Clause Tag="2"...

repent_kog_is_near (10/3/2009)

---

Matt

Thanks for the tip. I like making additional data files out of TempDB; it can only help with I/O.

In my case, do you think I can set the TemPDB...

repent_kog_is_near (10/2/2009)

---

We are considering a dedicated for the TempDB, with no other files in the drive.

Will it be a good idea to remove/disable both autogrowth and also autoshrink and...

It's giving you what you asked it to do. You've essentially asked it to return the constant value of "FirstName" for every row in person.contact (where person is the...

If you're in access - you should dig into a little VBA, and attach a reference to the DTS packages (the newer version automates SSIS). That was you can...

J-F Bergeron (10/2/2009)

---

Grant Fritchey (10/2/2009)

---

repent_kog_is_near (10/1/2009)

---

I have some 110 new SPs and Functions in a Development Database; they need to be moved to the testing Database in another server. I...