Based on your reply to #3, my posted question is probably going to be wrong. I'll have to revise it (when I have time).

Can you help me by posting some...

salardx (1/21/2016)

---

Guys! please!

We CANNOT have much indexes in the tables (neither one table for each month, nor 10,000 tables!)

because data is bulking into the tables! 1000 records on each bulk!...

bebe022476 (1/20/2016)

---

HI Gail,

Here it is:

DocumentID(PK,int,not null)

DocFolderID(int,null)

PublishToWeb(bit,null)

Filename(varchar(100),null)

Filesize(int,null)

ModifiedDate(datetime,null)

TableName(varchar(40),null)

EntityCode(varchar(12),null)

I'm not sure how to attached the jpg screenshot here but the execution plan only has 100% Clustered Index Scan(Clustered) on [document],[pk_document] .

The job normally...

Here's my standard pattern for optimizing a query that needs OR. It might give you two index seeks instead of an index scan, but only if there are usable indexes....

PSSQL (1/20/2016)

---

I am using ADODB in two programs written in VB and Delphi that interfaces with an SQL Server Express 2008 R2 SP2.

Using the code below, sometimes I get the...

Not a 100% sure if it fits your issue perfectly, but I think that Red Gate's...

It is indeed possible to do this calculation without a cursor. I tried a few approaches and stuck with the one below. I think it's relatively easy to understand, and...

Good, I am working on this now, and I hope that I can post some ideas shortly. But first some first observations.

1. I am so happy to see a post...

When I attempt to run the CREATE TABLE statements you posted, I get a ton of errors. Please create an empty database, run the code yourself, and fix all errors,...

@dandrews: For future reference, what J Livingstone posted is a good repro script - CREATE TABLE and INSERT statements that people can simply copy/paste into SSMS and run to replicate...

This looks like a fine point to refer back to what I wrote before:

"Next time you ask a question, please provide CREATE TABLE statements for tables involved, INSERT statements with...

Good. Because I notice that after reading your descriptions I am almost tempted to slide into...

For production systems, most companies like to do daily full backups, plus transaction log backups every 15 minutes or so. If the activity is fairly low, you could change that...

Probably something like this:

INSERT INTO dbo.fecon2

(ProductCode, Warehouse, Other, Columns)

SELECT s.ProductCode,...

Igor's code gives you the number of week boundaries. Which means the number of transitions from either Set to Sun, or from Sun to Mon - I can never remember.

If...