Perfmon doesn't show that type of material. You'll want to capture query metrics using a server-side trace (not Profiler, don't run the GUI against production machines) or extended events. But...

I'd go with a pre-built script to do the heavy lifting. I like Michelle Ufford's scripts[/url] for doing this. Others like Ola Hollengren's.

If we're talking SQL Server 2012, you can use a SEQUENCE. There are a number of examples on the documentation page.

If you're not using SQL Server 2000, you should be avoiding aliasing users. sp_addalias is deprecated functionality. I don't even think it's available in SQL Server 2008 or higher. Also,...

You're either seeing long wait times, or blocked processes, or both. If you're seeing...

It depends on what you can afford on your system and, how much the indexes fragment....

Best of luck. You know where to go if you need more help.

I'd be curious why the plans are choosing to do scans. Assuming the distribution of the data hasn't changed, just having more data doesn't generally affect the statistics that much....

Maybe I don't understand the question, but you create a primary key using the add constraint command. It just so happens that any kind of unique constraint, and the primary...

MyDoggieJessie (3/7/2014)

---

Since this is a new position, it sounds like an ideal time to talk to your supervisor and relay the "you hired me because..." and "this is what we...

Jack Corbett (3/7/2014)

---

So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that it involves...

Well, it's not really simple. The issue is, you shouldn't be seeing locks held like that. It means the system is improperly put together. Not helpful I realize, but, there...

So, correct me where I'm wrong, but doesn't that just address deadlocks? The situation we're in here is not deadlocks, but blocks. Totally different. Unless I'm...

The only way you can do that is to somehow filter that out of your UPDATE query using the WHERE clause. There's nothing in the system that lets you update...

The only reason, other than outright compatibility issues, is price.

The licensing costs for SQL Server 2012 are different than 2008R2 and less. For most situations I've seen, they're more. So,...