TheSQLGuru (3/23/2012)

---

I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad for your IO subsystem...

Bill Maners (3/16/2012)

---

Hi,

I just installed SQL SERVER 2008 R2 and trying to create an odbc connection to a database on that server. I am using the same server to...

deep_kkumar (3/16/2012)

---

That column was a...

Enabling xp_cmdshell just to execute the SSIS package? You already have the Integration Services Package step type in the agent job configuration. If you decide to call it from CMD...

gladys14g2 (3/15/2012)

---

Some indices get to 95% fragmentation in just 24 hours, so we reindex nightly. Our reindex job does a reogranization if fragmentation is below 30% and an index rebuild...

opc.three (3/15/2012)

---

I think you're are OK in terms of the DB engine. SQL Server is reporting the memory as I would expect, noted by the 9.77GB figure for buffer_pool_target_memory_in_GB.

It's possible...

Mick Opalak (3/15/2012)

---

SQL2008 R2

We have a 12 Gb database that is highly transactional. Some indices get to 95% fragmentation in just 24 hours, so we reindex nightly. Our...

To create OR modify SSIS package you...

Have you worked as SQL DBA earlier or it is the first time you are going...

stebennettsjb (3/6/2012)

---

Hi MarkusB,

Thanks im properly being dim..

But wouldn't that create a temp table on every server, with the results of only the server its created on. I would...

pallavi.unde (3/6/2012)

---

My website is suffering from SQL injection attacks, user is inserting a scripts in database tables. for that first precautions i took to use a database views.

also i a...

mohan.bndr (2/16/2012)

---

I m executing long query with joins and dmvs. But it is showing error user has no permission, access denied. But when i execute an individual dmv it is...

???

nfpacct (3/2/2012)

---

Is there any way to create an instant alert and/or popup window when a certain record is deleted.

I have a trigger that fires whenever a record is deleted and...

stebennettsjb (3/2/2012)

---

Hi all,

Is it possible to run a query against multiple registered servers and have the results inserted into a table?

Trying to get details of SQL boxes and...