First, let me say that I am not a programmer and don't really know VB.Net that well. With that said, I don't see anything wrong with the T-SQL that...

Since this is the default instance, you can type in one of the following to connect:

.

(local)

localhost

computername

Another option is to browse for more in the drop-down. That should give you...

Mani Singh (6/26/2008)

---

I have a 75GB Database and i have space constraints on the Drives and the SYSADMIN wont listen for the past 3 years.

So I only keep 1 days...

Do you want the new named instance to be clustered? If so, then yes - you need to add a new SQL Group, dedicated drives, etc...

If this new names...

Bryan Mischler (6/25/2008)

---

I have a query where I am trying to do multiple joins to the same table. If one of the rows in the ordercomponentvalues table doesn't exist,...

[quote-0Here is the order of operations:

Double-click a server name\ctrl-C\Connect in object explorer\Database engine...\Paste Server Name\Connect.

That adds up to 9 clicks and keystrokes (if my addition is correct).

8 servers multiplied by...

Jeff Moden (6/24/2008)

---

And, THAT is why I tell folks...

COUNT(*) AS TotalRows, SUM(case when Status='P' then 1 else 0 end) AS Present, SUM(case when Status='A' then 1 else 0 end) AS Absent

FROM Attendance WHERE sid=studentnumber

Now, how can I...

I think you can connect to MySQL using SSIS and extract data that way. Another method would be to create a linked server in SQL Server, create a new...

TheSQLGuru (6/24/2008)

---

DTA is like any other tool: if you KNOW how it works and how to use it it can be an effective device. But I have had...

How much free space do you have available in the database?

How big is the log file for this database? What is the recovery model for the database? If full recovery, how often do you backup the transaction log?

TheSQLGuru (6/19/2008)

---

My advice is to never use DTA at all!! I have seen it do AWFUL things to databases. Well, actually that works in my favor since I...

maruf24 (6/23/2008)

---

CHECKALLOC found 0 allocation errors and 0 consistency errors in database 'abc'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

AFTER CHECKALLOC

DBCC SHOWCONTIG scanning 'TABLE' table...

Table:...

Yes, that is possible - it means you have 10mb of data in the database and 30mb of space available (give or take a few mb) until the data file...