I'd change that definition just slightly. It means that the string passed will be unicode. This would be for use with NVARCHAR, NCHAR and the other fields and/or parameters in...

Generally, rather than create statistics, I just create an index. It's a fairly rare circumstance that requires you to manually build and maintain statistics rather than simply have an index....

Wow! That one is busy. Thanks for posting it.

Interestingly enough, it's not returning query text for the blocking process either.

Now that I think about it, maybe it's my test. I'm...

I'm still a bit confused by the question.

By and large, understanding what's occurring at lower levels within the system is useful, but shouldn't be a day-to-day worry. Rather than be...

Because, right now, I'm utterly confused what storing an IP address has to do with "auto locking" which is the title of the post.

Is this 2005?

If so... GOTO? Oooh, yuck. 😉

Using TRY/CATCH you can then do as Gail suggested and fire off RAISERROR which will automatically move you into the CATCH statement. Much...

rajesh_281984 (12/3/2008)

---

Thanks to all of you guys for giving me good information and the code is working fine now. Can u guys suggest some stored procedure samples that i can...

We mostly use schemas for storage requirements or security, but I don't think simple organization would be an issue either. I also agree with Jack, if you have to combine...

It's much easier to answer questions on the forum if you provide a very clear, focused and detailed question. Really general and vague questions can only be answered in general...

Another word of caution for the DTA. I recently ran a series of experiments using the DTA against AdventureWorks2008. It wasn't capturing obvious indexing issues. I don't trust it at...

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

One minor detail in addition, run update statistics will full scan.

If you're simply manipulating data, no, system tables aren't affected... well, OK, changing data can change statistics, so where the statistics are maintained can be changed, and if you have...

Mike Levan (12/2/2008)

---

I am tryingto automate re indexing based on the fragmentation.

some thing like this.

IF @frag < 30.0

...

"You don't know the power of the database"

Oh boy, we can have fun with this one...

"Don't fail me a again, programmer"