If you're talking data changes there's no automatic auditing within SQL Server by default. You can look to extended events as a mechanism to see all data changes by capturing...

DISCLOSURE: I work for Red Gate Software.

I've used all the major tools and most of them against a production environment. Each of them does different things for you in varying...

Shadab Shah (2/6/2013)

---

GilaMonster (2/6/2013)

---

If you use the detailed option, index physical stats shows you all levels of the indexes, so that'll be leaf and non-leaf (root if there's only 2)....

k.srikalyan (2/6/2013)

---

Try to create a primary key/unique key on your table variable, and it is always better to go as a stored proc using temp tables and while loop...

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...