nagnrik (11/11/2008)

---

Thanq Kishore..

sp_configure 'min server memory', 1024

RECONFIGURE

GO

sp_configure 'max server memory', 6144

RECONFIGURE

GO

In the preceding example for SQL Server and Windows Server 2003, the memory settings direct the buffer pool to dynamically...

nagnrik (11/11/2008)

---

Thankq Kishore!

And one more Doubt ..

We have Windows Server 2003 EE 32-bit X-86 and SQL Server 2005 EE and RAM about 8GB....

I am gonna specify like below,

Minimum Memory :...

bicky1980 (11/10/2008)

---

For now - just the once - But I know of other instances when I will want to copy a table from one database to another - Are we...

nagnrik (11/11/2008)

---

Thank you Kishore! Thank you very much!

I never gotta know that SQL Server can only use 2G of RAM for its Cache Memory.. This is really good.

So, AWE is...

nagnrik (11/11/2008)

---

Thanq

I still have a doubt on my mind!

What exactly this AWE?

Is this additional memory other than RAM and Paging memory?

How SQL Server uses it? How about RAM then...

sramesh02 (11/11/2008)

---

Our Sql Server database log file size increasing huge and also not able to shirink database.

may be some problems with sysindex table becuse we ar trying to retrive data...

arun (11/11/2008)

---

Hi All ,

I have a problem executing a ssis package using the xp_cmdshell command. I built a string with all parameters for ssis and passed the string to the...

Script...

there is no CTE command in SQL 2000, it' available in SQL 2005 and above editions.

If you are using SQL 2008, see the link: http://msdn.microsoft.com/en-us/library/bb677173.aspx and your problem was resolved.

😎

* use DBCC SHRINKFILE for more info see SQL BOL

* set the log file growth to restricted mode.

use SSIS to transfer the data.

Below Links may help to solve the problem:

http://technet.microsoft.com/en-us/library/cc990273.aspx

http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx

nagnrik (11/10/2008)

---

My Remote Query Time out and Query wait found set to Default

as well as

Minimum Memory per Query is also found Default (1024KB)

and more over

How about AWE? How...

make a connection to database in your visual studio database project and do what ever modifications you do and then deploy to database.

use "uniqueidentifier" in your table.

use Isnull function in Print statement (eg: print isnull (@L, 'Not found') ). Becauase if variable have any null values, print statement won't display it.