What are the sizes that you are seeing? Include the sizes for the backup, all data files (mdf/ndf) and the log files (ldf).

Okay, so how large are the databases now - and is an autogrowth of 50MB large enough? ...

In addition to what Gail has mentioned, how much space is available in the data file? Do you have enough space available to rebuild indexes - or, do you...

Change your order by to a group by, and use sum:

SELECT Company,

Year,

SUM(CASE WHEN Quarter...

SQL ORACLE (3/10/2009)

---

Jeffrey:

I know someone set it incorrectly. I know I have to change it (to virtual IP). What I would like to do is collect input what impact I...

SQL ORACLE (3/10/2009)

---

Richard M (3/10/2009)

---

If you have the users connect to the node specific IP address, you are not doing anything to "help" in case of a failover, as ...

The virtual IP address will not change. The users connect to the virtual IP address and not the node specific address. Cluster administrator redirects the virtual IP address...

I don't think there is anything to be fixed. When SQL Server is running on node 1 - it uses the IP address for that node. Cluster Administrator...

As soon as you issue the above command, you can no longer restore to a...

I may be missing something - so please correct me if I am wrong, but don't you need to specify which server you are going to connect to and whether...

You can use a case expression:

UPDATE dbo.Person

SET City = CASE Extension

...

Harold Buckner (3/6/2009)

---

Most of the time when I use the "Script table as" option in SQL Management Studio it creates a Create Table script with all the columns. On this...

Well, I would have to guess that this information is stored in the SSIS package. You would have to export the package and open it in BIDS to verify...

another shot in the dark - but, run the following and let me know what you find:

SELECT * FROM dbo.sysoriginatingservers;

SELECT * FROM dbo.sysoriginatingservers_view;

Check the command line for the SQL Agent Job. The command line should have something like:

ESCAPE_NONE(SRVR) for the SRV parameter. Another shot in the dark...