SJTerrill (11/23/2009)

---

One option is removing the criterion from the WHERE clause and adding it to the JOIN clause as an AND, though I haven't looked closely at your syntax.

--SJT--

P.S. This...

Garadin (11/23/2009)

---

I'm confused, how is it you are expecting the name to be equal to something and nothing at the same time? You're comparing the same field to 2...

SJTerrill (11/23/2009)

---

Given that the WHERE clause includes criteria for the table on the 'right' side of the 'left' outer join, I think you've created the equivalent of an inner join......

DECLARE @dblist TABLE (dbname NVARCHAR(100))

INSERT INTO @dblist (dbname)

SELECT sd.name FROM MASTER.dbo.sysdatabases sd (NOLOCK)

WHERE sd.NAME LIKE 'HotDog__XYZ'

IF EXISTS (

SELECT [CountryCode]

FROM DBUtilities.dbo.Country...

Paul White (11/16/2009)

---

Roust_m (11/12/2009)

---

as for the fourth, the size of the row is under 1000 bytes,...

Ok, the fragmentation I am talking about can be taken out of this query:

SELECT avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(), OBJECT_ID(N'dbo.Company'),

NULL, NULL, 'LIMITED') AS s

...

If I am NOT using "set identity insert on", why this would happen?

No, this is the script for the table:

CREATE TABLE [dbo].[Company](

[CompanyID] [int] IDENTITY(1,1) NOT NULL,

[Col2] [nvarchar](100) NOT NULL,

[Col3] [nvarchar](100) NOT NULL,

[Col4] [nvarchar](150) NULL,

[Col5]...

Ian Scarlett (11/12/2009)

---

A few possibilities:-

Deletes leaving a gap where the row was.

Updates that change the size of the row, forcing the page to split

Inserts into the table that rollback before...

No, not at all.

villersk (10/23/2009)

---

can you partition the table? this way you could insert into a swap table and switch the data in. Partition switching is crazy fast in 2008. I have no...

ALZDBA (10/23/2009)

---

The primary question was "... will the system block if I drop the synonym and recreate it to point to the new object with ongoing operations ..."

And off course...

Jeff Moden (10/22/2009)

---

Heh... "It Depends".

It all depends on how you load the data (ie: IDENTITY_INSERT) and whether or not an IDENTITY column is even needed. I don't see an...

Roust_m (10/22/2009)

---

Elaine Reeves (10/22/2009)

---

Have you thought about having 2 indexed views, pointing to the different tables. One for loading the other for use. Then, once the new data...

Elaine Reeves (10/22/2009)

---

Have you thought about having 2 indexed views, pointing to the different tables. One for loading the other for use. Then, once the new data is...