tests.var_id IN CASE WHEN t3.PMN1='1' then '(392,393,394)'

WHEN...

SELECT

c.name AS [schema_name],

b.name AS table_name,

a.row_count

FROM

(SELECT

ps.[object_id],

SUM (CASE WHEN ps.index_id < 2 THEN row_count ELSE 0 END) AS [row_count]

FROM sys.dm_db_partition_stats ps

GROUP BY ps.[object_id]) AS a

INNER JOIN sys.all_objects b ON (...

Partitioned Tables and Indexes in SQL Server 2005

GilaMonster (7/17/2008)

---

Fully...

You should also look into the NEWSEQUENTIALID ( ) it can help a lot in these cases.

Try:

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;HDR=Yes;IMEX=2;Database=E:\test.xls;',

'SELECT * FROM [$Sheet1]')

litu deb (7/16/2008)

---

In transactional replication,I am getting the following error..

Could not drop article. A subscription exists on it. [SQLSTATE 42000] (Error 14046) exec sp_AddArticle failed in sproc_AddArticleToPublication [SQLSTATE 01000]...

Take a look at :

sp_removedbreplication @dbname = 'db_name'

Nicole (7/17/2008)

---

Hi guys,

i have 20 tables in our prod db, we are doing t-replication of 10 tables and working fine, now they have created a new table in prod and...

You should review the query plans to see if your server is performing as you expected.

By the way, did you updated the stats /rebuilt the indices after the migration ?

Note: To speed this up you should have indices on all Datetime Columns!

CREATE NONCLUSTERED INDEX IX_ItemCPriceLog ON ItemCPriceLog( Entered )

CREATE NONCLUSTERED INDEX IX_ItemBPriceLog ON ItemBPriceLog( Entered )

CREATE NONCLUSTERED...

Select Entered as EffectiveDateTime

, (select top (1) ItemCPriceID from ItemCPriceLog C where dte.Entered >= C.Entered order by c.Entered ) IDC

, (select top (1) ItemBPriceID from ItemBPriceLog...

A word of caution, "hints" are just that "hints". The optimizer will "try" but there could be cases in which it can't. This, is one of them. You should avoid...

But I would go even further. When you find yourself in this situation you should try to call the webservice from the "CLIENT" not on the server.

There are many...

Ugly, I know but it could get you closer to the truth 🙂

declare @t table (s varchar(100))

insert @t (s)

select 'ANALYSIS...