SQL server doesnt automatically create indexes, except in certain cicumstances such as when you define Primary Key, Foreign Key and Unique Key's.

All others have to be manually generated by developers.

Most companies run the SQL backups then have the backups committed to Tape or transfered to off site repositories.

Previous employers I've worked with have then generally run quarterly DR tests...

As anthony thought Full Text Search doesnt handle Leading wildcards, only trailing wild cards which may explain the differences in the results being returned (Unless this has changed in SQL...

As far as I can remember this is standard response.

Although you can specfically set the SET NOCOUNT option under Options->Query Execution->SQL Server->Advanced

Is it possible you had this checked in previous...

Itzik Ben-Gan's T-SQL Fundamentals is quite good, and it has quite a few examples at the end of each chapter that also has the solutions so you can match it...

Nice article, I dont see the problem, as others have posted links to blogs etc.

In regards to the actual blog, it rings a few bells with something I'm seeing...

Thanks for the explanation Gail, I can sort of understand that now.

If the data is already in the database then you should be able to do

WITH CTE

AS

(

Select

ROW_NUMBER() OVER(Partition by UniqueColumn ORDER BY UniqueColumn) rn

,<columnlist>

From myTable

)

Insert into BULK Desttable

Select <colunlist>

from...

Correct you do get a No predicate join warning on the join in the Execution plan, and the predicate on the #tmp table shows as tempdb.dbo.#tmp.myColumn=tempdb.dbo.#tmp.myColumn.

It seems SQL is trying...

I'm curious as well it seems that if the column is in the outer Table it allows the IN (SELECT) to work

eg

CREATE TABLE #Tmp (

MyColumn Int Identity(1,1),

MyDescription varchar(100)

)

Create Table #Tmp2...

funkseo (12/11/2012)

---

I modified as following and I think it's little bit changed. I removed tep tables and use built-in paging.

ALTER PROCEDURE [dbo].[spGetSiteListFromTagPager]

@Tag nvarchar(64),

@page int = 0

AS

DECLARE @TagID int

SET @TagID =...

Thanks Paul,

It just seemed a little overkill for this scenario, but I have seen a lot of 'funky' stuff done with the outer insert on a merge though it...

Shouldnt the NOT IN be in the Where clause as the column you are filtering on is not directly related to the Join.

Paul,

Is there a reason you dont use the native OUTPUT INTO @C?

I'm familair with the constriants, everything looks like it should send the final email or an error email.

The problem is that if you are logged on as you it will...