Great I will do that. Probably will help also that I just bought a few books from red gate that can also help with understanding these DMV's alot better.

Thanks. Sorry for asking probably what seems like a basic question. Again thanks for the correction to my query.

That worked great. Thanks. So what would have caused the duplication of index record names and different fragmentation information?

EDIT

Ok I think I understand now what this happened. Since sys.dm_db_index_physical_stats has...

Thanks I will look into that. I am currently using the Real world 70-432 and 70-450 cert. But I did buy a lab book from amazon.

I am not facing any issues. I am just trying to think of things to do that will help me pass the certification.

For example setup user A and give...

Great. Thanks for the info. This won't only help for rebuilding the indexes in production but also for my studies on the 70-432.

Again many thanks.

Ok but what happens if I do a rebuild. Will it put a lock on the table? All of my instances are standard. If it does put a lock on...

I could be wrong when I say this but the round function rounds on the tens. Using your example 158.98 would be 159.00.

The range I believe is

158.95 -...

Ok so I ran out of options. But I did some searching for you and I was able to find this article that might shine more light on the issue....

One thing that stuck out to me was the port. By default SQL Server operates on port 1433. IF your told to use 1443 then just disregard that last note.

Just So I understand You are wanting to know what users are accessing your database from your application? Are the users using trusted connections IE (their windows logins) or a...

Is this a web based App that is throwing the error? Or are you tyring to connect using SSMS to your Hosted SQL Server.

I am going to make a...

andre-394971 (1/28/2012)

---

Hello There,

I have been playing around (no pun intended) with the floor and rounding functions in sql 2008 but not getting the result I need

If i have a dollar...

Ok when I tried it, I got the same results as you. But what I figured out was use 1 instead of 2. The problem that you are having is...

You could also use the Activity Monitor. Just Right Click the SQL Instance and choose Activity Monitor. Then choose Processes. It will list who is connected and to what Database,...