agiangone (11/17/2011)

---

Interesting comment and that...

Evil Kraig F (11/17/2011)

---

Hunh, news...

What column is the table partitioned on?

Sql logically treats the partitioning column as a leading column of the indexes when building query plans.

--Identify number of VAS chunks that are greater than 4 MB in size

--x86 Only.

SELECT

SUM(region_size_in_bytes / 1024 / 1024 / 4)

FROM

sys.dm_os_virtual_address_dump

WHERE

...

Virtual Address Space exhaustion/fragmentation.

At the top, 51MB virtual memory left, combined with app domains getting unloaded/reloaded.

You can increase memToLeave to leave more space for app domains and such (should reduce...

garudatx (11/16/2011)

---

Hi,

I have some fairly simple SSIS jobs that load tables via several "Execute SQL task"

then I do BI-Cube processing and such...

{ Some Back ground before you ask:

I am...

(BALLPARK Numbers. No two sql server instances have the same workload.)

Dedicated to 1 instance of SQL Server (leaving 1.5-4 GB for the OS):

GB RAM/Max Memory Setting

8/6

16/14

32/29

64/60

128/124

If you've got more...

Have you tried adding an extra redundant

and fk_partymain between 1 and 1000000000

Below is an example to do what you asked.

However, I strongly recommend against taking this approach.

The value that was 5 per cent greater than the now non existing...

Instead of drop and recreate, just rebuild the index. It's cheaper.

I would check out the index usage stats, and compare usage against fragmentation, you might be able...

jeronym.vasica (11/13/2011)

---

<snip>...

The second question:

Is it possible to have a column with the datetime data type showing only Month-Year format of a date? If yes, how?

Thank you kindly for all your...

Alan Naylor (11/13/2011)

---

I have a 1.3TB database. The previous guy didn't do any maintenance and now the server is about to crash. The tables needed to be partitioned the indexes...

subbareddy542 (11/13/2011)

---

Pls find below table is input.

id todate ...

can you post this file:

11/11/2011 20:26:00.697 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2494120_sqlrun_sql.msp.log

Also, turn on msi logging (google voicewarmupx) and post that log file...

You can run an ETW trace on the client to capture detailed tracing from all of the sql drivers ( SQLNCLI, SQLNCLI10, ODBC, MDAC, .net SqlClient, .net DataSet/Table/Row/Adapter's, etc) including...