Thanks Gregory for the positive feedback. Unfortunately I do not have hard numbers to match what I have said. The main reason is that the profiler does not show any...

Hi Drew,

Thats an interesting question. I am not sure I know the answer to that without testing for it. I have never been able to test for it since we...

Hi Drew,

Yes, there will be a performance hit in certain scenarios. Let us say the schema qualifier is DBO (Owner) and you are executing the stored proc as the user...

Thanks Jack. I am glad you found that it explains the point I am trying to make.

Thanks for reading the article. When you use sp without an underscore, there are no issues. This happens only when it is sp_. The basic reason is because the system...

I got the review all right. As per management, I am an excellent worker. I have been promoted from Junior DBA to Senior DBA, but the pay is no were...

Grant Fritchey (3/7/2008)

---

May as well pile on...

Good Job Brandie. I couldn't agree more.

Enjoying the work allows you to bring passion to the job. That passion will translate to...

You can run it every night but it does not have to be Dynamic SQL. Why complicate your life when you can do it without. You know the name of...

Do your basics right, and try to follow a standard the first time itself. That is going to help you a long way when writing any code, whether it is...

lol, thats a good one. I have it on our DBA Cubicle...:D

Thats a pretty big topic to discuss like that. One of the most interesting thing I noted is the two Snapshots that has been introduced. “SnapShot Isolation” (SI) and “Read...

You should be good as long as you have created the dependent object at a later point of the script. It will associate itself if the object is there.

This is interesting. You guys and ladies have the most knowledge in SQL (In ALL areas) and you are trying to show how much you dont know. Should others start...

I believe the person wants to do the query based on the year and month....

Did you try logging on to the SQL Server using the Login you just created? I think you will be able to log in. It is just that the management...