You are right Jeff, can't argue about it - I assumed poster is already a decent DBA 🙂

dwain.c (2/23/2012)

---

I believe that most of the articles I've read on performance suggest you do it like this:

select istatus, dtmoveout, bmovedout, *

from tenant

where istatus in (1,4)

and dtmoveout...

Three main areas of development:

1- Performance tuning.

2- Business continuity.

3- and the, again, more Performance tuning.

Glad to help.

I'll take #4 for $500 🙂

When working with small databases even crappy code - better saying "sub standard code" appears to work properly and perform fine; on top of...

sqlfriends (2/21/2012)

---

I would like to find out if I run 4 update statements on a production server, will that lock the table, and affect users of the application.

It may take...

nscott 48570 (2/21/2012)

---

I'm trying to teach myself SQL; I apologize in advance if this is an easy question. I'm getting stuck on the following query b/c it is not...

Yes. ORDER BY clause must be specified on SELECT statements if a particular order is needed.

Adding to it, here is the beauty of it... even if a clustered index...

In my opinion nothing beats original documentation, please follow link next to Microsoft tutorials on SQL Server... http://msdn.microsoft.com/en-us/library/ms167593.aspx

gary.morey (2/21/2012)

---

I have a staging table (MergedDataStage1) that was populated by inserts from 2 tables. I now need to be able to insert the rows from this staging table...

Books On Line is installed alongside SQL Server so just go Start => All Programs => SQL Server => Books On Line

Two...

MikeBrey (1/30/2012)

---

Sorry about the delay, other projects and had to research what a temporal fact snapshot table was. If I understand it is a fact table that behaves like a...

Please do not cross post, it fragments and duplicates effort.

Answers here please: http://www.sqlservercentral.com/Forums/Topic1255246-391-1.aspx#bm1255263

1- Build your own lab - a.k.a. install SQL Server Developer Edition on a home computer.

2- Install an example database like Northwind

3- Read about architecture first then about the...

Assuming you are planning to use the same partition key please check ALTER TABLE SPLIT RANGE syntax, see http://msdn.microsoft.com/en-us/library/ms186307.aspx

Last but not least... I'm hopping this table is not being partitioned...