Alan.B (1/15/2014)

---

You are correct Grant. I did not mean to contradict anything you were saying. Frankly, I would not have posted anything if I had first seen that you or...

Very little to go on there. Usually these things are due to security settings. Does the account that you set SQL Server up to run under have the appropriate access?...

One more, we recorded a two-part webinar[/url] for Red Gate (who I now work for, didn't when I wrote that book) on deployments. Part two is primarily around Red Gate...

I wrote several chapters in a book called, SQL Server Team-Based Development[/url]. Now, some of the work is WAY out of date since the technology has moved on quite a...

katrina92886 (1/14/2014)

---

I am sysadmin -- I would certainly hope so, seeing as I am a free-lance developer (at this point) using my own laptop for everything.

"capturing query metrics using extended...

Nope. And I'm starting the rewrite on the chapter on...

Not sure. Could be they weren't there when you created the plan? Could be you have async statistics enabled on the database which means plans can be created without statistics...

Good idea, in general, to use trace events, but Profiler the GUI is not the best thing to run against a production system. Best of all, since you're in 2008,...

I would use system administration ownership for packages and databases, yes, but not the 'sa' account. Two different critters.

Ah, a remote server is tough. You either have to have a tunnel to it through the firewall (and that's whether or not you're using SQL Compare) or, you have...

Sean Lange (1/14/2014)

---

Here is a true story from the field that a buddy of mine shared with me yesterday.

Yesterday my supervisor sent me an email regarding a view that wasn't...

New Born DBA (1/14/2014)

---

This is the Query that I was running and it executed in 32 seconds. I checked the index fragmentation as well and its only 10% fragmented. Is...

I'd probably try to isolate the big systems to a single box each and then cram all the small systems onto one box and let SQL fight it out there....

Instead of doing the top 1000 rows gui exploration of data, what if you just write T-SQL and look at the data that way, does the same thing occur? I've...

Generally it's not a good idea to RDP into a production server, especially to just run queries. Remote connections through SSMS on your desktop are safer.

But, that's probably not...