tymberwyld (7/5/2012)

---

One thing to watch out for here with "processing a file as soon as it arrives" is that you don't know if that file is done copying or not....

That's a neat idea. I...

Upsert (7/2/2012)

---

kpatrick (7/2/2012)

---

Some questions to consider:

1. What kind of Windows Server security permissions does the identity running the SSIS package need in order to execute the WMI query? ...

I didn't feel like learning your code because I provided a solution to get you to a list of directories. Picking up where my code left off you could do...

I'd be happy to have a look too.

jagadesh.kedar (7/5/2012)

---

We have to Change in All the instances..

Suppose if you have 10 GB Ram,Than assaign 8 to 9 GB RAM for SQL(8-9 GB is combindely for all the instances)...

Thanks.

Indianrock (7/4/2012)

---

Our Systems guys finally got most if not all of the domain trust issues worked out so now a migrated user can connect even if no new sql login...

This sounds like a bug thathas been fixed. What build of SQL Server are you on?

Connect Item: Invalid XML in Extended Events xml_deadlock_report output by Jonathan Kehayias

Minto Minto(quendans) (7/2/2012)

---

Dear All,

In our environment Due to one table Db is growing high.Due to this disk space is is high..We have truncated the table.But still disk is showing same...

It's...

Before having the conversation I recommend reading up on the difference between being a dbo (Database Owner) and being a member of the db_owner (a Fixed Database Role). There are...

Consider that while CHAR columns would occupy more space if your columns were not mostly full they help us avoid page splits when inserting and updating. If your tables receive...

Lowell (7/3/2012)

---

there's a bit of a work around you can try by using openrowset:, it tends to be a LOT slower, but it works:

--database name required

SELECT *

INTO #tmp

FROM ...

Bruce Hendry (7/3/2012)

---

If I have a scalar function tied to a constraint, and it selects data from the table, is the inserted data visible or does it have to be...