CirquedeSQLeil (12/18/2009)

---

I've been tempted to get a netbook but can't justify a netbook over a laptop when the prices I have seen are nearly the same.

Can you help me with...

I've been running SQL Server with Word open while I worked on a document and used Snagit to do screen captures at the same time. No issues yet. I'm going...

This won't completely answer your question either, but it'll provide quite a bit of information for you.

Use the the dynamic management views for indexes. I'd suggest starting with sys.dm_db_index_usage_stats. You...

Steve Jones - Editor (12/18/2009)

---

Grant Fritchey (12/18/2009)

---

I ask you, is it realistic to add & drop the same user 15 times in a row? Of course not. However, if you...

GabyYYZ (12/18/2009)

---

Grant Fritchey (12/18/2009)

---

I'm running the 2008 R2 Enterprise on a netbook in Win 7 with 1gb of RAM. It won't win any speed contests, but it functions, barely. Yes,...

Gail already told you how to see what's taking the longest.

Identifying which stats are useless is difficult. You'll have to monitor the servers for a long period of time and...

The statistics on the Voucher table look like they might be out of date. Estimated row count = 149 and actual = 4850298. Same thing with the loop join. It's...

The order in which you place these things and whether or not you place the criteria in the ON or WHERE cluase (at least for INNER JOINS) does not matter....

I'm not sure if it's a skill, although it must partly be.

One old story. I wrote an app for managing user access to a database and turned it over to...

There are a number of ways you can do this, but in general, I'd take what you're doing with trace events (and I'd only capture rpc complete and sql batch...

What data type is date_out? Can you post some sample data from it?

BTW, running that function on your column in the WHERE clause will prevent indexes from being used.

I'm running the 2008 R2 Enterprise on a netbook in Win 7 with 1gb of RAM. It won't win any speed contests, but it functions, barely. Yes, you can do...

Unless you're in a situation where your database is consistently too small and the auto-grow is set too low, space is seldom the cause of performance issues.

You said you looked...

All stats for a table were necessary at one time or another or they wouldn't be there. It is possible though that system generated statistics on columns without indexes may...

Glad that it worked out.