steven.girard (11/18/2011)

---

It all depends who is asking.

Technical person (mostly information sector): ETL Developer

Semi-technical (people in the business): BI Guy

Outside World: Programmer

If I have questions regarding whats a programmer, "I work...

Chad Crawford (11/17/2011)

---

Wahoo! Just passed the MS 70-453 test, making me a MCITP for SQL 2008 just in time for 2012 to come out. 😀

Very happy - Passing...

SQLDCH (11/17/2011)

---

Jets vs Broncos tonight, don't forget to get those lineups in.

Just three weeks left, lots can happen. I think the <artist formerly known as LOJ> is the only...

First, is this SQL 2000?

Second, what do you mean a recovery state or recovery process? Any query could potentially block other work and make the server appear to be unresponsive.

If...

Very cool talk, if you haven't seen it:

http://www.brentozar.com/archive/2011/11/how-stackoverflow-scales-sql-server-video/

Two things I can think of. And you might need to run a trace/profiler session as you run the MSI to check. Make sure you run the code from the...

You can connect multiple databases to the same branch in a VCS.

Suppose you create the SalesDB project/branch in VCS (Subversion/Git/etc). That is done outside of SQL Source Control, and potentially...

1) you don't put your sql server in subversion, or any VCS. You check in changes of the objects into the VCS. The benefits are that if you need to...

You want to select from the main table in your insert, so

SELECT ...

FROM tblSCR t

Then join that with the deleted table to look for previous status.

INNER JOIN deleted...

It sounds like something broke the connection in the install. I'd tend to agree that it's not rights if you use the same connection/credentials to run all the queries and...

Can you snapshot the mirror db and run checkdb there to see if the same errors occur?

First, please debug the consistency errors, and potentially call MS bfore you run this. If it cannot fix linkages, it will drop pages and remove data. Not what you want...

So the date is stored as an offset, not as '2011-11-12'.

Is the date stored as Nov 12 or Dec 11? That's what matters. The display is separate, but if...

I do that sometimes, not necessarily 10 sec, but maybe 15, or something else. It's fraught with danger, and I do end up making mistakes, but I might be talking...

Here you go: http://www.sqlservercentral.com/Forums/Forum3053-1.aspx