Please do not repost..all replies should be redirected here

Thanks...

You can find the updates you installed on your machine in your control panel.

To uninstall this hotfix, follow these steps:

1. Click Start, click Control Panel, and then...

srilu_bannu (1/11/2010)

---

Here is the problem my fragmentation does not change Since i have many small tables even if i rebuild the indexes (if you look into my previous posts...

Lynn Pettis (1/11/2010)

---

I'd love to see it, just don't seem to...

Maximum connections are limited to 32,767 for both SQL 2008 and SQL 2005 and you can edit that from your server properties tab, but I do not suggest you modify...

any way you could roll back this hotfix ??..see if that fixes your problem.

It is always recommended that any hotfix or CU be thoroughly tested before deploying to any critical...

It depends on what you are doing.

If you are running queries that join between tables in the two server instances, and transferring large amounts of data, then you have a...

nikhil8960 (1/10/2010)

---

SQL champions, I am new to SQL BI and wanted to learn the SSAS and SSRS part. Can you suggest me which thing I need to start learning first....

You should look for how much memory the server has..and if you are facing severe memory issues then it would confirm that you have insufficient memory.

select * from master.dbo.sysperfinfo where...

As far as I know..google works fast enough in...

You must be able to see the job properties if you remote into the server.

type services.msc in start-->run and locate the service name for the instance you want to stop. It should be something like devsvr\sql01, devsvr\sql02.

Thanks..

srilu_bannu (1/6/2010)

---

Hi ,

I want to schedule this query which rebuild indexes based on fragmentattion and the Database in the query gets updated daily at 6:00 AM.Since the database...

Did you need 24 different flat files?

Krasavita (1/8/2010)

---

What is the configuration of the development server (total server memory, disk drives (raid type or not, etc)? How are the instances configured (min/max memory, etc)?

How can I...