Hi everybody

Thanks for taking the time to answer the question and for your feedback.

I'd like to explain the reasoning behind this question. There were several things that I wanted to...

Knowledge Hunter (8/23/2011)

---

We update or delete around 10-15% of the total tables.

For deleting the data we need to search the data using a where clause on last modified date. Isn't...

Are both databases on identically specced servers?

Do both databases have identical storage systems?

Are both databases using the same edition of SQL Server?

Are both servers under a similar load....

I can attest to this. There are a lot of mediocre candidates out there that I wouldn't let near an Access database, let alone SQL Server. I suppose this is...

You can change your nickname in Control Panel --> Registration Details.

WHERE PORT_CD = 'BEZEE'

AND ARRIVAL_SCHEDULE_DT < = dateadd(mm, 3, getdate()

Hi Steve

I'm going to have to pass on this. Workload means I don't currently have time to write an article that adds any value compared to what is already out...

lbohm 63578 (7/6/2011)

---

Hello!

I commonly write stored procs that handle add/edits to a single table. If the ID value passed in is zero, then it adds the record to the table....

You can't parameterise a schema as such.You need to create a dynamic sql string and execute that.

Perhaps your server is under a heavier load in the morning.

Perhaps it hasn't woken up properly...

If its a Windows app, how about the following which is standard practice:

Set up a windows group and give this permission to your database. In turn you can add users...

I would love to attend that. Hopefully they will do the event in London next year when i'll be on a sql server...

Visual studio express is free and has most of the things that you need to create a prototype. There is also 'lightswitch'. This is very new and is possibly Microsoft...

As with most SQL questions - it depends...

I hate to say this but 'it depends'. For an oltp system you would want less indexes - but enough to give you acceptable performance. For a reporting system which...