DBCC SHOW_STATISTICS(N'[dbo].[StgVendItem]', N'XIE1StgVendItem')

WITH STATS_STREAM

Executing the query "EXECUTE master.dbo.xp_create_subdir N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\BDSBPM' " failed with the following error: "Cannot create a file when that file already exists."

I have been badly burnt...

I would definitely build clustered indexes on 1GB+ heap tables and would seriously consider applying compression to those indexes.

L' Eomot Inversé (12/28/2012)

---

Sean Pearce (12/28/2012)

---

As mentioned in the reference URL you can either use the TABLOCK hint, use TRUNCATE TABLE or...

Hugo Kornelis (12/26/2012)

---

Basics? That's not how I would describe it!

Thanks for a good question, Sean. I think I once read or heard that after deleting all rows...

This is what Books Online says:

Creating a PRIMARY KEY or UNIQUE constraint automatically creates a unique index on the specified columns. There are no significant differences between creating a UNIQUE...

http://www.sqlservercentral.com/articles/books/94937/

Thanks for the kind words, a real compliment from professionals in my industry.

IF EXISTS (SELECT *...

create table #temp (customer varchar(15),number int)

insert into #temp select'A',1

insert into #temp select'B',1

insert into #temp select'C',1

insert into #temp select'D',1

drop table #temp

What is the expected results of selecting 25% of the above?

Have you updated stats? You have some serious under-estimations with the large table.

Clustered Index Seek

[DS_GreensDK].[DCL].[CompanyToken].[ix_CL_DCL_CompanyToken]

Estimated Number Of Rows : 309

Actual Number Of Rows : 13,807,291

http://en.wikipedia.org/wiki/SQL_injection

Eugene Elutin (12/11/2012)

---

Sean Pearce (12/11/2012)

---

ALTER PROCEDURE [dbo].[usp_delete]

@tablename sysname,

@pid int,

@pidname varchar(10)

AS

DECLARE @sql NVARCHAR(MAX),

@params NVARCHAR(MAX);

SELECT@sql = 'DELETE FROM [' + @tablename + '] WHERE ' +...