SSMS= management studio... scripting window

GUI = graphical user interface, like the edit view GUI.

Don't use the GUI, use scripts in SSMS..

David Conn (12/1/2011)

---

10 Pages.

worse part after the time it took was not knowing what I'd lost. The only upside is that it's a Data Warehouse and in percentage terms this...

100% OFF the list is far more accurate for the majority of folks actually.

Hey Joe, you could at least "correct" people with the correct queries.

t'was 1900-01-01 NOT 03

That'd be a last resort option. Usually you can remove that issue with better indexes, proper isolation levels and faster code.

Then if you want to be safer your option...

GSquared (12/1/2011)

---

My wife and I are celebrating our 21st anniversary today. As part of that, I'm taking next week off of work (my third vacation since 1988), and probably...

Did you read the blog post?

It does about 100 different things, all better than whatever the MP is doing.

This is a way better method of going about this.

Ninja's_RGR'us (11/29/2011)

---

Start traceflag 1222. Then when it happens again, go to the sql error log and paste the deadlock graph...

I've seen successful restores even if the dbs were live. that being said it's not the norm, hence you need to test.

Only 1 way to know... assuming you never tested the scenario.

Not too sure what you need to do...

this will pretty much never filter out anything.

select *

from

(

select '01-jan-1900' as DayBase

union select GETDATE() as DayBase

) a

where a.DayBase IS NOT NULL

Here's a hint!

SELECT CONVERT(DATETIME, '')

Google for the book or hit this download page 😉

http://www.sqlservercentral.com/articles/books/65831/

Free ebook, "index seek" for the right chapter

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Gail's fabulous articles

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

Wait stats tells you where your server(s) hurt!

/*

Cost threshold for parallelism (CXPACKET) http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

Paul White: Understanding parallelism http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/

Microsoft White Paper on waits...