Thanks Grant!

A quick look by using SET STATISTICS IO ON may give you some information. A more in depth look would be looking at the Actual Execution Plan. Can you post...

Jeff Moden (4/5/2012)

---

SQLKnowItAll (4/5/2012)

---

GilaMonster (4/5/2012)

---

My question would be why do TOP <x> in an EXISTS when the point of an EXISTS (or NOT EXISTS) is to terminate as soon as...

GilaMonster (4/5/2012)

---

My question would be why do TOP <x> in an EXISTS when the point of an EXISTS (or NOT EXISTS) is to terminate as soon as it finds a...

As Lowell mentioned... If they are ALL accessing the db through an application server, you will not be able to delineate it. The host is the application server, not the...

No, SELECT TOP 1 1 will return 1 if there is at least 1 record. I think that is...

You sure can. Best to put it in a stored proc and call the proc from Excel or SSRS. Also, I just did a blog post on window functions (rank(),...

tobinare (4/5/2012)

---

Here you go.

USE Master

GO

CREATE DATABASE JoinTest;

GO

USE JoinTest;

GO

CREATE TABLE Customers

(

CustomerName varchar(50),

Addr varchar(50),

City varchar(50)

);

CREATE TABLE Products

(

ProductName varchar(50),

Descr varchar(50),

Price money

);

CREATE TABLE Sales

(

SaleDate datetime,

ProductName varchar(50),

CustomerName varchar(50),

Quantity int

);

GO

INSERT INTO Customers VALUES ('Ken', '123...

Best to tell us what changed between the 2 servers:

CPU change?

Memory change?

SQL Version change?

Windows Version change?

IO Subsystem change?

Activity higher?

More databases?

Server settings change?

SQL Server settings change?

Network change?

Then... What changed between the...

You would want a CTE to sum up quantuty and price when grouped by customer, product. Then sum up the price grouped by customer.

anthony.green (4/5/2012)

---

the issue is with FILEPROPERTY, its specific to the database context its running in

From BOL

file_name

Is an expression that contains the name of the file associated with the...

sqlnaive (4/5/2012)

---

Exactly and thats what my point is...

USE DB1

SELECT * FROM DB1.dbo.Table1

and

USE DB2

SELECT * FROM DB1.dbo.Table1

gives same result [as they both refer to smae table in DB1]. Same way the...

sqlnaive (4/5/2012)

---

SQLKnowItAll (4/4/2012)

---

It is because you are still referencing the view in Database1 by fully qualifying it. If you want the USE keyword to do anything, you have to change...

Check this out for info on mirroring: http://www.sqlmag.com/projectplans/migratingtosqlserver2008r2/detail/tabid/4568/catpath/sql-server/topic/Database-Mirroring-in-SQL-Server-2008-and-SQL-Server-2008-R2. Lynn summed it up though on what you can do in Standard for mirroring.

allen.mceuin (4/4/2012)

---

SQLKnowItAll (4/4/2012)

---

SQLKnowItAll (4/4/2012)

---

I think the point is, from my perspective, that with the usage of this server you are more likely to have a motherboard issue than a HDD...