Another option on the parallelism is to look at the cost threshold for parallelism. That's usually left at the default value of 5 which is WAY too low for most...

The optimizer doesn't believe that all six tables are needed in the query. Just saying. It's using a subset of what you defined.

Unless you're in a situation where you are already CPU bound, I would absolutely enable compression on backups. Usually, most systems are IO bound. If you can reduce IO, it's...

CXPacket waits are an indication of parallelism. Not to say that parallelism is the issue, just that it's going on. Something you'd have to validate.

The latch waits are absolutely and...

You've got a two second compile time on a query that's not all that complex. But, you're referencing six tables and the optimizer is only pulling data from four (plus...

Take a look at the execution plan to understand what's happening with the query.

You've got two options there. Well, actually, you have to do both. First, talk to the business people to understand what they're actually going to do, not what they're asking...

This is a gigantic topic.

I'm not going to be able to give you specific guidance based on a generic problem as you've outlined. Sorry.

It sounds like you're creating a "report...

Best way to learn the basics is by doing. You've already been pointed out how to get a copy of SQL Server to play with. Next up, a project. Start...

I'm pretty sure that it just comes down to the fact that while processes are distributed, the work isn't and one node can be done most/all of the work while...

winmansoft (2/5/2013)

---

Thank you

My actual doubt now is what is difference between user mapping page(which shows permission like datareader,dbowner etc) and one under database->security->any user.Right click user and click properties.Now u...

You can't turn that part off.

The only thing you can do is run the two delete statements inside a single transaction. Then, the data gets deleted, effectively, together and at the same time. But the...

Deployment Manager is focused currently on .NET code & databases.

I've never seen anything yet that can do SSIS, SSAS, and SSRS on top of everything else. I helped build a...

Just remember that the user defined muti-statement table valued function works off the construct of the table variable. the table variables one defining characteristic is it's lack of statistics. So,...