That's a pitty ...

I might have been able to refer to http://technet.microsoft.com/en-us/library/ms189472.aspx

and others might have been able to learn from your question.

There are no stupid questions ... except for some...

SQL Kiwi (9/28/2011)

---

Grant Fritchey (9/28/2011)

---

Jack Corbett (9/28/2011)

---

Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET...

😉

Jack Corbett (9/27/2011)

---

Trey Staker (9/27/2011)

---

@craig-2

Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's really pricey but I got...

this may be to primitive but you could just use a try catch block to try get-cluster or get-clusternode and have the catch block handle stand-alone servers.

GilaMonster (9/26/2011)

---

ALZDBA (9/26/2011)

---

Which db would you need to checkpoint (flush) for the sqlserver errorlog to be able to cycle ?

master only or would it need all db to be flushed...

If it is only loading csv data you might as well choose then new powershell approach:

Loading Data With Powershell[/url]

It comes with all advantages of a scripting language which are nice...

euhm did you know the SQLEngine now performs checkpointing by database ? ( apparently ever since SQL2005 )

Which db would you need to checkpoint (flush) for the sqlserver errorlog...

Indeed a nice article, Gail

Another one to be ref-ed in the fora fairly frequent 😀

Roy Ernest (9/22/2011)

---

...

I did a presentation on SQL plans to our user group. Just the very basics. (Of course I did a big reference to Grants ebook and book). That...

Gianluca Sartori (9/21/2011)

---

Stefan Krzywicki (9/21/2011)

---

That sounds pretty funny. I'd think if it were really the best, the consultant would be able to say "Oh, you just have this configured wrong,...

Roy Ernest (9/21/2011)

---

Apologies in advance for the change in topic... 😀

I want to do a presentation for the SQL saturday that will be conducted in Curacao. Can I have some...

Jim Murphy (9/21/2011)

---

...My mother in law just died last night. Been a rough few weeks. She was old and in a nursing home for a while, so it was expected....

Books online (SQL2008R2) "Database Mirroring Overview" states:

Database Mirroring Support

Since SQL Server 2005 Service Pack 1 (SP1), database mirroring partners and witnesses have been supported by Standard and Enterprise Edition. But...

SQL Kiwi (9/18/2011)

---

The original specification calls for quantity, not total price (that's why I used...

SQLRNNR (9/18/2011)

---

ALZDBA (9/18/2011)

---

Lynn Pettis (9/18/2011)

---

bitbucket-25253 (9/17/2011)

---

Ninja's_RGR'us (9/17/2011)

---

Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.

Now all I know about Oracle...